The American Diabetes Association recommends a blood glucose reading of less tha
ID: 3439636 • Letter: T
Question
The American Diabetes Association recommends a blood glucose reading of less than 130 for those with Type 2 diabetes. Blood glucose measures the amount of sugar in the blood. The readings for February for a person recently diagnosed with Type 2 diabetes can be found in the file “Glucose readings”. Using that data, answer the following questions. Note: You should copy this data into the file that you plan to submit to the Course Den dropbox. Only one Excel can be submitted to Course Den. a) What is the arithmetic mean glucose reading? b) What is the median glucose reading? c) What is the modal glucose reading?
HOW DO I DO THIS IN EXCEL?
Reading 112 122 116 103 112 96 115 98 106 111 106 124 116 127 116 108 112 112 121 115 124 116 107 118 123 109 109 106Explanation / Answer
Following table shows the mean,median and mode:
I copied the data in column B:
First cell of column B has heading "Reading". After that cell B2 to B29 has data values.
(a)
Command for mean in excel:
In cell B30 I wrote:
=average(B2:B29)
and press enter. It gives average.
(b)
Command for median in excel:
In cell B31 I wrote:
=median(B2:B29)
and press enter. It gives median.
(c)
Command for mode in excel:
In cell B32 I wrote:
=mode(B2:B29)
and press enter. It gives mode.
Reading 112 122 116 103 112 96 115 98 106 111 106 124 116 127 116 108 112 112 121 115 124 116 107 118 123 109 109 106 Mean 112.8571 Median 112 Mode 112Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.