2021, with t = 1 corresponding to the yea UMMARY OUTPUT Regression Statistics

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

Please help me ASAP

The table below provides linear extrapolation for the revenue of Coca-Cola using data from 2007
to 2021, with t = 1 corresponding to the
year 2007.
SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
ANOVA
Regression
Residual
Total
Intercept
Year (t)
0.229
0.052
-0.020
6.578
15
df
Enter your answer here
SS
MS
F
Significance F
1 31.10888893 31.1088889 0.719003676 0.411811494
13
562.4666044 43.2666619
14 593.5754933
Coefficients
36.30
0.33
Standard Error
3.57
0.39
t Stat
10.16
0.85
P-value
0.00
0.41
Lower 95%
28.58
-0.52
Upper 95%
44.02
1.18
What is the estimated revenue for Coca-Cola in 2023? Please provide a numerical answer with no
units and no dollar sign ($). Please round your answer to two decimal places.
Transcribed Image Text:The table below provides linear extrapolation for the revenue of Coca-Cola using data from 2007 to 2021, with t = 1 corresponding to the year 2007. SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total Intercept Year (t) 0.229 0.052 -0.020 6.578 15 df Enter your answer here SS MS F Significance F 1 31.10888893 31.1088889 0.719003676 0.411811494 13 562.4666044 43.2666619 14 593.5754933 Coefficients 36.30 0.33 Standard Error 3.57 0.39 t Stat 10.16 0.85 P-value 0.00 0.41 Lower 95% 28.58 -0.52 Upper 95% 44.02 1.18 What is the estimated revenue for Coca-Cola in 2023? Please provide a numerical answer with no units and no dollar sign ($). Please round your answer to two decimal places.
The table below provides linear extrapolation for the revenue of Pepsi using data from 2007 to
2021, with t = 1 corresponding to the year 2007.
SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
ANOVA
Regression
Residual
Total
Intercept
Year (t)
df
0.622
0.387
0.340
9.916
15
1
13
14
SS
MS
F
806.8557004 806.8557 8.2059304
1278.237033 98.325926
2085.092733
Coefficients Standard Error
5.39
0.59
49.36
1.70
t Stat
9.16
2.86
P-value
0.00
0.01
Significance F
0.01327996
Lower 95%
37.72
0.42
Upper 95%
61.00
2.98
What is the estimated revenue for Pepsi in 2024? Please provide a numerical answer with no units
and no dollar sign ($). Please round your answer to two decimal places.
Enter your answer here
Transcribed Image Text:The table below provides linear extrapolation for the revenue of Pepsi using data from 2007 to 2021, with t = 1 corresponding to the year 2007. SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total Intercept Year (t) df 0.622 0.387 0.340 9.916 15 1 13 14 SS MS F 806.8557004 806.8557 8.2059304 1278.237033 98.325926 2085.092733 Coefficients Standard Error 5.39 0.59 49.36 1.70 t Stat 9.16 2.86 P-value 0.00 0.01 Significance F 0.01327996 Lower 95% 37.72 0.42 Upper 95% 61.00 2.98 What is the estimated revenue for Pepsi in 2024? Please provide a numerical answer with no units and no dollar sign ($). Please round your answer to two decimal places. Enter your answer here
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

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