Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

On the last page of this file you will find the Excel output for a multiple line

ID: 3067111 • Letter: O

Question

On the last page of this file you will find the Excel output for a multiple linear regression model. The model was built in an attempt to better understand why students at area high schools perform differently on the state high school mathematics exam. The average test score for a class of students is what we are trying to predict. In our attempt to understand why these exam scores differ, we use 3 independent variables: a rating (0-100) for the quality of the math degree obtained by the instructor, the age of the instructor, and the salary (in thousands) of the instructor. You are to address the following questions based on the output. a.) Estimate the average math score for a class of students whose instructor is 52 years old, earns $48,000, and got her degree in a math program rated 72 b.) What percentage of the variations in math scores can be explained by this model? c.) Conduct a test to determine if the model, taken as a whole, provided us with any significant explanation of the differences in math scores. That is, should the model be retained for further analysis? d.) Which of the independent variables appear to be significant to the model? Which appear to be insignificant? What leads you to these conclusions?

Explanation / Answer

since the independent varibles are ratings x1, age x2 ,income x3, Therefore the regression line is given by y =35.67+0.24x1+0.2448x2+0.1332x3 a)To estimate the average math score for the class of student. y=35.67+0.2474*72+0.2448*42+0.1332*48000=65789.92 b)To estimate the percentage of variation R2 is used which is 35.7% c)to test the null hypothesis if that all regressio coeficients is equal to zero vs the alternate hypothesis that there is a relationship between the coeficeints. Since the p value fore the f test is less than 5 % significant value therefore there fore there is relation btween coeficients and it can be a good fit to the model.    d)The variable math degree appears to significant , other vribles are not significant hence those varibles are not appropriate for the model.

Related Questions

On the first day of the fiscal year, a company issues an $2,750,000, 8%, five-ye
Question #2580070
On the first day of the fiscal year, a company issues an $688,000, 8%, 5-year bo
Question #2586691
On the first day of the fiscal year, a new walk-in cooler with a list price of $
Question #2482865
On the first day of the partnership\'s tax year, Karen purchases a 50% interest
Question #2500740
On the first day of this class we talked about rolling two dice and kept track o
Question #3223761
On the first day of this class we talked about rolling two dice and kept track o
Question #3233958
On the first day of this class we talked about rolling two dice and kept track o
Question #3248674
On the first day of your summer internship, you’ve been assigned to work with th
Question #2382875
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote

Navigate

Previous
On the last day of the accounting period, a donor makes a permanently restricted
Next
On the last page of this file you will find the Excel output for a multiple line

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.