Homework Help is Here – Start Your Trial Now!
Math
Statistics
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
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
icon
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]
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.
steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
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
SEE MORE TEXTBOOKS