ct (x2). The results of the regression are : y^= 10.16 + 8.50x1 + 4.30x2; n = 25; SSE = 450; He would like to determine whether the influence of expenditures on test scores differs from the influence of the index on test scores, or β1 ≠ β2. The results of the restricted model for this test are y^= 12.25 + 6.05(x1 + x2); n = 25; SSE = 600. Requirement: a. Formulate the hypotheses to determine whether Expenditures and Index Rate have the same influence on Scores. b. Calculate the value of the test statistic.

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

A sociologist studies the relationship between a district's average score on a standardized test for 10th grade students (y), the average school expenditures per student (x1 in $1,000s), and an index of socioeconomic status of the district (x2). The results of the regression are :

y^= 10.16 + 8.50x1 + 4.30x2; n = 25; SSE = 450;

He would like to determine whether the influence of expenditures on test scores differs from the influence of the index on test scores, or β1 ≠ β2. The results of the restricted model for this test are

y^= 12.25 + 6.05(x1 + x2); n = 25; SSE = 600.

Requirement:

a. Formulate the hypotheses to determine whether Expenditures and Index Rate have the same influence on Scores.
b. Calculate the value of the test statistic.
c. At the 5% significance level, find the critical value(s).
d. What is the conclusion to the test? 

 

Please if can, provide it in excel/spreadsheet

Expert Solution
trending now

Trending now

This is a popular 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