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.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
