The American Diabetes Association recommends a blood glucose

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
106

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	112

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

The American Diabetes Association recommends a blood glucose

Solution

Get Help Now

Submit a Take Down Notice