Overview
1. Using your date set from Assignment 7, run a Global F test in Excel. Insert
a screenshot of the complete output below. (1 pt.) a. What is the test statistic (include the type of statistic and the value (for example p = 0.00)? (.5 pt.) b. What is the p-value? (.5 pt.) c. Would you continue with your model testing (state yes or no)? (.5 pt.) 2. Test your quadratic terms using the appropriate test. If you answered “no” to 1.c., continue anyway. Insert screenshot below. (1 pt.)
a. What is the test statistic (include the type of statistic and the value)? (.5 pt.) b. What is the p-value? (.5pt.) 3. Test your interaction term(s) using the appropriate test. If you answered “no” to 1.a., proceed as if you failed to reject the null for the test of your quadratics. Insert screenshot below. (1 pt). a. What is the test statistic (include the type of statistic and the value)? (.5 pt.) b. What is the p-value? (.5 pt.) 4. If further testing is needed, insert screenshot(s) below in the order that you ran them. There is no credit for this, but you will not receive credit for #5 without it.
5. What is your prediction equation? (2 pts.) 6. What is the adjusted R2? (.5 pt.) 7. Using the statement from the slides, explain what your R2 means. (1 pt.)