4. The Excel table below shows the results of a regression analysis by observing the sales generated for chocolate bars vs money spent on advertising. (sales = y variable, advertising = x variable) SUMMARY OUTPUT Regression Statistics Multiple R 0.988287905 R Square Adjusted R S 0.973386267 0.976712984 Standard Erre 51.82929288 Observations ANOVA df SS Significance F MS Regression 1 788681.6264 788681.6 293.5967 5.65982E-07 Residual 7 18803.9292 2686.276 Total 8 807485.5556 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 167.6829495 58.938986 2.845026 0.024865 28.31439379 307.0515051 28.31439379 307.0515051 Advertising 23.42278559 1.366982532 17.13466 5.66E-07 20.19038555 26.65518564 20.19038555 26.65518564 (i) (ii) What is the value of n? What is the regression line that predicts the sales, y in terms of advertising, x? Comment briefly on the slope sign. What information is provided by the R squared? Is the model statistically significant? Provide a justification for (iii) (iv) your answer. (v) Calculate the correlation coefficient.

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
icon
Concept explainers
Question
100%

Please help solving the following question.

 

Picture is attached 

 

But solve these three sub questions

 

  • What is the value of n?
  • What is the regression line that predicts the sales, y in terms of advertising, x? Comment briefly on the slope sign.
  • What information is provided by the R squared?

 

Thank you

4. The Excel table below shows the results of a regression analysis by observing the
sales generated for chocolate bars vs money spent on advertising. (sales = y variable,
advertising = x variable)
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.988287905
R Square
0.976712984
Adjusted R Sc 0.973386267
Standard Erre 51.82929288
Observations
9
ANOVA
df
SS
MS
Significance F
Regression
1
788681.6264 788681.6 293.5967 5.65982E-07
Residual
18803.9292 2686.276
Total
8.
807485.5556
Coefficients Standard Error
t Stat
P-value
Lower 95%
Upper 95%
Lower 95.0% Upper 95.0%
Intercept
167.6829495
58.938986 2.845026 0.024865 28.31439379 307.0515051 28.31439379 307.0515051
Advertising
23.42278559
1.366982532 17.13466 5.66E-07 20.19038555 26.65518564 20.19038555 26.65518564
(i)
(ii)
What is the value of n?
What is the regression line that predicts the sales, y in terms of
advertising, x? Comment briefly on the slope sign.
What information is provided by the R squared?
Is the model statistically significant? Provide a justification for
(iii)
(iv)
your answer.
(v)
Calculate the correlation coefficient.
Transcribed Image Text:4. The Excel table below shows the results of a regression analysis by observing the sales generated for chocolate bars vs money spent on advertising. (sales = y variable, advertising = x variable) SUMMARY OUTPUT Regression Statistics Multiple R 0.988287905 R Square 0.976712984 Adjusted R Sc 0.973386267 Standard Erre 51.82929288 Observations 9 ANOVA df SS MS Significance F Regression 1 788681.6264 788681.6 293.5967 5.65982E-07 Residual 18803.9292 2686.276 Total 8. 807485.5556 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 167.6829495 58.938986 2.845026 0.024865 28.31439379 307.0515051 28.31439379 307.0515051 Advertising 23.42278559 1.366982532 17.13466 5.66E-07 20.19038555 26.65518564 20.19038555 26.65518564 (i) (ii) What is the value of n? What is the regression line that predicts the sales, y in terms of advertising, x? Comment briefly on the slope sign. What information is provided by the R squared? Is the model statistically significant? Provide a justification for (iii) (iv) your answer. (v) Calculate the correlation coefficient.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Correlation, Regression, and Association
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
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