Assignment 1: Application of Descriptive Statistics
Instruction
Read the situation carefully and answer the questions. Some questions require computations and brief explanations, while others require constructing tables and graphs. Situation
A study on blood cholesterol level was conducted among premenopausal and postmenopausal women in a clinic. See the data below on their HDL and LDL and answer the questions that follow:
| ID# |
Menopause |
LDL |
HDL |
| 1 |
Y |
120 |
62 |
| 2 |
N |
110 |
75 |
| 3 |
Y |
126 |
76 |
| 4 |
Y |
189 |
47 |
| 5 |
N |
113 |
78 |
| 6 |
Y |
152 |
56 |
| 7 |
N |
105 |
78 |
| 8 |
N |
125 |
72 |
| 9 |
Y |
172 |
50 |
| 10 |
N |
122 |
77 |
| 11 |
Y |
156 |
59 |
| 12 |
N |
108 |
68 |
| 13 |
Y |
180 |
55 |
| 14 |
N |
125 |
62 |
| 15 |
N |
126 |
78 |
| 16 |
Y |
170 |
56 |
| 17 |
Y |
206 |
42 |
| 18 |
Y |
189 |
46 |
| 19 |
N |
126 |
60 |
| 20 |
N |
115 |
76 |
| 21 |
N |
124 |
57 |
| 22 |
Y |
174 |
40 |
| 23 |
Y |
190 |
48 |
| 24 |
Y |
192 |
40 |
| 25 |
Y |
226 |
40 |
| 26 |
Y |
210 |
40 |
| 27 |
Y |
212 |
39 |
| 28 |
Y |
194 |
45 |
| 29 |
Y |
198 |
47 |
| 30 |
Y |
197 |
47 |
| 31 |
N |
118 |
68 |
| 32 |
Y |
130 |
70 |
| 33 |
N |
133 |
66 |
| 34 |
Y |
206 |
55 |
| 35 |
Y |
224 |
50 |
| 36 |
Y |
190 |
55 |
| 37 |
Y |
182 |
47 |
| 38 |
Y |
128 |
50 |
| 39 |
Y |
139 |
66 |
| 40 |
N |
120 |
65 |
Questions A
1. Construct an ungrouped frequency distribution of the LDL showing the frequencies (f), percentages (%), cumulative frequencies (cf), and cumulative percentages (c%). Describe the data using this approach.
2. Construct a grouped frequency distribution of the HDL showing the frequencies (f), percentages (%), cumulative frequencies (cf), and cumulative percentages (c%) for each class interval. Describe the data using this approach.
3. What is the best way to present HDL or LDL in this dataset? Justify your choice (whether grouped or ungrouped frequency distribution).
Questions B
1. Construct a table showing the distribution of the HDL and LDL of the women. Write a brief narrative (text) describing the table.
2. Construct a graph comparing the LDL between pre menopause and post menopause women. Write a brief narrative (text) describing the graph.
Question C
1. Compute for the measures of tendency: mean, median, mode. Which of the three measures is the best estimator of the HDL? Justify your answer.
2. Compute for the variance (or standard deviation) of HDL. What does this mean in relation to the mean?
3. Given the mean and standard deviation computed above, and assuming the sample was representative of the population, if the normal LDL is less than 130, what percentage of women had normal LDL? Show computation or the use of online calculator.
4. Given the mean and standard deviation computed above, if you were to conduct an intervention program targeting women with high LDL (LDL ≥ 130), what percentage will be included? Show computation or the use of online calculator
5. Given the mean and standard deviation computed above, if the intervention program targets women with low HDL (HDL < 50), what percentage will be included? Show computation or the use of online calculator