MS Excel - Example No. 1
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 :
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:
3. Calculation of standard deviation (SD) for sample data: in cell B16 call menu Insert - Function - Statistical - STDEV:
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:
5. Into cell B17 input the formula for calculation of the varince = square of Standard deviation (SD2):
6. Displayed results of calculations:
5. Conclusion: Mean value of glucose level in blood serum in dairy cows is 3.1 mmol/l with standard deviation 0.3247 mmol/l and variance 0.1054 (mmol/l)2.