MS Excel - Example No. 2

 

1. Input sample data into a table (cells B3:B14); calculation of mean value (average) of sample: in the cell B15 call menu Insert - Function - Statistical - AVERAGE :

E_pr2a.jpg

2. Into field Array 1 in dialog window input cells for calculation - B3:B14 (it is possible to mark them by means of mouse), push the button OK to get result:

E_pr2b.jpg

3. Calculation of standard deviation (SD) for sample data: in cell B16 call menu Insert - Function - Statistical - STDEV:

E_pr2c.jpg

4. Into field Array 1 in dialog window input cells for calculation - B3:B14 (it is possible to mark them by means of mouse), push the button OK to get result:

 

E_pr2d.jpg

5. Into cell B17 input the formula for calculation of the varince = square of Standard deviation (SD2):

E_pr2e.jpg

6. Displayed results of calculations:

E_pr2f.jpg

 

5. Conclusion: Mean value of body weight in rabbits is 2.908 kg with the standard deviation  0.188 kg and variance 0.0354 kg2.

 

Back