The Business Side of Standard Deviation

You are a financial analyst for Alisa Ann Ruch Burn Foundation (AARBF) in Pasadena, CA and you must present an analysis of the financial data to the executives.

Locate the company’s annual report and any other available data (e.g. units manufactured, revenue, etc.) that is available for the last 5 years.
Use one of the company’s historical data sets to calculate the standard deviation of the selected data for the last 5 years.
Discuss what the standard deviation means.
Analyze data using variance and standard deviation.
*****
Create a 10-slide Microsoft® PowerPoint® presentation including detailed speaker notes in which you include the following:
• Graph the company’s selected financial data.
• Explain the role of standard deviation in financial analysis.
• Explain any other uses for standard deviation in a business setting.

Attached you will find a zip folder with all the financianls from 2014 to 2016. If a month is missing assume the value did not change from the previous month. You need to select one variable and find its value in all the Excel files, create one column with the values you have compiled then calculate the variance and standard deviation using this data as we did in class.