Statistical functions using EXCEL
If you want to apply a mathematical process to some data, we use statistical functions.EXCEL has inbuilt functions to compute statistical values.these help in obtaining various statistical measures and can be accessed using the equality sign. Some commonly used statistical functions are explained below:
A) Mean.
This can be obtained through the ‘Average’ function. In a blank cell, use the ‘=AVERAGE’ function, selecting the relevant data column as the inputs in the function.
B) Median.
This can be obtained by using the ‘Median’ function. In a blank cell, use the ‘=MEDIAN’ function, selecting the relevant data column as the input.
C) Mode.
This can be obtained by using the ‘Mode’ function. In a blank cell, use the ‘=MODE’ function, selecting the relevant data column as the input.
D) Geometric Mean.
This can be obtained by using the ‘Geometric Mean’ function. In a blank cell, use the ‘=GEOMEAN’ function, selecting the relevant data column as the input.
E) Harmonic Mean.
This can be obtained by using the ‘Harmonic Mean’ function. In a blank cell, use the ‘=HARMEAN’ function, selecting the relevant data column as the input.
F) PERCENTILE
In any blank cell use =PERCENTILE(variable ,*the percentile needed in decimals*).
Measures of dispersion
1. STANDARD DEVIATION
a) Open the given excel sheet and select the particular column (variable) for which we require the standard deviation.
b) In any blank cell use =STDEV( ).
2. QUARTILE DEVIATION
a) Open the given excel sheet and select the particular column for which we require the quartile deviation.
b) In any blank cell use =QUARTILE(variable ,1) FOR Q1.
=QUARTILE(variable ,2) FOR Q2.
=QUARTILE(variable ,3) FOR Q3.
3. AVERAGE DEVIATION
a) Open the given excel sheet and select the particular column for which we require the quartile deviation.
b) In any blank cell use AVEDEV( ) for mean/ average deviation.
4. RANGE
a) Find =MIN( ) and =MAX( ) after choosing all values of variable. Store in different cells.
b) RANGE= MAX( ) -MIN( )