Advanced Business Statistics Homework

For this exercise, you will assess the riskiness (in terms of volatility) of two stocks of your choice. This type of riskiness is a function of the variance in the daily stock prices over a given time frame. Stocks with a consistently high price or consistently low price, for example, would be assessed as “lower risk” while those whose prices varied over the year would be “higher risk.” Risk level in terms of price does not imply whether the stock is successful or not – it just measures the variation in the price.

Compare and contrast the stock prices for your choice of two of the listed stocks in the dataset “Stock_Data.xlsx” on Canvas. Use the data given for the range listed to assess the riskiness of each stock. Compute each stock’s sample standard deviation, mean, and median, and accurately show two box and whiskers diagrams—one for each stock—and ensure that they are scaled so they can be accurately compared. Be sure to show all data and calculations. Be sure that your analytics can be easily understood by another analytics person.

Important:

Record the data in a new spreadsheet in Excel–make sure to save as a .xlsx file or your work will not be saved due to decreased functionality of csv files. On separate tabs, perform the calculations and required graphics so that the Excel file has four total tabs (title sheet (with your name), data, numerical comparison, and graphical comparison). Write an essay (using a word processor) of about one page (single spaced) with your opinions as to what the analytics are portraying. Turn in the Excel file (with 3 tabs) and Word file to the instructor through Canvas.

See attachment..