1. Perform the following hypothesis tests on the data in spreadsheet #1. State the conclusion of the hypothesis tests. The level of significance is 0.05 in each test.
A. The claim that the average Median SAT is over 1200.
B. The claim that the proportion of schools with Expenditures/Student over $50,000 is 0.2.
C. The claim that there is no difference in mean Acceptance Rate between University and Liberal Arts College.
D. The claim that the variance of Median SAT is less than 4000.
2. Use the data in the spreadsheet "#2" to answer the following. A.Construct a scatter diagram for Math and Science scores.
B. Develop a regression model for predicting Science score as a function of Math score.
C. Use the regression model to predict the Science score given a Math score is 90.
3. Use the data in the spreadsheet "#3" to answer the following.
A. Develop a multiple regression model for predicting Graduation % as a function of the other variables.
B. Use the model to predict the Graduation % with a Median SAT of 1500, Acceptance Rate of 50%, Expenditures/Student of $50000 and Top 10% HS of 80.
4. Consider the data in the spreadsheet "#4".
A. Use the two forecast methods: single moving average of period 3, single exponential smoothing with smoothing constant 0.5 to forecast the data for the next month.
B. For each of the two methods, calculate MAD and determine which is the best method.
C. For each of the two methods, calculate MSE and determine which is the best method.