The file P07_28.xlsx lists the scores of all NFL games played during the 2014 season. Use this data set to rank the NFL teams from best to worst. EXAMPLE 7.8 R ATING N FL T EAMS 9 We obtained the results of the 256 regular-season NFL games from the 2015 season (the 2016 season was still ongoing as we wrote this) and entered the data into a spreadsheet, shown at the bottom of Figure 7.38. See the file NFL Ratings Finished.xlsx. (Some of these results are hidden in Figure 7.38 to conserve space.) The teams are indexed 1 to 32, as shown at the top of the sheet. For example, team 1 is Arizona, team 2 is Atlanta, and so on. The first game entered (row 6) is team 19 New England versus team 25 Pittsburgh, played at New England. New England won the game by a score of 28 to 21, and the point spread (home team score minus visitor team score) is calculated in column J. A positive point spread in column J means that the home team won; a negative point spread indicates that the visiting team won. The goal is to determine a set of ratings for the 32 NFL teams that most accurately predicts the actual outcomes of the games played.

BuyFind

Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659
BuyFind

Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659

Solutions

Chapter
Section
Chapter 7.6, Problem 28P
Textbook Problem

The file P07_28.xlsx lists the scores of all NFL games played during the 2014 season. Use this data set to rank the NFL teams from best to worst.

EXAMPLE 7.8 RATING NFL TEAMS9

We obtained the results of the 256 regular-season NFL games from the 2015 season (the 2016 season was still ongoing as we wrote this) and entered the data into a spreadsheet, shown at the bottom of Figure 7.38. See the file NFL Ratings Finished.xlsx. (Some of these results are hidden in Figure 7.38 to conserve space.) The teams are indexed 1 to 32, as shown at the top of the sheet. For example, team 1 is Arizona, team 2 is Atlanta, and so on. The first game entered (row 6) is team 19 New England versus team 25 Pittsburgh, played at New England. New England won the game by a score of 28 to 21, and the point spread (home team score minus visitor team score) is calculated in column J. A positive point spread in column J means that the home team won; a negative point spread indicates that the visiting team won. The goal is to determine a set of ratings for the 32 NFL teams that most accurately predicts the actual outcomes of the games played.

Expert Solution

Want to see the full answer?

Check out a sample textbook solution.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.

Chapter 7 Solutions

Practical Management Science
Ch. 7.3 - ELECTRICITY PRICING AT FLORIDA POWER AND LIGHT...Ch. 7.3 - In the electricity pricing model in Example 7.4,...Ch. 7.3 - Continuing Problem 6, suppose the company is...Ch. 7.3 - PRICING SUITS AT SULLIVANS Sullivans is a retailer...Ch. 7.3 - Continuing the previous problem (the model in part...Ch. 7.4 - In estimating the advertising response function in...Ch. 7.4 - The best-fitting advertising response function in...Ch. 7.4 - In judging the fit of the estimated response...Ch. 7.4 - Starting with the solution to the advertising...Ch. 7.4 - The preceding problem indicates how fewer...Ch. 7.4 - In the solution to the advertising selection model...Ch. 7.4 - The advertising response function in Equation...Ch. 7.4 - In Example 7.5, we implied that each of the five...Ch. 7.5 - The Lafferty Company wants to locate a warehouse...Ch. 7.5 - The Lafferty Company wants to locate a warehouse...Ch. 7.5 - The Lafferty Company wants to locate a warehouse...Ch. 7.5 - The Lafferty Company wants to locate a warehouse...Ch. 7.6 - The file P07_28.xlsx lists the scores of all NFL...Ch. 7.6 - Carry out the suggestion in Modeling Issue 3. That...Ch. 7.6 - Carry out the suggestion in Modeling Issue 2 for...Ch. 7.6 - The file P07_31.xlsx contains scores on all of the...Ch. 7.6 - By the time you are reading this, the 2016 NFL...Ch. 7.6 - By the time you are reading this, the 20162017 NBA...Ch. 7.6 - The method for rating teams in Example 7.8 is...Ch. 7.7 - For each of the following, answer whether it makes...Ch. 7.7 - Add a new stock, stock 4, to the model in Example...Ch. 7.7 - In the model in Example 7.9, stock 2 is not in the...Ch. 7.7 - The stocks in Example 7.9 are all positively...Ch. 7.7 - The file P07_39.xlsx contains historical monthly...Ch. 7.7 - This problem continues using the data from the...Ch. 7.7 - Continuing the previous problem, find the...Ch. 7.7 - In many cases, the portfolio return is at least...Ch. 7.8 - Given the data in the file Stock Beta.xlsx,...Ch. 7.8 - Solve the previous problem, but analyze GE instead...Ch. 7 - Suppose Ford currently sells 250,000 Ford Mustangs...Ch. 7 - Suppose the current exchange rate is 115 yen per...Ch. 7 - Another way to derive a demand function is to...Ch. 7 - A company produces widgets at plants 1 and 2. It...Ch. 7 - If a monopolist produces q units, she can charge...Ch. 7 - It costs a company 15 to purchase an hour of labor...Ch. 7 - In the previous problem, what is the minimum-cost...Ch. 7 - The cost per day of running a hospital is 300,000...Ch. 7 - Two companies are producing widgets. It costs the...Ch. 7 - A company manufactures two products. If it charges...Ch. 7 - A brewing company has 100,000 to spend on...Ch. 7 - QH Company advertises during soap operas and...Ch. 7 - A beer company has divided Bloomington into two...Ch. 7 - A company uses raw material to produce two...Ch. 7 - JJ has given you 12 million to spend on...Ch. 7 - Based on Kolesar and Blum (1973). Suppose that a...Ch. 7 - A company has five factories. The x- and...Ch. 7 - Monroe County is trying to determine where to...Ch. 7 - Consider three investments. You are given the...Ch. 7 - You have 50,000 to invest in three stocks. Let Ri...Ch. 7 - An oil company must determine how many barrels of...Ch. 7 - Suppose that you are hiring a weather forecaster...Ch. 7 - The cost of producing x units of a product during...Ch. 7 - Four items are for sale in the Dollar Value store....Ch. 7 - Most economies have a goal of maximizing the...Ch. 7 - Each morning during rush hour, 10,000 people want...Ch. 7 - Based on Grossman and Hart (1983). A salesperson...Ch. 7 - Find the minimum perimeter rectangle having area...Ch. 7 - You are given that the two nonhypotenuse sides of...Ch. 7 - A cylindrical soda can has a volume of 20 cubic...Ch. 7 - City B is 10 miles downstream from city A. City A...Ch. 7 - You can swim two miles per hour and run six miles...Ch. 7 - A triangle has a 5-inch side and a 12-inch side....Ch. 7 - Your company is about to market a new golf club....Ch. 7 - For the product mix examples (Examples 3.1 and 3.2...Ch. 7 - For the oil blending example (Example 4.4 in...Ch. 7 - For the aggregate planning example (Example 4.3 in...Ch. 7 - Consider the sports ratings model in section 7.6....Ch. 7 - Consider the sports ratings model in section 7.6....Ch. 7 - UE is going to invest 400 million to acquire...Ch. 7 - Your family owns a large farm that can grow wheat,...Ch. 7 - GMS Stock Hedging Kate Torelli, a security analyst...Ch. 7 - GMS Stock Hedging Kate Torelli, a security analyst...Ch. 7 - GMS Stock Hedging Kate Torelli, a security analyst...Ch. 7 - GMS Stock Hedging Kate Torelli, a security analyst...

Additional Business Textbook Solutions

Find more solutions based on key concepts
Define total productive efficiency.

Cornerstones of Cost Management (Cornerstones Series)

Define expenses. What do expenses measure?

Intermediate Accounting: Reporting And Analysis

Why might it be rational for a small firm that does not have access to the capital markets to use the payback m...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)

How does an employer file an amended Form 940?

PAYROLL ACCT.,2019 ED.(LL)-TEXT