Question

I'm very new to excel - not sure how to go about using the formula inserts to solve it.

Exercise 20 Using only Excel functions							516	511	538	574	501
		For the sample distribution at right:					546	548	552	534	522
							486	558	523	586	566
		a. Find the mean				537.4
		b. Find the median
		c. Find the standard deviation						[Using STDEV or STDEV.S]

Answer 1

For finding the mean, use the following excel command:

=AVERAGE(select all data)

Press Enter.

After using this command, you will get the required answer as below:

Mean = 537.4

For finding the median, use the following excel command:

=MEDIAN(select all data)

Press Enter.

After using this command, you will get the required answer as below:

Median = 538

For finding the standard deviation, use the following excel command:

=STDEV(select all data)

Press Enter.

After using this command, you will get the required answer as below:

Standard deviation = 27.93053