STEP 1

CALCULATING THE ARITHMETIC MEAN

1.Type 'Mean' in cell A1.

2.Type the values for calculating mean in column A.

3.Type 'Mean' in cell 81.

4.In cell 82, type the formula as '=SUM(A:A)/ CQUNT(A:A)' to get the arithmetic mean.

STEP 2

CALCULATING THE MEDIAN VALUE

1.Type the required values in column A.

2.Type 'Median' in cell 81.

3.In cell 82, type the formula as '=MEDIAN(A:A)' to get the median value.

NOTE:

You are not required to reorder the values in ascending order before using this formula

STEP 3

CALCULATING THE MODAL VALUE


1.Type the required values in column A.

2.Type 'Mode' in cell Bl.

3.In cell B2, type the formula as '=MODE(A:A)' to get the median value.

NOTE:
You are not required to reorder the values in ascending order before using this formula.

STEP 4

CALCULATING STANDARD DEVIATION


1.Type the required values in column A.

2.Type 'x bar' in cell Bl.

3.In cell B2, calculate the mean of all the values.

4.Type '(X- X bar)' in cell C1.

5.From cell C2 onwards,type the formula as '=A2-$B$2'.

6.Copy the formula to the corresponding cells using the fill handle.

NOTE:

Standard Deviation can be caluclated in Excel as per its originally defined mathematical formula or by using built-in functions defined in Excel to calculate the same.

7.Type '(X- X bar)' followed by the combination of [Alt] + [0] + [1] + [7] + [8] to get the values as '(X - X bar)2' in D2.

8.From cell D2 onwards, type the formula as '=C2*C2'.

9.Copy the formula to the corresponding cells using the fill handle.

10. Calculate the sum for values in column D2 using the sum function.

11. Type 'Sum (X-X bar)2/(n-1)' in cell El.

12. Calculate the value as '=D11/(COUNT(A2:A 10)-1)' in cell 82.

13. Type 'Std Dev' in cell Fl.

14. Calculate the value as '=SQRT(Dll) , in cell 82

USING PREDEFINED FUNCTIONS

1.To use the formula directly, go to the destination cell and type the formula as '=STDEV(A:A)'.

1.You can use different variants of the' formula like '=STDEVA()', '=STDEVP()' and '=STDEVPA()'.

NOTE:

STDEVA calculates the standard deviation for a set of values with missing information. It treats such cells as zero and ignores blanks and text values appearing between numbers.

Name: US_Prd_ss_full_Office_Excel_2007.jpg Views: 504 Size: 67.3 KB