Using MS Excel, 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 the S&P 500 has a positive or negative trend?) The annual percent change for the S&P 500 from 2005 to 2020:YearYear Open ($)Year Close ($)Annual Percent Change20051202.081248.293.84417010520061268.081418.311.8462557620071416.61468.363.65381900320081447.16903.25-37.584648552009931.81115.119.6716033520101132.991257.6411.0018623320111271.871257.6-1.12197001320121277.061426.1911.6776032420131462.421848.3626.3905034120141831.982058.912.3865981120152058.22043.94-0.69283840220162012.662238.8311.2373674620172257.832673.6118.4150268220182695.812506.85-7.00939606320192510.033230.7828.7147962420203257.853756.0715.2929079

Data is given : We have to construct scatter plot for year close and year . First enter data in…

Answered: Using MS Excel, construct a scatter…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

Using MS Excel, 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 the S&P 500 has a positive or negative trend?)

The annual percent change for the S&P 500 from 2005 to 2020:

Year	Year Open ($)	Year Close ($)	Annual Percent Change
2005	1202.08	1248.29	3.844170105
2006	1268.08	1418.3	11.84625576
2007	1416.6	1468.36	3.653819003
2008	1447.16	903.25	-37.58464855
2009	931.8	1115.1	19.67160335
2010	1132.99	1257.64	11.00186233
2011	1271.87	1257.6	-1.121970013
2012	1277.06	1426.19	11.67760324
2013	1462.42	1848.36	26.39050341
2014	1831.98	2058.9	12.38659811
2015	2058.2	2043.94	-0.692838402
2016	2012.66	2238.83	11.23736746
2017	2257.83	2673.61	18.41502682
2018	2695.81	2506.85	-7.009396063
2019	2510.03	3230.78	28.71479624
2020	3257.85	3756.07	15.2929079