ETM5900
Assignment 1
Question 1 [Total 23 Marks]
A group of researchers are interested in studying the prevalence of obesity, diabetes, and other
cardiovascular risk factors in Subang Jaya, Selangor. To gain more insight into this question,
1150 subjects were interviewed and some of the results obtained are compiled in the data file
A1 S2 2023.xls. The columns provide the following information:
Column A: the patient ID
Column B: the level of stabilised glucose
Column C: The total level of cholesterol
Column D: the level of high-density-lipoprotein (“good” cholesterol)
Column E: the weight of the patient
Column F: the gender of the patient
Column G: the type of body frame (small, medium, large)
The data is available on the “A1 S2 2023.xls” file on the Moodle. You must use your subsample
of the survey data. Your sample will consist of 200 observations starting from the respondent
whose ID is the same as the last three digits of your student number. For example, if your
student number is 20275749, you would use individuals 749 to 948.
All tables, graphs and comments for this question should be places in the designated spaces in
the Worksheet Results.
(a) Complete Table (a). Use Countif or another method to find the frequencies for the
number of male and female patients in the sample and hence complete Table (a).
[2 marks]
(b) Display the data in Table (a) using an appropriate chart to be placed in the Graph (b)
Textbox. [2 marks]
(c) Using Countif or any other appropriate method, complete Table (c) by filling in the
frequencies of male and female patients according to their type of body frame.
[2 marks]
(d) Display the data in Table (c) using an appropriate chart to be placed in the Graph (d)
Textbox. [2 marks]
(e) Complete Table (e) containing the summary statistics for the HDL (high-density-
lipoprotein or “good” cholesterol) variable according to the patient gender.
[2 marks]
(f) Complete the grouped frequency Table for the HDL (“good” cholesterol) for female and
male patients [Table (f)]. Find the frequency and hence calculate the percentage
frequency and cumulative percentage frequency for female and male patients. [2 marks]
(g) Is the level of “good” cholesterol (HDL) different for the two groups? Use figures from
Table (e) to help you explain any differences. [3 marks]
(h) Construct percentage frequency polygons for the HDL for female and male students as one chart
as Graph (h). [3 marks]
(i) Discuss the shape of the percentage frequency polygons for the HDL levels for female
and male patients. [3 marks]
(j) List the four measures of variability from the summary statistics. Which one of the
HDL (female or male patients) shows more variability? You are required to use your
sample result to answer this question. [4 marks]
Question 2 [Total 13 Marks]
a. Based on your sample size, construct a contingency Table between the gender of the
patient and the type of body frame. [1.5 marks]
b. Who are the majority of patients and what is their probability? [1.5 marks]
c. What is the probability that the randomly selected patient is a medium body frame?
[2 mark]
d. What is the probability that a randomly selected patient is female and has a large
frame? [2 marks]
e. Using the conditional percentage and appropriate Research Question, write a short report
[about 70 words] to hospital management regarding the gender of the patient and the type
of body frame. [6 marks]
Question 3 [Total 8 Marks]
The file travellers.xls on Moodle contains a worksheet of raw data. The data have been
collected from 3999 travelers as they arrive at Kuala Lumpur International Airport. The sheet
contains the country (region) they came from and the main purpose of their visit (work, study
or tourism), so there are two categorical variables to be examined: one is Region and the other
is Purpose.
You must use your subsample of the survey data. Your sample will consist of 500 observations
starting from the respondent whose ID is the same as the last three digits of your student
number. For example, if your student number is 20275249, you would use individuals 249 to
748.
Do travelers from all regions tend to visit Kuala Lumpur for study? You are required to identify
the dependent and independent variable. Using the conditional percentage and appropriate
Research Question indicate if there is an association between region and purpose of visit to
Kuala Lumpur. [8 marks]
Question 4 [Total 6 Marks]
General Hospital's patient account division has compiled data on the age of accounts
receivables. The data collected indicate that the age of the accounts follows a normal
distribution with a population mean of 28 days and a population standard deviation of 8 days.
a. What proportion of the accounts are between 20 and 40 days old? [2 marks]
b. What proportion of the accounts are less than 30 days old? [1 mark]
c. What is the number of days in which 75% of all accounts are above? [3 marks]
标签：java,excel,ETM5900,patients,patient,female,marks,Table,data From： https://www.cnblogs.com/goodnewss/p/17672719.html