SCENARIO 13-15
the Superintendent of a School District Wanted to Predict

SCENARIO 13-15
The superintendent of a school district wanted to predict the percentage of students passing a sixth- grade proficiency test.She obtained the data on percentage of students passing the proficiency test (% Passing), mean teacher salary in thousands of dollars (Salaries), and instructional spending per pupil in thousands of dollars (Spending) of 47 schools in the state.
Following is the multiple regression output with Y = % Passing as the dependent variable,
X1 =
Salaries and
X 2 = Spending: $$\begin{array}{l}\begin{array} { l r } \hline { \text { Regression Statistics } } \\\hline \text { Multiple R } & 0.4276 \\\text { R Square } & 0.1828 \\\text { Adjusted R Square } & 0.1457 \\\text { Standard Error } & 5.7351 \\\text { Observations } & 47 \\\hline\end{array}\\\\\text { ANOVA }\\\begin{array} { l r r r r r } \hline & d f & { \text { SS } } & { \text { MS } } & \text { F } & { \text { Significance } F } \\\hline \text { Regression } & 2 & 323.8284 & 161.9142 & 4.9227 & 0.0118 \\\text { Residual } & 44 & 1447.2094 & 32.8911 & & \\\text { Total } & 46 & 1771.0378 & & & \\\hline\end{array}\\\\\begin{array} { l r r r r r r } \hline & \text { Coefficients } & \text { Standard Error } & { t \text { Stat } } & \text { P-value } & \text { Lower 95\% } & \text { Upper 95\% } \\\hline \text { Intercept } & - 72.9916 & 45.9106 & - 1.5899 & 0.1190 & - 165.5184 & 19.5352 \\\text { Salary } & 2.7939 & 0.8974 & 3.1133 & 0.0032 & 0.9853 & 4.6025 \\\text { Spending } & 0.3742 & 0.9782 & 0.3825 & 0.7039 & - 1.5972 & 2.3455 \\\hline\end{array}\end{array}$$
-Referring to SCENARIO 13-15, there is sufficient evidence that the percentageof students passing the proficiency test depends on both of the explanatory variables at a 5% level of significance.