The following results are from data that were collected from the various high schools around the county. The dependent variable is % OF STUDENTS GOING TO COLLEGE, and the independent variables are: AVERAGE CLASS SIZE, COMBINED SAT SCORES, SPENDING PER STUDENT, AVERAGE TEACHER SALARY, AND % TAKING THE SAT Since the 3 variables AVERAGE CLASS SIZE, SPENDING PER STUDENT, AND AVERAGE TEACHER SALARY are each not significant at the 10% level of significance individually, in order to test to see if as a group they are significant the 3 variables are excluded and another regression is run. The results are as follows: a) At the 10% level of significance, test whether as a group AVERAGE CLASS SIZE, SPENDING PER STUDENT, AND AVERAGE TEACHER SALARY are significant. Be sure to state the null and alternative hypotheses for this hypothesis test.

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
8) The following results are from data that were collected from the various high schools around the county. The dependent variable is % OF STUDENTS GOING TO COLLEGE, and the independent variables are: AVERAGE CLASS SIZE, COMBINED SAT SCORES, SPENDING PER STUDENT, AVERAGE TEACHER SALARY, AND % TAKING THE SAT Since the 3 variables AVERAGE CLASS SIZE, SPENDING PER STUDENT, AND AVERAGE TEACHER SALARY are each not significant at the 10% level of significance individually, in order to test to see if as a group they are significant the 3 variables are excluded and another regression is run. The results are as follows: a) At the 10% level of significance, test whether as a group AVERAGE CLASS SIZE, SPENDING PER STUDENT, AND AVERAGE TEACHER SALARY are significant. Be sure to state the null and alternative hypotheses for this hypothesis test.
8)
The following results are from data that were collected from the various high schools around the
county. The dependent variable is % OF STUDENTS GOING TO COLLEGE, and the independent
variables are: AVERAGE CLASS SIZE, COMBINED SAT SCORES, SPENDING PER STUDENT,
AVERAGE TEACHER SALARY, AND % TAKING THE SAT
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.772
R Square
0.596
Adjusted R Square
0.428
Standard Error
11.22
Observations
18
ANOVA
df
F
Significance F
SS
MS
Regression
2232.7
446.54
3.55
0.034
Residual
12
1510.4
125.87
Total
17
3743.1
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Upper 95%
33.71
63.28
0.53
0.60
-104.16
171.58
Intercept
-1.55765
1.09014
-1.42885
0.17856
-3.93287
0.81756
Average Class Size
0.07689
0.03737
2.05735
0.06206
-0.00454
0.15831
Combined SAT Score
-0.00243
0.00166
-1.46611
0.16833
-0.00603
0.00118
Spending Per Student ($)
-0.00026
0.00064
-0.40451
0.69296
-0.00165
0.00113
Average Teacher Salary ($)
0.28520
0.11545
2.47044
0.02947
0.03367
0.53673
% Taking SAT
Transcribed Image Text:8) The following results are from data that were collected from the various high schools around the county. The dependent variable is % OF STUDENTS GOING TO COLLEGE, and the independent variables are: AVERAGE CLASS SIZE, COMBINED SAT SCORES, SPENDING PER STUDENT, AVERAGE TEACHER SALARY, AND % TAKING THE SAT SUMMARY OUTPUT Regression Statistics Multiple R 0.772 R Square 0.596 Adjusted R Square 0.428 Standard Error 11.22 Observations 18 ANOVA df F Significance F SS MS Regression 2232.7 446.54 3.55 0.034 Residual 12 1510.4 125.87 Total 17 3743.1 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% 33.71 63.28 0.53 0.60 -104.16 171.58 Intercept -1.55765 1.09014 -1.42885 0.17856 -3.93287 0.81756 Average Class Size 0.07689 0.03737 2.05735 0.06206 -0.00454 0.15831 Combined SAT Score -0.00243 0.00166 -1.46611 0.16833 -0.00603 0.00118 Spending Per Student ($) -0.00026 0.00064 -0.40451 0.69296 -0.00165 0.00113 Average Teacher Salary ($) 0.28520 0.11545 2.47044 0.02947 0.03367 0.53673 % Taking SAT
Since the 3 variables AVERAGE CLASS SIZE, SPENDING PER STUDENT, AND AVERAGE
TEACHER SALARY are each not significant at the 10% level of significance individually, in order to test
to see if as a group they are significant the 3 variables are excluded and another regression is run. The
results are as follows:
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.685
R Square
0.469
Adjusted R Square
0.399
Standard Error
11.51
Observations
18
ANOVA
df
SS
MS
Significance F
F
Regression
1756.7
878.4
6.63
0.0086
Residual
15
1986.4
132.4
Total
17
3743.1
P-
Coefficients
Standard Error
t Stat
value
Lower 95%
Upper 95%
Intercept
-26.93
33.39
-0.81
0.43
-98.10
44.24
Combined SAT Score
0.0838
0.0340
2.4623
0.0264
0.0113
0.1563
% Taking SAT
0.2045
0.0926
2.2085
0.0432
0.0071
0.4018
Transcribed Image Text:Since the 3 variables AVERAGE CLASS SIZE, SPENDING PER STUDENT, AND AVERAGE TEACHER SALARY are each not significant at the 10% level of significance individually, in order to test to see if as a group they are significant the 3 variables are excluded and another regression is run. The results are as follows: SUMMARY OUTPUT Regression Statistics Multiple R 0.685 R Square 0.469 Adjusted R Square 0.399 Standard Error 11.51 Observations 18 ANOVA df SS MS Significance F F Regression 1756.7 878.4 6.63 0.0086 Residual 15 1986.4 132.4 Total 17 3743.1 P- Coefficients Standard Error t Stat value Lower 95% Upper 95% Intercept -26.93 33.39 -0.81 0.43 -98.10 44.24 Combined SAT Score 0.0838 0.0340 2.4623 0.0264 0.0113 0.1563 % Taking SAT 0.2045 0.0926 2.2085 0.0432 0.0071 0.4018
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE 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