Clear Mountain State Student Survey The Student News Service at Clear Mountain State University (CMSU) has decided to gather data about the undergraduate students who attend CMSU. They create and distribute a survey of 14 questions and receive responses from 111 undergraduates

1. At the 0.05 level of significance, is there evidence of a difference based on academic major in expected starting salary, number of social networking sites registered for, age, spending on textbooks and supplies, text messages sent in a week, and the wealth needed to feel rich?

2. At the 0.05 level of significance, is there evidence of a difference based on graduate school intention in grade point average, expected starting salary, number of social networking sites registered for, age, spending on textbooks and supplies, text messages sent in a week, and the wealth needed to feel rich?

3. Construct contingency tables using gender, major, plans to go to graduate school, and employment status. (You need to construct six tables, taking two variables at a time.) Analyze the data at the 0.05 level of significance to determine whether any significant relationships exist among these variables.

4. At the 0.05 level of significance, is there evidence of a difference between males and females in median grade point average, expected starting salary, number of social networking sites registered for, age, spending on textbooks and supplies, text messages sent in a week, and the wealth needed to feel rich?

5. At the 0.05 level of significance, is there evidence of a difference between students who plan to go to graduate school and those who do not plan to go to graduate school in median grade point average, expected starting salary, number of social networking sites registered for, age, and spending on textbooks and supplies.

6. Predict the mean of GPA for all students with a $1,000 spending. Give a point prediction as well as a 95% confidence interval. Use Spending (x) and GPA (y) variables. Do you have any concerns about using the regression model for predicting GPA given the $1,000 in spending?

7. Construct a 95% confidence interval estimate of the mean value of GPA for $1,000 in spending.

8. Construct a 95% prediction interval of the value of an individual GPA for $1,000 in spending.

9. Explain the difference in the results in (g) and (h).

Just show how to solve each question with excel's PHstat add in.