The table below shows the year open and year closing price of the Nasdaq Stock Index from 2009 to 2019:

Year	Year Open	Year Close	Annual Percent Change
2009	$1,632.21	$2,269.15	39.0%
2010	$2,308.42	$2,652.87	14.9%
2011	$2,691.21	$2,605.15	-3.2%
2012	$2,648.72	$3,019.51	14.0%
2013	$3,112.26	$4,176.59	34.2%
2014	$4,143.07	$4,736.05	14.3%
2015	$4,726.81	$5,007.41	5.9%
2016	$4,903.09	$5,383.12	9.8%
2017	$5,429.08	$6,903.39	27.2%
2018	$7,006.90	$6,635.28	-5.3%
2019	$6,665.94	$8,972.61	34.6%

For this assignment you need you need to do the following:

1. Compute the mean, median, range, and standard deviation for Annual Percent Change;

(Looking at these values, over the long run, is investing in theNasdaq Stock Index a profitable investment? Why or why not? Also, the standard deviation is a measure for risk of this investment. Does investing in the Nasdaq have some risk? Why or why not?)

1. Using MS Excel or the website here (http://www.alcula.com/calculators/statistics/) to construct a boxplot for the Annual Percent Change;

1. Using MS Excel or the website here (http://www.alcula.com/calculators/statistics/) to construct a scatter plot of Year Close & Year;

(Paste your scatter plot below. Comment on the general trend you're observing in the scatter plot. Answer: over time does it seem like theNasdaq Stock Index has a positive or negative trend?)

1. Find a regression equation for Year Close Price, y, at x years since 2009;

1. Calculate the value of the Correlation Coefficient for Year Close Price, y, at x years since 2009 and comment on it's value; and

1. Use your regression equation to predict the Year Close Price of the Nasdaq in 2020.

1. The actual close price for 2020 was $12,888.28. Calculate the error (residual) your regression equation made. Why do you think the model made such a large error? There are lots of reasons for this large error and I am interested on why you think this might be. Consider doing some research as to why the stock market, specifically the Nasdaq, was up so much in 2020.