Download E1 and develop a mode where DJIA predicts S&P 500. If the DJIA closes at 12,542, we should expect the S&P 500 to close at what value? (Enter a whole number)
Download E1 and develop a mode where DJIA predicts S&P 500. If the DJIA closes at 12,542, we should expect the S&P 500 to close at what value? (Enter a whole number)
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
| Date | DJIA | S&P 500 |
| January 6 | 11,998 | 1,278 |
| January 13 | 12,022 | 1,289 |
| January 20 | 12,330 | 1,315 |
| January 27 | 12,440 | 1,316 |
| February 3 | 12,762 | 1,345 |
| February 10 | 12,801 | 1,343 |
| February 17 | 12,950 | 1,362 |
| February 24 | 12,983 | 1,366 |
| March 2 | 12,978 | 1,370 |
| March 9 | 12,922 | 1,371 |
| March 16 | 13,233 | 1,404 |
| March 23 | 13,081 | 1,397 |
| March 30 | 12,900 | 1,408 |
| April 5 | 13,060 | 1,398 |
| April 13 | 12,850 | 1,370 |
![**Download E1** and develop a model where DJIA predicts S&P 500.
If the DJIA closes at 12,542, we should expect the S&P 500 to close at what value? (Enter a whole number)
[Input box for answer]](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F128131ba-7a22-4a92-89b4-63fc12cc62d7%2F0aa6902d-4ef7-4870-8238-f8c9eae78e9b%2Fhwniwf_processed.png&w=3840&q=75)
Transcribed Image Text:**Download E1** and develop a model where DJIA predicts S&P 500.
If the DJIA closes at 12,542, we should expect the S&P 500 to close at what value? (Enter a whole number)
[Input box for answer]
Expert Solution
Step 1
Find the regression equation using Excel.
Excel procedure:
- In Excel sheet, enter Year in one column and enter Rate in one column.
- In Data, select Data Analysis and choose Regression.
- In Input Variable y Range, select S&P 500.
- In Input Variable x Range, select DJIA.
- Click Labels.
- Click Ok.
Step by step
Solved in 2 steps with 2 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman