Group No. 5: Formulas to be used in Excel by Preshita Chaurasiya

Formulas to be used in Excel:

• Mean/ Average: Select the observation. Put =Mean(Range) and Enter.
• Median: Select the observation. Arrange it in ascending order. Put =Median(Range) and Enter.
• Mode: Select the observation. Put =Mode(Range) and Enter.
• Variations: Observation less Mean of the range. Put =(Observation-Mean) and Enter.
• Variations*2 / (Variations)^2:

1. Put =Power((observation),2) and Enter                        OR 
2. Put =(observation)^2 and Enter                                    OR 
3. Put =(observation)*(observation) and Enter

• Variance: Variance is average of Variations*2. Put =Mean(Range of Variations*2) and Enter.
• Standard Deviation: Standard Deviation is the square root of Variance. Put =SQRT(Variance) and Enter.