Question
The table below shows the year open and year closing price of the S&P 500 Stock Index from 2005 to 2020: Year Year Open Year
The table below shows the year open and year closing price of the S&P 500 Stock Index from 2005 to 2020:
Year Year Open Year Close Annual Percent Change
2005 $ 1,202.08 $ 1,248.29
2006 $ 1,268.08 $ 1,418.30
2007 $ 1,416.60 $ 1,468.36
2008 $ 1,447.16 $ 903.25
2009 $ 931.80 $ 1,115.10
2010 $ 1,132.99 $ 1,257.64
2011 $ 1,271.87 $ 1,257.60
2012 $ 1,277.06 $ 1,426.19
2013 $ 1,462.42 $ 1,848.36
2014 $ 1,831.98 $ 2,058.90
2015 $ 2,058.20 $ 2,043.94
2016 $ 2,012.66 $ 2,238.83
2017 $ 2,257.83 $ 2,673.61
2018 $ 2,695.81 $ 2,506.85
2019 $ 2,510.03 $ 3,230.78
2020 $ 3,257.85 $ 3,756.07
For this project you need you need to do the following:
Find the annual percent change for the S&P 500 from 2005 to 2020; (Put those values in the table above)
Compute the mean, median, range, and standard deviation for Annual Percent Change; (Looking at these values, over the long run, is investing in the S&P 500 a profitable investment? Why or why not? Also, the standard deviation is a measure for risk of this investment. Does investing in the S&P 500 have some risk? Why or why not?)
Find the best-fit line for Year Close Price, y, at x years since 2005;
Calculate the value of the Correlation Coefficient for Year Close Price, y, at x years since 2005; and
Use your best-fit line to predict the Year Close Price of the S&P 500 in 2021.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started