Group 3
Jeel Sarvaiya
2013018

Calculation of Standard Deviation:
Calculating Standard Deviation Without Using Excel Functions
Data: 3, 4, 8, 9, 11
Using Defining Formula
Step 1: Enter the data into the Excel spreadsheet in the first five cells of column A.
Step 2: In cell B1, enter the formula: =(A1-7)^2 or =(A1-$A$6)^2 which means the
square of the deviation of the data value A1 deviate from A6. Do the same thing
for the rest of the four cells below. The following four cells can also be filled by
clicking and dragging the mouse down to paste the formula into the four cells.
Step 3: Type the expressions in cells A6, B6, B8 and B9
The sums, the sample variance and the sample standard deviation will be
calculated by Excel and displayed.

SQRT(B8) means the square root of the value in B8.

AVERAGE(A1:A5) means the average of the values in A1, A2, A3, A4 and A5.

SUM(B1:B5) means the sum of the values in B1, B2, B3, B4 and B5.


Using Short Cut Formula
Step 1: Enter the data into the Excel spreadsheet in column A.
Step 2: In cell B1, enter the square of the number in cell A1 or enter the formula:
=A1^2 which mean the square of A1. Do the same thing for the rest of the four
cells below. The following four cells can be filled by clicking and dragging the
mouse down to paste the formula into the four cells.
Step 3: Type in the expressions as in A6, B6 and B8. The sums, the sample variance
and the sample standard deviation will be calculated by Excel.