please answer clearly including all steps in an excel format. Thank you

for a random sample ol Wus NN Conf NFC NFC NFC AFC NFC NFC AFC AFC AFC NFC AFC NFC AFC NFC AFC NFC Team Arizona Cardinals Atlanta Falcons Carolina Panthers Cincinnati Bengals Detroit Lions Green Bay Packers Houston Texans Indianapolis Colts Jacksonville Jaguars Minnesota Vikings New England Patriots New Orleans Saints Oakland Raiders San Francisco 49ers Tennessee Titans Washington Redskins Yds/Att 6.5 7.1 7.4 6.2 7.2 8.9 7.5 5.6 4.6 5.8 8.3 8.1 7.6 6.5 6.7 6.4 Int/Att 0.042 0.022 0.033 0.026 0.024 0.014 0.019 0.026 0.032 0.033 0.020 0.021 0.044 0.011 0.024 0.041 500 62.5 375 563 625 938 625 125 313 18. 813 813 500 813 563 313 a. Develop the estimated regression equation that could be used to predict the percent age of games won, given the average number of passing yards per attempt. What proportion of variation in the sample values of proportion of games won does this model explain? b. centage of games won, given the number of interceptions thrown per attempt. What proportion of variation in the sample values of proportion of games won does this model explain? c. Develop the estimated regression equation that could be used to predict the per- centage of games won, given the average number of passing yards per attempt and the number of interceptions thrown per attempt. What proportion of variation in the sample values of proportion of games won does this model explain? d. The average number of passing yards per attempt for the Kansas City Chiefs during the 2011 season was 6.2, and the team's number of interceptions thrown per attempt was 0.036. Use the estimated regression equation developed in part (c) to predict the percentage of games won by the Kansas City Chiefs during the 2011 season. Compare your prediction to the actual percentage of games won by the Kansas City Chiefs. (Note: For the 2011 season, the Kansas City Chiefs' record was 7 wins and 9 losses.) e. Did the estimated regression equation that uses only the average number of passing yards per attempt as the independent variable to predict the percentage of games won provide a good fit