excel nfl standings spreadsheet microsoft

#Excel nfl standings spreadsheet microsoft full

Sc% DEF - Percentage of drives ending in an offensive score against.YdsPen OFF - Penalty yards committed by offense.TO% OFF - Percentage of drives ending in an offensive turnover.Sc% OFF - Percentage of drives ending in an offensive score for.

Margin - Difference between Points For (PF) and Points Against (PA).

Personally, I feel that these variables are the best determinants of an NFL team's ability to win: What are the most important variables that are used in determining an NFL team's ability to win? The answer to this question varies depending on your opinion. Therefore, I needed to filter out the data into only the variables that I deemed most relevant to a team's ability to win. After importing the Team Offense and Defense tables from Pro Football Reference to Microsoft Excel, I was overwhelmed by the twenty-five columns of statistics. Too much irrelevant data can be a problem. From here I was able to import the 2018 Team Offense and Defense data to Microsoft Excel with ease by using the 'Get as Excel Workbook (experimental)' feature. In regards to NFL data, Pro Football Reference is a wonderful resource that offers an abundant amount data. So, I determined that the 2018 Team Offense and Defense statistics of each team (before Week 12) would serve as a good indicator of how each team ranks so far. I am looking to predict the outcomes for each of the games during Week 12 of the 2018 NFL season. Prior to making any predictions, the first thing you must do is collect your data.

#Excel nfl standings spreadsheet microsoft full

Terrence Davis and his article ' PREDICTING NBA FAVORITES WITH MICROSOFT EXCEL and DATA SCIENCE' for inspiring me to start this project.Ĭlick HERE to access the full Microsoft Excel Workbook. Are you curious whether or not your favorite football team will win this week? What if I told you there was a way to predict the outcome of every match up in the NFL? With the use of Microsoft Excel and Data Analysis, that is precisely what I did for Week 12 of the 2018 NFL season and I will show you how I did it.īefore I dive into my method and results, I want to credit Mr.