Am I doing this correct I'm so confused if anyone can help me it would be great
Bearmsian Lins 95% (Trekted Y - MEANYY'S (Y - MEAN Y) 2 Predicted Predicted Predicted Conddence Interval Differential Win MEANX STDEVX MEANY STDEVY Prediction Interval Regression Total SU SUn*SU SUN Raidsal altimore Bakaal's 1 -MEANX ( -MEANXY? 112 Lower Round Ceper Round Lower Round Upper Boss 96 Variadon 10.39 9.60 112 87 56 10751.90 84.87 93.31 Variation 0.72 NY Yankees 12544 31 80.39 9.60 -31 75.56 -2604.10 69.15 27 59 2.69 1.71 37 961 10.39 9.60 37 74 56 3070.90 76.63 $5.07 -2.07 (0.55 1369 Tampa Bay -43 9.60 68 5 -1001.10 71.13 79.57 -2.57 71 (0.69) 169 10.39 9.60 62 56 -5751.10 63.6 72.10 -1.10 (0.29) 6561 90 9.60 81 56 4679.90 36.72 27 0.88 2704 Kansas City 10.39 9.60 27 80 56 2402 90 75.53 83.97 5.03 1.34 729 16 9.60 76 56 82 76 73 2 24 Chicago Sox 0.60 256 80.39 9.60 -7154.10 70 04 56 61.79 70.23 2.77 0.74 62 9604 9.60 61 56 74.18 4.18 143 (1.12) 3844 A Angels 10.39 9.60 143 157 89 56 14013.90 88.28 96.72 1.28 0.34 uk land 20449 9.60 79 56 13815.9 98 26 87 10.26 (2.74) 24649 cattle 10.39 9.60 78 56 6959.90 81.36 89.79 -2.79 (0.75) 6400 Houston -94 10.39 9.60 61 56 6580.10 62 23 70.67 -136 -0.67 (0.18 8836 Texas 10.39 9.60 -136 58 56 -9112-10 $7.61 66.05 0.95 0.25 0 39 18496 9.60 87 56 95.40 0.60 0.16 NY Mets 0.39 17161 9.60 70 56 868.90 73-77 82 21 0.39 -3.21 (0.86) 121 9.60 70 56 78 36 0.64 0.17 0.39 $76 9.60 -29 68 56 -2233.10 69.37 biladelphia 77.81 39 0.81 (0.22) 841 9.60 64 56 4964.10 73.52 n. Louis (0.14) 0.39 4624 9.60 81 56 1439.90 82.76 0 39 7.24 1.93 256 9.60 79 56 4487.90 86 61 1.39 0.37 2601 Milwaukee 0.39 9.60 -7 73 56 -$74.10 71.79 80.23 1.77 0.47 39 49 9.60 67 56 -1292.10 79.13 -3.13 Chicago Cubs (0.84 289 0.39 9.60 64 56 6789.10 62 34 70.78 2 22 0.59 A Dedgen 0.39 9.60 101 8649 85 56 9493.90 83.6 92.10 1.90 0.51 10201 as Francisco 10.39 9.60 79 56 4487.90 78-17 86.61 0.37 10 39 1.391 2601 9.60 42 -3234.10 67.94 76 38 0.62 0.16 1764 80.39 9.60 63 57 56 4158.10 65.64 74.07 8.07 3969 10 39 9.60 $5 56 $128-10 58.60 67.04 3.04 (.15) 10.814 16129 Correlation cast 710 2724 SUMSEL-SSE- 187.402 09 2.9206 Total 0.00 0.00 Sea Erver D- #NUM! 0.347 SSE - 0.00) SSR Slope: 0.00 Hypothesis Test SST - Intercept Method 1: Pandicted SUy SUx . (0.00) HO: bov HI: b NEO Poodicted Y ay"predicted Say +MEANy Test Surintic Method 2: Y - a +bX SSR/SST - Implies-4 p-value (m-2) H0:8 0 Y HI: . NEO a. rind the means and standard deviations for the X (Run Differential) and Y (Wins) variable. This is a sample. b. Find the standard units for X and Y and the interaction term. Calculate the correlation coefficient (r). c. Using the regression method find the predicted SUy and the predicted Y. d. Find the slope and y-intercept terms for the regression equation. Find the Predicted Y using the regression line. f. Calculate the residual the residual squared and sum up the residual squared (SSE). g. Calculate the difference between X and the mean of X for each observation and square that result. Sum up the results of the squared differences. Calculate the standard error of the regression (remember this data come from a sample). h. Find the standard error of the slope ("b") and the intercept ("a"). i. Run the hypothesis test on "b" and "a" i. Find the lower and upper bounds for the confidence intervals (for the prediction) and the prediction intervals. k. Calculate the regression variation and the total variation. Calculate r-squared using SSR/SST. 1. Using Excel's Regression tool, run the regression and check your answers