Download the sp-500-historical-annual-returns dataset in Excel from Connect or Additional Student Resources.7 Note the annual stock market

Question:

Download the sp-500-historical-annual-returns dataset in Excel from Connect or Additional Student Resources.7 Note the annual stock market returns to investment in the S&P 500. Create a visualization in Excel using a bar chart. Note the volatility of returns over the years, which is an indicator that the stock market is a risky investment.

Required: 1. Create a bar chart of the annual returns or column chart of the annual returns 2. Label the vertical axis as “Annual Percentage Return”, the horizontal axis as “Year”, and the chart title as “Annual Returns to the S&P 500 Index”.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question

Accounting Information Systems

ISBN: 9781266370373

4th Edition

Authors: Vernon Richardson, Chengyee Chang, Rod Smith

Question Posted: