1st Half Average Final 59.6 58.6 57.6 57.3 55.2 54.9 54.9 54.6 54.5 53.1 52.8 52.7 52.7 52.5 52.4 52.3 52.3 52.2 52.2 52.2 52 51.9 51.6 51.5 50.8 50.8 50.4 49.4 49.3 49 56.6 55.2 54.7 54.7 53.8 53.2 53 52.9 52.7 52.6 52.6 52.4 51.9 51.7 51.5 51.4 51.2 51.2 51 50.8 50.8 50.3 50.3 49.9 49.9 49.8 49.8 49.6 49 48 58 56 54 52 50 48 46 44 42 48 50 52 54 56 58 60 62 fi Final Linear (Final) 56 58 60 62 first half X Input Y Input 59.6 58.6 57.6 57.3 55.2 54.9 54.9 54.6 54.5 53.1 52.8 52.7 52.7 52.5 52.4 52.3 52.3 52.2 52.2 52.2 52 51.9 51.6 51.5 50.8 50.8 50.4 49.4 49.3 49 56.6 55.2 54.7 54.7 53.8 53.2 53 52.9 52.7 52.6 52.6 52.4 51.9 51.7 51.5 51.4 51.2 51.2 51 50.8 50.8 50.3 50.3 49.9 49.9 49.8 49.8 49.6 49 48 SUMMARY OUTPUT Regression Statistics Multiple R 0.9732694 R Square 0.94725333 Adjusted R S 0.94536952 Standard Erro 0.46112366 Observations 30 ANOVA df Regression SS MS 1 106.921219 106.921219 502.839148 Residual 28 5.95378094 0.21263503 Total 29 112.875 Coefficients Standard Error Intercept X Input F t Stat P-value 13.027726 1.72886805 7.53540789 3.3005E-008 0.73001208 0.03255484 22.4240752 1.9778E-019 Significance F 1.9778E-019 Lower 95% Upper 95% Lower 95.0% Upper 95.0% 9.48630032 16.5691517 9.48630032 16.5691517 0.66332652 0.79669764 0.66332652 0.79669764 Project 4 Simple Regression 1. Gather at least 30 data points of data on some sports related activity that has two halves, such as a game or a season. Enter the source of the data. a. If your data is an average; e.g. Earned run average or batting average, do not double. b. If your data is a count: e.g. first half score or home runs in the first half of the season, double the first half number (not the final one). 2. Enter the data in the first two columns of a spreadsheet and produce a scatter plot. 3. Run a simple regression with the first half variable as the independent variable. 4. Paste your results on the assignment sheet. 5. Enter the coefficient, standard error and z-statistic. 6. Show where your estimate falls on the normal distribution provided. 7. Is the coefficient sufficiently different from zero? Explain. 8. Is the coefficient sufficiently different from one? Explain. Name __________ Assignment Sheet Assignment 4 Simple Regression 1. Variables __________________ __________________ 2. Source of data 3. Regression results __________________ 4. Coefficient ____________________ 5. Standard error _____________________ 6. z-statistic _____________________ 6. Show where zero and one fall on the normal distribution provided. Your estimate is , the expected value of the coefficient. 7. Is the coefficient sufficiently different from zero? Explain. 8. Is the coefficient sufficiently different from one? Explain