A large school district is reevaluating its teachers salaries. They have decided to use regression analysis to predict mean teacher salaries at each...

A large school district is reevaluating its teachers salaries. They have decided to use regression analysis to predict mean teacher salaries at each high school. The researcher uses years of experience and subject matter (Math, science, English, Other) to predict Salary. The raw data is given in the table below;SubjectEnglishEnglishMathScienceOtherMathMathScienceMathScienceEnglishEnglishScienceMathOtherOtherMathMathEnglishScienceUse excel to analyze the data.Use the following; Y=Dependent Variable; X1= Years of Experience; X2=Math; X3= Science; X4= EnglishA) What is the prediction equation?b) What is the correlation coefficientC) Is the overall model significant? Why?D) What is the coefficient of determination?E) What is the MSE?F) List the P-Value of each independent variable and say whether it is significant to the model or not. Use a 0.05 level of significance.G) What is the predicted mean salary for a gym teacher with 10 years experience?

SalaryYears of experience Math242658271405221952379501532890114025014368009308206443902124955218055123690748070204220516242656271408368757379509328901402804...