How To... Calculate Data Range and Sample Variance in Excel 2010

Learn how to calculate two measures of variability in Microsoft Excel 2010 - Range and Sample Variance. These are most useful when comparing either sample or population data sets.

[@madelainebefus]

Fabulous Dr. O'Loughlin. Clear, easy to understand, up-to-date and a perfect length.

[@inatabacaru2139]

Dr. O'Loughlin,thank you very much for this useful tutorial and for many others that you uploaded here. You are doing a great job!

[@knolan101]

Very clear and informative, thanks Eugene. Has anyone ever asked you why we divide by 'n-1' for the sample variance, when we divide by 'n' when calculating the mean?

[@boptyhoah]

this video have been so helpful
kindly check the video point at 7.00
the range for sample data set B should be 4-2=2

[@drahmedshawkyphd2726]

Thank you so much for the video which is very easy and very important for me, where i do PhD now and will start to analysis my data in different ways and sure i will need your help if you don't mind :)

[@EugeneOLoughlin]

Hi knolan101.
It has to do with sample versus population means. When calculating Variance we use the sample mean - the formula for Variance measures the squared deviation from the sample mean. The measurements in the sample tend to be closer to the sample mean than the pop mean - so we compensate for this by using the divisor (n-1) rather than n.
Hope this helps.
Dr E.

[@kevinforsyth1153]

Well done

[@drahmedshawkyphd2726]

I saw some thesis calculate the Mode. when i go to statistica i found Mode.Mult and Mode.Single, which one i can select? Thanks

[@casluk8210]

Hi This is a great video. Thank you very much.
Do you have a complete tutorials for structured learning?

[@EugeneOLoughlin]

Hi Casl,
Many thanks for your kind comment.
This video is part of a series of videos that I have created for one of my own Statistics classes. You can access this video and my other Statistics videos on my "Basic Statistics in Excel" playlist:
ruclips.net/p/PLfGMkZaH76AkwGs1E1jHL3fZrc78sopeZ
Dr E.

[@steffi0525]

Really Helpful video thanks for sharing. May you explain to me please, where does the 3 come from in the variance part?

[@EugeneOLoughlin]

+steffi0525
This is the mean of each sample:
(1+2+3+4+5)/5 = 3
(2+3+3+3+4)/5 = 3