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

question 221

Short Answer

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, what is the value of the test statistic when testing whether mean teacher salary has any effect on percentage of students passing the proficiency test, considering the effect of instructional spending per pupil?

---

Definitions:

Absorption Costing

A costing method that includes all manufacturing costs - direct materials, direct labor, and both variable and fixed manufacturing overhead - in the cost of a product.

Variable Costing

An accounting method in which variable manufacturing costs are included in product costs, while fixed manufacturing overhead is treated as an expense of the current period.

Net Operating Income

A financial metric that calculates a company's income after operating expenses are deducted, but before interest and taxes are subtracted.

Direct Material Cost

The expense of fundamental materials directly utilized in the production of a product.