How To: Calculate variance and standard deviation using Excel

Calculate variance and standard deviation using Excel

This video shows the method to find the variance and standard deviation using Excel. The variance shows the variability of the data points from the median. We find the difference of the median and the mean. We write the formula using '=' sign. The median and data points are put in it by selecting the appropriate cell. The median is made an absolute constant by pressing the F4 key. This is squared by using '^2'. This is multiplied to the frequency using '*'. The result is found for all the data points by double clicking on the bottom right corner of the cell. The sum of all the results is found by the 'sum' function. This is divided by the total number of data points. Hence, the variance is found. The standard deviation is found by finding the square root of the variance using the 'squirt' function.

Follow WonderHowTo on Facebook, Twitter, Pinterest, and Flipboard

Life Hacks for Your Smartphone

Fresh tips every day.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest