The Director of the Department of Education in Queensland was analysing the last year average mathematics test scores in the schools under his control. He noticed that there were dramatic differences in scores among the schools. In an attempt to improve the scores of all the schools, he attempted to determine the factors that account for the differences. Accordingly, he took a random sample of 40 schools across the state and, for each, determined the mean mathematics test score, the percentage of teachers in each school who have at least one university degree in mathematics (math), the mean age, and the mean annual income ($ ‘000) of the mathematics teachers. These data are saved in the t10e5 Excel file.a) Perform a multiple regression analysis on these data with R. What is your sample regression equation?b) Is the model useful in explaining the variation among schools? Explain.c) Are the normality and homoskedasticity conditions satisfied? Explain.d) Is multicollinearity a problem? Explain.e) Interpret and the coefficients. Do you find their signs reasonable? Why or why not? Based on your expectations perform t-tests on the coefficients (use a = 0.05).f) Test the null hypothesis that neither the teachers’ mean age nor their mean annual income has a significant effect on the average mathematics test scores (use a = 0.05).

Predict for the Director of the Department of Education in Queensland the mean mathematics test score at all schools in the state where 50% of the teachers have at least one university degree in mathematics, their mean age is 43 years, and their mean annual income is $78,500.

In an examination the average marks obtained by John in English, Maths, Hindi and Drawing were 50. His average marks in Maths, Science, Social Studies and Craft were 70. If the average marks in all seven subjects is 58, his score in maths was?

Predict for the Director of the Department of Education in Queensland the mean mathematics test score at a school in the state where 50% of the teachers have at least one university degree in mathematics, their mean age is 43 years, and their mean annual income is $78,500. What is the corresponding approximate 95% prediction interval? Calculate the point prediction first manually and then with R, and the approximate 95% prediction interval manually only.

For the following scenarios, give the null and alternative hypotheses and state in words what µ represents in your hypotheses.Question 1: The National Assessment of Educational Progress (NAEP) is administered annually to 4th, 8th, and 12th graders in the United States. On the math assessment, a score above 275 is considered an indication that a student has the skills to balance a checkbook. In a random sample of 500 young men between the ages of 18 and 20, the mean NAEP math score is 272. Do we have evidence to support the claim that young men nationwide have a mean score b

A professor grades students on four tests, a term paper, and a final examination. Each test counts as 15% of the course grade. The term paper counts as 20% of the course grade. The final examination counts as 20% of the course grade. Alan has test scores of 94, 78, 80, and 88. Alan received an 84 on his term paper. His final examination score was 90. Use the weighted mean formula to find Alan's average for the course. (Round your answer to one decimal place.)