How To: Calculate variance in a set of data

Calculate variance in a set of data

The video is about how to find the variance of the set of data. They found the variance by using the variance formula. Variance formula was represented by square of S, whereas S is the Standard Deviation.

Variance is got by the summation of the difference between the average of the set of data and each data divided by the number of total samples given.

They explained with an example by taking 6,3,8,5 and 3 as samples. By substituting the samples they found the final variance as 4.5.

Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.

Buy Now (97% off) >

Other worthwhile deals to check out:

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest