engage.com/staticb/ui/evo/index.html?deploymentld=5996522321531871212453615008&elSBN=9780357131596&id=1475435382&sn... A to AGE | MINDTAP Q Search this cours Activity 1a - Linear Regression and Predictions (Structured) Video Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak 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 data in the Excel Online file below show the conference (Conf), average number of passing yards per attempt (Yds/Att), the number of interceptions thrown per attempt (Int/Att), and the percentage of games won (Win%) for a random sample of 16 NFL teams for a season. Construct a spreadsheet to answer the following questions. X Open spreadsheet a. 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 (to 1 decimal): Win% = bo + b1 . Yds/Att bo = b1 = b. Develop the estimated regression equation that could be used to predict the percentage of games won given the number of interceptions thrown per attempt (to 1 decimal). Win = bo + bj . Int/Att bo = 61 = 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 and the number of interceptions thrown per attempt (to 1 decimal). Back Autosaved at 12:15 AM Next N 6/4