Understanding Sample (STDEV.S) and Population (STDEV.P) Standard Deviation using Excel

This video describes the difference between the sample standard deviation (STDEV.S) and the population standard deviation (STDEV.P) using Excel. The sample variance (VAR.S) and population variance (VAR.P) are also reviewed.

[@johnfruits3544]

Thank God for Excel, as it can be very helpful to determine many things including Sample and population. I know that if I ever need to do this, i can access your videos to help me! Thank you.

[@lelksldfsjwjdo]

But you still have not explained the n - 1. What is so special about n - 1? Is it calculated via a mathematical proof? Is it just an arbitrary estimate? Over many trials does it parrot exactly the population std. deviation?

[@lelksldfsjwjdo]

But I left out the most important question: WHY? Why does the sample SD underestimate the total SD?

[@behzaddastjerdy]

Thanks Dr. Grande for your videos. I still don't know exactly, for my dataset which function should I use? Normally we use Sample standard deviation function but I don't know why!

[@srinaths3772]

Thanks for the simple explanation.

[@alexpark8554]

Thank you for the class.

[@yeapjersheu]

Thank you for sharing your knowledge. I would like to know for a time series data (example, interest rate over 20 years of an economy) which function should I use? Should I use the pop std dev or the sam std dev?

[@dara_1989]

hey Dr.... thnx to ur vid , I found a new formula for stdev. p
...
√{E(x - u)^2} + n/n - 1 👍👍👍❤️❤️

[@DenizFidan]

Thanks a lot sir. Its very useful.

[@onyemachukwuebukathankgod7596]

Helpful. Thanks

[@vaibhavkt]

Thanks a lot !! This is very useful.

[@DrGrande]

You're welcome, thanks for watching.

[@mariansyk]

thank you :)