lease help solving the following question.   Picture is attached    But solve only these two sub questions please   Is the model statistically significant? Provide a justification for your answer. 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

Please help solving the following question.

 

Picture is attached 

 

But solve only these two sub questions please

 

  • Is the model statistically significant? Provide a justification for your answer.
  • Calculate the correlation coefficient.

 

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