Microsoft® Excel Data Analysis and Business Modeling

Chapter 73. Picking Your Fantasy Football Team

• What is fantasy football?

• What information do I need to pick a good team?

• How can I use the Excel Solver to pick my team?

What is fantasy football?

To play fantasy football, you choose a team (usually 10 players) and receive rewards based on player performances during the current season. In the league I entered, each player chooses the following positions:

• One quarterback (QB)

• One place kicker (K)

• Three running backs (RB)

• Three wide receivers (WR)

• One tight end (TE)

• One team’s defense (Team)

Each choice of player or team is assigned a price based on the player’s or team’s ability. For example, the great quarterback Michael Vick is assigned a price of $19 million. You have a total of $100 million to spend ...