Please tell how to answer the questions as well so that I can understand how it is done.3. A member of the state legislature has expressed concern abo

Please tell how to answer the questions as well so that I can understand how it is done.3. A member of the state legislature has expressed concern about the differences in the mathematics test scores of high school freshmen across the state. She asks her research assistant to conduct a study to investigate what factors could account for the differences. The research assistant looked at a random sample of school districts across the state and used the factors of percentage of mathematics teachers in each district with a degree in mathematics, the average age of mathematics teachers and the average salary of mathematics teachers:Regression OutputAnalysis of VarianceWrite the least squares prediction equation. What is the number of observations in the sample? Based on the multiple regression model given above, estimate the mathematics test score and calculate the value of the residual, if the percentage of teachers with a mathematics degree is 50.0, the average age is 45 and the average salary is 48,000. If the actual mathematics test score for these factors is 68.50, what is the error for this observation? What is the total sum of squares? What is the explained variation? What is the mean square error and the standard error of estimate?4. For the results given in question # 3 above, calculate the Coefficient of Determination and the Adjusted coefficient of Determination and Test for the overall usefulness of the model using F-Statistic at 5% and 1% significance levels. Finally, test the usefulness (or significance of the three independent variables using t-test for 5% and 1% significance levels.The following table gives the data for per capita income in thousands of US dollars with the percentage of the labor force in Agriculture and the average years of schooling of the population over 25 years of age for 15 developed countries in 2000 (data modified for educational purpose). Develop a multiple regression model for per capita income (dependent variable) using Excel or MegaStat and answer the questions below the table. You can use symbols Y, X1 and X2 for the variables in your calculation. Show your computer output.Find the Y-intercept and slopes for the two independent variables and interpret them. Predict the per capita income when percentage of labor force in Agriculture is only 3 and average years of schooling is 15. Find the overall explanatory power (Coefficient of Determination) of the model and interpret it. Also find the adjusted coefficient of Determination and interpret it. Find the standard error of estimate. From the ANOVA table find SSR, SSE and SST and the F-value. Perform the F-test and comment on the overall usefulness of the model Perform t-test for the statistical significance of individual coefficients.

Posted in Uncategorized