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
Related questions
Question
- Using 1% & 5% alphas, test the overall significance of the model on excel.

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps

Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON

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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman