1. Visit the website https://github.com/fivethirtyeight/. Find the nfl-elo-game link and down load the CSV NFL games file. I suggest you immediately convert it to an xlsx file otherwise you risk losing work you do every time you close the file.

2. You first need to choose to study Chicago (CHI) or Detroit (DET). Sort or filter the spread sheet appropriately to organize all the games the team you chose played, the season it was played, the team's score and whether they won. I recommend you put all that data in a new spreadsheet.

3. Write which team you are studying here. DET

4. For now we are going to restrict ourselves to the modern era of the NFL which began in 1970 when the NFL and AFL merged. Calculate the average score and standard deviation of scores for all games played by your team from the 1970 season through the 1999 season.

Total number of games played by your team from 1970 through 1999:

Population mean: Population standard deviation:

5. We are interested in determining whether the average game score for your team from 2000- 2020 is different from the average game score from 1970-1999. Write the null and alternative hypothesis for that hypothesis test in the space provided.

6. Next find a random sample of 50 games from all games played by your team from the 2000 season through the season 2020 using the Integer Set Generator at random.org. Calculate the sample mean score for your sample.

Sample mean:

7. complete hypothesis test by calculating theP-value (assumingis equal to the popu lation standard deviation from 1970-1999).

P-value:

8. Draw a nice picture of the Normal distribution used for the test with the appropriate area shaded that gives theP-value.

9. State your conclusion of the hypothesis test based on a significance level of= 0.05.

10. Next find a random sample of 50 games from all games played (from every season) by your team using the Integer Set Generator at random.org. Calculate a 95% confidence interval for the proportion of games won by the team and write it here along with the formula used for that calculation.

Confidence Interval:

Formula for your calculation:

11. Calculate the population proportion of wins for all games played by your team and determine if that number is in your confidence interval.

Total number of games played by your team:

Population proportion: Ispin your CI?: