(LO 6-2, LO 6-3, LO 6-4) Download the Stock Returns DJIA Nasdaq SP500 dataset in Excel from...
Question:
(LO 6-2, LO 6-3, LO 6-4) Download the “Stock Returns DJIA Nasdaq SP500” dataset in Excel from Connect (Source: https://www.1stock1.com/1stock1_142.htm). Note the annual stock market returns to investment in the various indices from 1975 to 2021.
Required:
1. Create a clustered column of the annual returns for the DJIA. (Hint: Insert>Charts>Statistic Chart>Clustered Column). Submit this screenshot to your instructor if assigned.
2. Which of the three indices has the highest volatility using standard deviation of annual returns as a measure of volatility? (Hint: Use the STDEV.S Excel function for each index.)
3. Which has higher returns on average, the NASDAQ, S&P500, or Dow Jones?
4. How would you compare each of the three indices to each other by year?
Step by Step Answer:
Introduction To Data Analytics For Accounting
ISBN: 9781266358234
2nd Edition
Authors: Vernon Richardson, Katie Terrell And Ryan Teeter