The National Football League (NFL) records a variety of performance data for individuals and teams. To investigate the importance of passing on the percentage of games won by a team, the following data showthe average number of passing yards per attempt (Yds/Att) and the percentage of games won (WinPct) for a random sample of 10 NFL teams for the 2011 season (NFL website).TeamArizona CardinalsAtlanta FalconsCarolina PanthersChicago BearsDallas CowboysNew EnglandPatriotsPhiladelphia EaglesSeattle SeahawksSt. Louis RamsTampa BayBuccaneersa. Choose the correct a scatter diagram with the number of passing yards per attempt on the horizontal axis and the percentage of games won on the vertical axis.A. WinPct80-70+60-50-30C. WinPct80-70--60-50-40--30-20-6Yds/Att7Yds/Att89B.Win Pct8070-60-50+40-30-D. WinPct80-70+60-50-40-30-20-6Yds/Att7Yds/Att89Yds/Att7.56.87.56.15.35.76.66.16.45.0WinPct79606943384256434824 b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables?The scatter diagram indicates a positivelinear relationship between x = average number of passing yards per attempt and y = the percentage of games won by the team.c. Develop the estimated regression equation that could be used to predict the percentage of games won given the average number of passing yards per attempt. Enter negative value as negative number.WinPct =* +() (Yds/Att) (to 4 decimals)d. Provide an interpretation for the slope of the estimated regression equation (to 1 decimal).So, for every increaseThe slope of the estimated regression line is approximatelyteam increases by*%.✔ of one yard in the average number of passes per attempt, the percentage of games won by thee. For the 2011 season, the average number of passing yards per attempt for the Kansas City Chiefs was was 6.5. Use the estimated regression equation developed in part (c) to predict the percentage of gameswon by the Kansas City Chiefs. (Note: For the 2011 season the Kansas City Chiefs' record was wins and 9 losses.)% (to 2 decimals)Compare your prediction to the actual percentage of games won by the Kansas City Chiefs.Considering the small data size, the prediction made using the estimated regression equation is not too bad

Given data: Yds/Att WinPct 7.5 79 6.8 60 7.5 69 6.1 43 5.3 38 5.7 42 6.6 56 6.1 43 6.4 48 5 24 (a) A scatterplot for the data can be obtained using Excel. Enter the data in Excel sheet Highlight the data Go to Insert > Charts Select Scatterplot Add axis titles Excel output is given below: Option C is the correct graph. The scatterplot indicates a positive linear relationship between the two variables. (c) The regression equation can be obtained using Excel. Enter the data in Excel sheet Go to DATA > Data analysis Select Regression, click ok Enter Y range i.e., WinPct Enter X range i.e., Yds/Att Select the output range Click ok Excel output is given below: Thus, the estimate regression equation is: WinPct=-66.2906+18.4905(Yds/Att) (d) The slope of the estimate regression line is approximately 18.5. So, for every increase of one yard in the average number of passes per attempt, the percentage of games won by the team increases by 18.5% NOTE: Hi there! Thank you for the question. As per the honor code, we are allowed to answer three sub-parts at a time so we are answering the first three as you have not mentioned which of these you are looking for. Please re-submit the question separately for the remaining sub-parts.