Discussion

Week2Hints.xlsx

Formulas

	How to Use Excel to calculate the mean, median mode…
			** formulas will appear in the box above
	Data set
	15
	17
	22
	11
	13
	80
		To do	Notes from Dr. Klotz
mean	26.3333333333	Click in the green cell to see the formula used
median	16	Click in the blue cell to see the formula used
mode	ERROR:#N/A		There is no mode because no number is repeated
minimum	11	Click on the orange cell to see the formula used
maximum	80	Click on the red cell to see the formula used
range	69		Range is maximum minus minimum
variance	705.4666666667	Click on the gray cell to see the formula used
standard deviation	26.5606224827	Click on the pink cell to see the formula used

You try
	Select the cell next to the name of what it is. They are highlighted in yellow.
	type =aver
	the word "average" appears
	double click on the word "average"
	highlight the cells in the data set
	hit "enter"
	The average should appear.
	Repeat with =min, =max, =std, =var, =medi, =mode…. To get all the values. I have an answer key so that you know if you did it right
			Data set
			3
			9
			7
			7
			8
			2	Answers
		mean		6
		median		7
		mode		7
		standard deviation		2.8284271247
		variance		8
		maximum		9
		minimum		2