Watch the following YouTube video explaining how to prepare a Frequency Distribution in MS
Excel:
Then, using MS Excel, prepare a Histogram with the following specifications:
a) Class width = 11
b) 6 classes: beginning with 45-55
c) The following data represent glucose blood levels (mg/100 ml) after a 12-hour fast for a
random sample of 70 women
d) Calculate the relative frequency for each class.
e) Show that the frequencies add up to 70, and the relative frequencies add up to 1.
45 66 83 71 76 64 59 59
75 82 80 81 85 77 82 90
87 72 79 69 83 71 87 69
81 76 96 83 67 94 101 94
89 94 73 99 93 85 83 80
78 80 85 83 84 74 81 70
65 89 70 80 84 77 65 46
80 70 75 45 101 71 109 73
73 80 72 81 63 74
