b) The outputs below show two regression analysis of some variables in an excel spreadsheet. Output A and Output B. Answer the questions in relation to these outputs. Table 4 Output A SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.99604 0.99209 0.99012 0.497694346 6 ANOVA Significance F 502.0 df MS F Regression 1 124.344 124.34 0.25 0.000023 Residual 4 0.991 Total 125.335 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept x2 0.31 0.51 22.41 2.69 8.75 0.00 1.84 3.54 1.84 3.54 11.32 0.00 9.92 12.73 9.92 12.73

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 solve in one hour
b)
The outputs below show two regression analysis of some variables in
an excel spreadsheet. Output A and Output B. Answer the questions in
relation to these outputs.
Table 4 -
Output A
SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
0.99604
0.99209
0.99012
0.497694346
6
ANOVA
df
SS
124.344 124.34
MS
Significance F
Regression
1
502.0
0.000023
Residual
4
0.991
0.25
Total
125.335
Coefficients Standard Error t Stat P-value
Lower 95%
Upper 95%
Lower 95.0%
Upper 95.0%
Intercept
x2
2.69
0.31
8.75
0.00
1.84
3.54
1.84
3.54
11.32
0.51 22.41
0.00
9.92
12.73
9.92
12.73
Transcribed Image Text:b) The outputs below show two regression analysis of some variables in an excel spreadsheet. Output A and Output B. Answer the questions in relation to these outputs. Table 4 - Output A SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.99604 0.99209 0.99012 0.497694346 6 ANOVA df SS 124.344 124.34 MS Significance F Regression 1 502.0 0.000023 Residual 4 0.991 0.25 Total 125.335 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept x2 2.69 0.31 8.75 0.00 1.84 3.54 1.84 3.54 11.32 0.51 22.41 0.00 9.92 12.73 9.92 12.73
Expert Solution
steps

Step by step

Solved in 2 steps

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