Part 2: Data analysis (40marks)

Using Microsoft Excel, examine the case study and answer the questions below:

The Dow Jones Industrial Average (DJIA) and the Standard & Poor (S&P) 500 Index are widely followed measures of the overall stock market. The DJIA tracks 30 major companies, while the broader S&P 500 offers a more comprehensive view of 500 stocks. Understanding the relationship between these indices can provide insight into market trends.

\f