| 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. |
|
|
|
guru2009
10 years ago
the_claim_that_the_average_median_sat_is_over_1200.xlsx
