a piper delivers 10.4 ,10.2, 10.8 ,9.6 ,and 10.6 mL in consecutive trials. Find the mean, volume,and the standard deviation using Microsoft excel

Question

a piper delivers 10.4 ,10.2, 10.8 ,9.6 ,and 10.6 mL in consecutive trials. Find the mean, volume,and the standard deviation using Microsoft excel

i need only in excel please help me



Answer 1

List all the values down a column, e.g. in cells A2 to A6. Then place cursor in cell A7 and type

=average(a2:a6) enter. This will give you the mean value. Then place the cursor in cell A8 and type

=stdev(a2:a6) enter. This will give you the standard deviation.

The answer I got is

mean = 10.3

standard deviation = 0.460