Using 1% & 5% alphas, test the overall significance of the model on excel

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
  1. Using 1% & 5% alphas, test the overall significance of the model on excel.
SUMMARY
OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R
Square
Standard Error 0.648011208
Observations
ANOVA
Regression
Residual
Total
Intercept
fixed acidity;
volatile acidity
citric acid
residual sugar
chlorides
free sulfur
dioxide
total sulfur
dioxide
density
pH
sulphates
alcohol
0.600459577
0.360551703
0.356119484
df
1599
1587
1598
11 375.754403 34.15949116
0.419918526
Coefficients
SS
-0.18256395
0.01633127
-1.87422516
0.004361333
MS
666.4107
1042.1651
t Stat
F
81.3479022
P-value
Standard
63.53751785 -19.60710094
63.53751785
Error
21.96520845 21.194575 1.036359939 0.300192136 -19.60710094
0.024990553 0.0259485 0.963082682 0.335652752 -0.025906394 0.075887499 -0.025906394 0.075887499
-1.08359026 0.12110128 -8.947801896 9.87236E-19 -1.321125565 -0.846054953 -1.321125565 -0.846054953
Significance F
1.7914E-145
0.41928321 -4.470069717 8.37395E-06
0.00217129 2.008635263 0.044744951
Lower 95%
Upper 95%
Lower 95.0%
Upper 95.0%
0.14717619 -1.240444878 0.214994246 -0.471244142 0.106116245 -0.471244142 0.106116245
0.0150021 1.088599183 0.276495961 -0.013094741 0.04575728 -0.013094741 0.04575728
-17.8811638 21.6330999 -0.826565029 0.408607897 -60.31362221
-0.41365314 0.19159736 -2.158970991 0.031001886 -0.789463688
0.916334413 0.11433747 8.014297061 2.12723E-15 0.692066057
0.276197699 0.02648359 10.42901431 1.12303E-24 0.224251206
-2.69663236 -1.051817956 -2.69663236 -1.051817956
0.000102431 0.008620235 0.000102431 0.008620235
-0.00326458 0.00072873 -4.47982984 8.00461E-06 -0.004693951 -0.001835208 -0.004693951 -0.001835208
24.55129454 -60.31362221 24.55129454
-0.0378426 -0.789463688 -0.0378426
1.140602768 0.692066057 1.140602768
0.328144192 0.224251206 0.328144192
Transcribed Image Text:SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error 0.648011208 Observations ANOVA Regression Residual Total Intercept fixed acidity; volatile acidity citric acid residual sugar chlorides free sulfur dioxide total sulfur dioxide density pH sulphates alcohol 0.600459577 0.360551703 0.356119484 df 1599 1587 1598 11 375.754403 34.15949116 0.419918526 Coefficients SS -0.18256395 0.01633127 -1.87422516 0.004361333 MS 666.4107 1042.1651 t Stat F 81.3479022 P-value Standard 63.53751785 -19.60710094 63.53751785 Error 21.96520845 21.194575 1.036359939 0.300192136 -19.60710094 0.024990553 0.0259485 0.963082682 0.335652752 -0.025906394 0.075887499 -0.025906394 0.075887499 -1.08359026 0.12110128 -8.947801896 9.87236E-19 -1.321125565 -0.846054953 -1.321125565 -0.846054953 Significance F 1.7914E-145 0.41928321 -4.470069717 8.37395E-06 0.00217129 2.008635263 0.044744951 Lower 95% Upper 95% Lower 95.0% Upper 95.0% 0.14717619 -1.240444878 0.214994246 -0.471244142 0.106116245 -0.471244142 0.106116245 0.0150021 1.088599183 0.276495961 -0.013094741 0.04575728 -0.013094741 0.04575728 -17.8811638 21.6330999 -0.826565029 0.408607897 -60.31362221 -0.41365314 0.19159736 -2.158970991 0.031001886 -0.789463688 0.916334413 0.11433747 8.014297061 2.12723E-15 0.692066057 0.276197699 0.02648359 10.42901431 1.12303E-24 0.224251206 -2.69663236 -1.051817956 -2.69663236 -1.051817956 0.000102431 0.008620235 0.000102431 0.008620235 -0.00326458 0.00072873 -4.47982984 8.00461E-06 -0.004693951 -0.001835208 -0.004693951 -0.001835208 24.55129454 -60.31362221 24.55129454 -0.0378426 -0.789463688 -0.0378426 1.140602768 0.692066057 1.140602768 0.328144192 0.224251206 0.328144192
Expert Solution
steps

Step by step

Solved in 2 steps

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