Data Context In this assignment you will analyze the percent return on stock for two large companies - Amazon and Coca-Cola, over the period of more than ten years. The column "Daily Percent Return" is your output (Y) so you need to analyze it rather than the price of stock. The Daily Percent Return represents the percent return on stock from the previous day. For example, on January 3, 2005, AMZN stock closed at $44.52 per share. This is 0.52 percent higher than its closing price on the previous day, Requirements Use Excel functions to compute descriptive statistics for each type of stock. What these numbers are saying? Is the data normal? The average tells us about how much money we make, on average, from owning the stock. The standard deviation tells us how much variation is associated with that quantity, from day to day. In financial terms, it is one measure of risk. Which company has higher return? Higher risk? Compute Q1 and 23 and create a Box Plot for each type of stock. Conduct your statistical analysis in the same workbook in which you have received this assignment. As an analyst, you are expected to report out your findings. File Downloading When you download the file, I suggest that you save it somewhere (computer, a flash drive, or your Gdrive). Once that is done, CLOSE the file out of the browser and OPEN it again within your spreadsheet program. Data Context In this assignment you will analyze the percent return on stock for two large companies - Amazon and Coca-Cola, over the period of more than ten years. The column "Daily Percent Return" is your output (Y) so you need to analyze it rather than the price of stock. The Daily Percent Return represents the percent return on stock from the previous day. For example, on January 3, 2005, AMZN stock closed at $44.52 per share. This is 0.52 percent higher than its closing price on the previous day, Requirements Use Excel functions to compute descriptive statistics for each type of stock. What these numbers are saying? Is the data normal? The average tells us about how much money we make, on average, from owning the stock. The standard deviation tells us how much variation is associated with that quantity, from day to day. In financial terms, it is one measure of risk. Which company has higher return? Higher risk? Compute Q1 and 23 and create a Box Plot for each type of stock. Conduct your statistical analysis in the same workbook in which you have received this assignment. As an analyst, you are expected to report out your findings. File Downloading When you download the file, I suggest that you save it somewhere (computer, a flash drive, or your Gdrive). Once that is done, CLOSE the file out of the browser and OPEN it again within your spreadsheet program