Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management Principles And Applications

Authors: Arthur J. Keown, J. William Petty, John D. Martin, Jr. Scott, David F.

10th Edition

0131450654, 9780131450653

More Books

Students also viewed these Finance questions