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.

[johnfruits]

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.

[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!

[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?

[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?

[dara_]

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