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?)

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
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
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman