Excel & Statistics 41: Sample Standard Deviation (Variability)
Calculate Deviations, Variance and Standard Deviation for a sample and a population using Excel tables and the VAR, STDEV, AVERAGE, VARP, STDEVP, COUNT and SQRT functions in Excel. Learn about how the Standard Deviation is like an average of all the deviations, how it shows how clustered the data points are around the mean, how it helps to find out if the mean fairly represents its data points.Chapter 03 Busn 210 Business and Economic Statistics and Excel Class. Descriptive Statistics Numerical Measures This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel Excelisfun Girvin
Posted in Info | 
Tags: descriptive statistics, Deviation, Excel, functions in excel, Michael Gel, Sample, Standard, statistics, Variability, varp
12 Responses to “Excel & Statistics 41: Sample Standard Deviation (Variability)”
Leave a Reply
It may seem basic to you, but I either do not know how to do it or I do not understand what you are trying to do.
Sorry about that.
Remember: Mr Excel is Bill “Mr Excel” Jelen. Bill “Mr Excel” Jelen is the Excel guy how started all the Excel videos training that you see now online!! He is the most prolific and amazing Excel author around!! I am excelisfun. I am just a teacher who posts videos at YouTube.
Hi Mike…May I ask a very basic question please?
I have been asked to work out the biasness between STDEV and STDEVP as a point estimate. In theory STDEV is an ubiased estimator whereas STDEVP is biased estimator. How is biasness calculated when using sample STDEV to estimate the population standard deviation?
I will appreciate your response. thank you MrExcell!
If you go to my college web site and find Busn 210 you can find all my notes, including handwritten pdf notes.
TajikThunderstorm:
why n – 1?
I talk about this in a few of my Statistics Excel videos (I cant remember which one):
Population has all values, including the very extreme outliers.
Samples (especially plotting Xbar), do not have the extreme values and so the variability will tend to be underestimated. N-1 increases variability. Think of it this way:
4/2 = 4
4/(2-1) = 4
Minus 1 in the denominator increases the result.
Hi Mike, here is one thing I want to know… sample standard deviation is calculated using the STDEV function and it has n-1, whereas population standard deviation is calculated using STDEVP, ignores n-1…In point estimation STDEV is considered to be less biased than STDEVP….but I dont get it…confused….Can you help with this… any help very much appreciated!
I am glad it helped!
Life
Saver
Yes, but I get that question a lot!
I am glad that you liked the videos!!
I was just playing. I really enjoy and appreciate your videos.
Dear timabad,
The meaning of Standard Deviation is revealed when you do it long hand:
it is really just a way of getting an “average’ of all the deveations.
–excelisfun
why did you make us do that!? haha
and then you show us the easy way! wtf? haha
grandiosa agiges de endontala y radecobro con vestiz timefinos. eiramo a brumos y geriot acliria con tribos tramindo!