Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm
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.
