1. Use the data in Table 4.3 to build a regression model with day of the week as the only independent variable.

For its first two decades of existence, the NBA’s Orlando Magic basketball team set seat prices for its 41-game home schedule the same for each game. If a lower-deck seat sold for $150, that was the price charged, regardless of the opponent, day of the week, or time of the season. If an upper-deck seat sold for $10 in the first game of the year, it likewise sold for $10 for every game.
But when Anthony Perez, director of business strategy, finished his MBA at the University of Florida, he developed a valuable database of ticket sales. Analysis of the data led him to build a forecasting model he hoped would increase ticket revenue. Perez hypothesized that selling a ticket for similar seats should differ based on demand.
Studying individual sales of Magic tickets on the open Stub Hub marketplace during the prior season, Perez determined the additional potential sales revenue the Magic could have made had they charged prices the fans had proven they were willing to pay on Stub Hub. This became his dependent variable, y, in a multiple regression model.
Video Case He also found that three variables would help him build the “true market” seat price for every game. With his model, it was possible that the same seat in the arena would have as many as seven different prices created at season onset—sometimes higher than expected on average and sometimes lower.
The major factors he found to be statistically significant in determining how high the demand for a game ticket, and hence, its price, would be were:
◆ The day of the week (x1)
◆ A rating of how popular the opponent was (x2)
◆ The time of the year (x3)