Basic Excel Business Analytics #23: Variability: Variance, Standard Deviation, Z-score and more

Learn about a number of important calculations for Variability:
1) (00:11) What is Variability? Synonyms: Variation, Dispersion, Spread in the data. Which Mean more fairly represents its data points? Which Mean is more reliable?
2) (02:54) Calculation of Sample Standard Deviation and Variance long hand and with the Excel functions: STDEV.s and VAR.S. How to use Standard Deviation to make a business decision.
3) (08:57) Use a 10 Year Bond Yield data Set to calculate the variability measures: Range, Variance, Standard Deviation and Coefficient of Variation.
4) (12:31) Z-Score. Formula: (Particular Value – Mean)/Standard Deviation.
5) (14:24) Second Example of Standard Deviation long hand.
6) (15:12) Look date of max and min Bond Rate using INDEX and MATCH functions.
7) (17:33) Conclusion

Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.

[yogiepridatama]

nice!!! your video helping me to doing my research. Thank you bro.

[timmybone]

Is it just me or does the blue text box at 4:38 confuse anyone else? Made me laugh though. Love the videos!

[soothingmusic]

interest rates: In 9/1/81 highest interest rates 15.32 the FEDs need Ron Reagan look bad in first year president 1981–1989 . in 7/1/12 lowest IR 1.53 the FEDs need Obama to look good at end of first term to get reelected president 2009 to 17. the power of statistics