For major league baseball teams, is there a relationship between player payrolls and gate money? Here are data for each of the National League teams for theyear 2000. The variable x denotes the 2000 player payroll (in millions of dollars), and the variable y denotes the mean attendance (in thousands of fans) for the81 home games that year. The data are plotted in the Figure 1 scatter plot.MeanPlayer payroll, x(in $1,000,000s) attendance, y(in thousands)Arizona87.034.81Atlanta94.539.88Chicago Cubs65.334.44CincinnatiColoradoFlorida52.631.8564.840.7430.915.06Houston58.337.78Los AngelesMilwaukeeMontrealNew York MetsPhiladelphiaPittsburghSan Diego105.037.1641.519.3839.511.4899.834.8153.919.884036.321.6029.88Player payroll (In $1,000,000s)64.1San Francisco59.640.99Figure 180.741.23St LouisSend data to ExcelSend data to calculatorAnswer the following. Carry your intermediate computations to at least four decimal places, and round your answers as specified below. (If necessary, consult alist of formulas.)The value of the sample correlation coefficient r for these data is approximately 0.722.(a) What is the value of the slope of the least-squares regression line for these data?Round your answer to at least two decimal places.|(b) what is the value of the y-intercept of the least-squares regression line for these data?Round your answer to at least two decimal places.SubmitI Don't Know72021 McGraw Hil LLC. All Rights Resened87F MMonty cleCipMean attendance(spue snoun ui) PhiladelphiaPittsburghSan Diego53.919.8836.321.60204060SO10012014064.129.88San FranciscoPlayer payroll (in $1,000,000s)59.640.99St Louis80.7Figure 141.23Send data to calculatorSend data to ExcelThe value of the sample correlation coefficient r for these data is approximately 0.722.Answer the following. Carry your intermediate computations to at least four decimal places, and round your answers as specified belist of formulas.)(a) What is the value of the slope of the least-squares regression line for these data?Round your answer to at least two decimal places.(b) What is the value of the y-intercept of the least-squares regression line for these data?Round your answer to at least two decimal places.日NDon't KnowSubmit02021 McGraw Hll LLC All Rights Reserved

Step-by-step procedure to find the regression line using Excel: In Excel sheet, enter x and y in…

Answer the following. Carry your intermediate computations to at least four decimal places, and round your aASWe list of formulas.) (a) What is the value of the slope of the least-squares regression line for these data? Round your answer to at least two decimal places. (b) What is the value of the y-intercept of the least-squares regression line for these data? answer to at least two decimal places.