Instruction 13 -Referring to Instruction 13

Short Answer

Instruction 13.10
The education department's regional executive officer wanted to predict the percentage of students passing a Grade 6 proficiency test. She obtained the data on percentage of students passing the proficiency test (% Passing), daily average of the percentage of students attending class (% Attendance), average teacher salary in dollars (Salaries) and instructional spending per pupil in dollars (Spending) of 47 schools in the state.
Following is the multiple regression output with Y = % Passing as the dependent variable, X₁ = % Attendance, X₂ = Salaries and X₃ = Spending:
$\begin{array}{|l|r|}\hline\text { Regression } & \text { Statistics } \\\hline \text { Multiple R } & 0.7930 \\\hline \text { R Square } & 0.6288 \\\hline \text { Adj. R Square } & 0.602 \\\hline \text { Standard } & \\\text { Error } & 10.4570 \\\hline \text { Observations } & 47\\\hline\end{array}$

$\begin{array}{|l|r|r|r|r|r|}\hline \text { ANOVA } & & & & \\\hline & \text { d } & \text { SS } & \text { MS } & \text { F } & \text { Signif F } \\\hline \text { Regression } & 3 & 7965.08 & 2655.03 & 24.2802 & 0.0000 \\\hline \text { Residual } & 43 & 4702.02 & 109.35 & & \\\hline \text { Total } & 46 & 12667.11 & & & \\\hline\end{array}$


$\begin{array}{|l|r|r|r|r|r|r|} \hline & \text { Coeff } & \text { StolFrro } & \text { tSta } & \text { p-va/ue } & \text { Lower 95\% } & \text { Upper 95\% } \\\hline \text { Intercept } & -753.4225 & 101.1149 & -7.4511 & 0.0000 & -957.3401 & -549.5050 \\\hline \text { \% Attendance } & 8.5014 & 1.0771 & 7.8929 & 0.0000 & 6.3292 & 10.6735 \\\hline \text { Salary } & 0.000000685 & 0.0006 & 0.0011 & 0.9991 & -0.0013 & 0.0013 \\\hline \text { Spending } & 0.0060 & 0.0046 & 1.2879 & 0.2047 & -0.0034 & 0.0153 \\\hline\end{array}$
-Referring to Instruction 13.10,estimate the mean percentage of students passing the proficiency test for all the schools that have a daily mean of 95% of students attending class,a mean teacher salary of 40,000 dollars and an instructional spending per pupil of 2,000 dollars.