View Help Shape Format 47 General $ - % 2. Insert + Delete- Format Center - Conditional Format as Cell Formatting Table Styles Styles Sort & Filter Find Select Number Cells Editing K L M N O P Q R This problem needs to be completed "manually" showing all work and steps. The estimated regression equation for this data is: y = -7.9+1.80x where x is first downs and y is score. Use the provided information to complete the following tasks and answer the following questions below. Answers to questions should be placed starting in column L below this text box as noted. T a) Create an ANOVA table for this regression Show all of your steps and calculations, Qb) Calculate and interpret the coefficient of determination (R). c) What are the null and alternative hypotheses to test the coefficient on first downs? Calculate the t-test statistic and p-value. Keep smiling, you've got this! What is your decision on this hypothesis test using a=05? Is the coefficient on first downs stastically signififcant? d) Use Excel's Regression analysis tool to check your answers and place the output in the designated cell ANOVA Table Source Regression Sun DF Mean Sq.F P -value Chapter 15 (20 points) Chapter 18-1 ... View Help Shape Format 47 General $ - % 2. Insert + Delete- Format Center - Conditional Format as Cell Formatting Table Styles Styles Sort & Filter Find Select Number Cells Editing K L M N O P Q R This problem needs to be completed "manually" showing all work and steps. The estimated regression equation for this data is: y = -7.9+1.80x where x is first downs and y is score. Use the provided information to complete the following tasks and answer the following questions below. Answers to questions should be placed starting in column L below this text box as noted. T a) Create an ANOVA table for this regression Show all of your steps and calculations, Qb) Calculate and interpret the coefficient of determination (R). c) What are the null and alternative hypotheses to test the coefficient on first downs? Calculate the t-test statistic and p-value. Keep smiling, you've got this! What is your decision on this hypothesis test using a=05? Is the coefficient on first downs stastically signififcant? d) Use Excel's Regression analysis tool to check your answers and place the output in the designated cell ANOVA Table Source Regression Sun DF Mean Sq.F P -value Chapter 15 (20 points) Chapter 18-1