Question

1. Wellness Data – Cholesterol levels.

Your worksite has instituted a new wellness program. As part of the plan for future evaluation of the effectiveness of the program, data are collected on a variety of health measures. These data are being collected every three months for the next two years. One of the measures collected by researchers was employee's cholesterol level. Initial data for 60 employees is listed below.

205	327	189	205	148	139	178	157	188	301
195	185	164	182	201	248	298	264	177	169
174	169	155	188	194	192	177	189	188	176
158	305	248	189	209	159	202	177	278	268
166	285	249	203	199	170	165	180	201	209
301	188	165	173	183	206	202	283	207	156

1. Find the highest and the lowest scores and place your data into an array, arranging values from highest to lowest

2. Evaluate your data. Do you see any clusters of scores, and are there any gaps in the data

3. Discuss your thoughts online as to what intervals should be used and why. Remember that your intervals must be equal and non-overlapping. Your intervals do NOT need to begin or end with your highest/lowest values.

4. After we have discussed the intervals, everyone should construct a frequency table for these data including intervals, frequency, relative frequency, and cumulative relative frequency and then create histograms and frequency polygons for these data.

5. Discuss online any problems you have in creating your tables and graphs as well as any questions you may have about the process.

Answer 1

Solution

Let X represent the cholesterol levels od employees.

Part (1)

Highest score = 327 Answer 1

and

lowest score = 139 Answer 2

[Data in an array of highest to lowest scoes is given at the end]

Part (2)

There is a cluster from 155 to 209 accounting for 75% (45 out of 60) of scores. Answer 3

There is also a gap from 210 to 247 where there is no score at all. Answer 4

Part (3)

Extending the smallest value to 130 and highest value to 330, the range becomes 200. So, the interval would be of width 20 and number of classes would be 10. Answer 5

Part (4)

Frequency distribution with all required details is given below:

Class Limits		Frequency	Relative Frequancy	Cumulative Relative Frequancy
Lower	Upper
130	149	2	0.0333	0.0333
150	169	11	0.1833	0.2167
170	189	19	0.3167	0.5333
190	209	15	0.2500	0.7833
210	229	0	0.0000	0.7833
230	249	3	0.0500	0.8333
250	269	2	0.0333	0.8667
270	289	3	0.0500	0.9167
290	309	4	0.0667	0.9833
310	329	1	0.0167	1.0000
	Total	60	1

Answer 6

DONE