NFL ATTENDANCE, TICKET PRICES AND WINNING

ASSIGNMENT #3 – NFL ATTENDANCE, TICKET PRICES AND WINNING

Main Research Topic

Does demand theory (i.e. the relationship between prices and quantities) apply to professional sports?  This paper will explore how well demand theory applies to the National Football League (NFL).

1. Procedure
2. Create a Microsoft Excel file. Download the following NFL data for 2006 to 2015 (into three separate worksheets in the same file):  attendance, ticket prices and win %.  Sort each worksheet alphabetically by team.  Cull out all teams that did not play during the 10 seasons in question.  Make sure you do not delete a team that only played some of the seasons!  Cull out all teams that did not play at all during the 10 seasons in question.  Make sure you do not delete a team that only played some of the seasons! If a team moved from one city to another, treat them as separate franchises.

2015. Create a separate worksheet within the same Excel file. Create two columns for each team. Put attendance and ticket prices for each year in these columns. The rows will have the years from 2006 to 2015.  Calculate the correlation coefficient for each team from 2006 to 2015 using the Correl formula in Excel.  Calculate the average correlation coefficient across all the teams in the league.

1. Create a separate worksheet within the same Excel file. Create two columns for each year from 2006 to 2015 (i.e. the years should be in one row with two columns under each year). Put attendance and ticket prices for each year in these columns. Calculate the correlation coefficient for the league each year using the Correl formula in Excel.

1. Create a separate worksheet within the same Excel file. Create two columns for each year from 2006 to 2015 (i.e. the years should be in one row with two columns under each year). Put attendance and win % for each year in these columns. Calculate the correlation coefficient for the league each year using the Correl formula in Excel.

1. Create a separate worksheet within the same Excel file. Create two columns for each year from 2006 to 2015 (i.e. the years should be in one row with two columns under each year). Put ticket prices and win % for each year in these columns.  Calculate the correlation coefficient for the league each year using the Correl formula in Excel.

2015. In a separate worksheet within the same Excel file, create a summary table of the three different correlation coefficients from parts C, D and E from 2006 to 2015. Calculate the averages across the 10-year period for all three variables. Within that same worksheet, create a line chart for all three different correlation coefficients for the same period.