Solved

Instruction 13 -Referring to Instruction 13

Question 37

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, X1 = % Attendance, X2 = Salaries and X3 = Spending:
 Regression  Statistics  Multiple R 0.7930 R Square 0.6288 Adj. R Square 0.602 Standard  Error 10.4570 Observations 47\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}

 ANOVA  d  SS  MS  F  Signif F  Regression 37965.082655.0324.28020.0000 Residual 434702.02109.35 Total 4612667.11\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}


 Coeff  StolFrro  tSta  p-va/ue  Lower 95%  Upper 95%  Intercept 753.4225101.11497.45110.0000957.3401549.5050 % Attendance 8.50141.07717.89290.00006.329210.6735 Salary 0.0000006850.00060.00110.99910.00130.0013 Spending 0.00600.00461.28790.20470.00340.0153\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.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents