Question Answered step-by-step Please see attachments for detailsd. Perform a simple regression of batting average on payroll. I have computed the mean for payroll and batting average for you.~ State the conventional null hypothesis for a regression analysis. < ii) What is the estimated coefficient, B?< What is the intercept?< Compute an estimated value ) for each observation. Make a column for this in the file with the heading "Y Hat"e v) Calculate a T statistic for B. Is the regression coefficient significant at the 95% confidence level? Use the critical values from a Zdistribution.~... Show moreA B 1 Payroll (millions) League Batting average 2 6.46 National 0.1607 0.001962 3 81.27 National 0.2647 0.001307 5.62 National 0.2413 5 45.27 National 0.2753 6 86.75 National 0.3101 87.83 National 0.3045 8 0.97 National 0.2256 9 52.6 National 0.2872 10 75.81 National 0.2667 11 19.66 National 0.3 12 73.92 National 0.3522 13 24.21 National 0.3001 14 61.29 National 0.2977 15 19.25 National 0.2806 16 48.3 National 0.3029 17 84.77 American 0.3253 18 57.08 American 0.4075 19 99.35 American 0.416 20 15.3 American 0.2877 21 61.06 American 0.3683 22 31.02 American 0.3576 23 78.18 American 0.3311 24 43.45 American 0.3538 25 47.05 American 0.3053 26 78.04 American 0.3088 27 9.33 American 0.3317 28 20.35 American 0.3333 29 73.41 American 0.3657 30 59.37 American 0.3126 31 50 American 0.334 32 33 Mean payroll mean batting average 34 49.899 0.310276667 35 36 Mean BA National 37 0.277973333 38 39 Mean BA American 40 0.3425841... Show moreMath STATISTICS 43
