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.