Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. - Basic Excel Business Analytics #23: Variability: Variance, Standard Deviation, Z-score and more

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.