The National Football League (NFL) records a variety of performance data forindividuals and teams. To investigate the importance of passing on the percentageof games won by a team, the following data show the conference (Conf), averagenumber of passing yards per attempt (Yds/Att), the number of interceptions thrownper attempt (Int/Att), and the percentage of games won (Win%) for a random sampleof 16 NFL teams for the 2011 season (NFL web site, February 12, 2012).Use excel to answer the following questions. In addition to your written response, submit an excel file that shows your work labelled "Q 5 . x l s x".a) Develop the estimated regression equation that could be used to predict thepercentage of games won, given the average number of passing yards perattempt. What proportion of variation in the sample values of proportion ofgames won does this model explain?b) Develop the estimated regression equation that could be used to predict thepercentage of games won, given the number of interceptions thrown per attempt. What proportion of variation in the sample values of proportion of games wodoes this model explain?c) Develop the estimated regression equation that could be used to predict thepercentage of games won, given the average number of passing yards per attemptand the number of interceptions thrown per attempt. What proportion ofvariation in the sample values of proportion of games won does this modelexplain?d) The average number of passing yards per attempt for the Kansas City Chiefsduring the 2011 season was 6.2, and the team’s number of interceptions thrownper attempt was 0.036. Use the estimated regression equation developed in part(e) to predict the percentage of games won by the Kansas City Chiefs during the2011 season. Compare your prediction to the actual percentage of games wonby the Kansas City Chiefs. (Note: For the 2011 season, the Kansas City Chiefs’record was 7 wins and 9 losses.)Conference Yds/Att Int/Att Win%NFC 6.5 0.042 50.0NFC 7.1 0.022 62.5NFC 7.4 0.033 37.5AFC 6.2 0.026 56.3NFC 7.2 0.024 62.5NFC 8.9 0.014 93.8AFC 7.5 0.019 62.5AFC 5.6 0.026 12.5AFC 4.6 0.032 31.3NFC 5.8 0.033 18.8AFC 8.3 0.020 81.3NFC 8.1 0.021 81.3AFC 7.6 0.044 50.0NFC 6.5 0.011 81.3AFC 6.7 0.024 56.3NFC 6.4 0.041 31.3