preview

Least Squares Regression

Good Essays

Results of Least Squares Regression The results of the least squares regression were largely in line with my expectations. One result that is surprising is that Metropolitan Unemployment is positive and nearly significant 99 percent significant. Arena Age is negative and statistically significant. This result seems to fall in line with a theoretical model well since fans consume less hockey games as a stadium ages. Additionally, in the theoretical model I hypothesized that a more successful team will make going to hockey games more enjoyable and result in an increase in attendance. The results of the regression confirm that the theoretical model is correct. Points earned, and making the post season are both positive and statistically significant. …show more content…

The simulation was done by taking the coefficients from the regression and entering them into an excel spreadsheet. Then I gathered the current data for Las Vegas’s population and unemployment. After multiplying the coefficients and quantities, I added the total for a projection of the attendance. Before moving on to the results it is worth mentioning that the model makes a couple of key assumptions. One is that the average ticket price in the model is $47.69. This number reflects the average ticket price across all teams from 2001-2012. Secondly, I assume that during the first season the team collects 89 points. Just as with ticket prices, this is the average number of points earned across all teams from 2001-2012. If Las Vegas’s new team collects an average point total and charges average ticket prices the attendance in the first year should be 15,543. A second simulation was done with an average ticket price, but now the team collects 100 points. Under these conditions Las Vegas’s team should have an average attendance of 15,669. Lastly, a third simulation was run with the team charging an average ticket price and only earning 70 points. 70 points was chosen since it seemed to fit the performance of other expansion teams in Columbus, Nashville, Atlanta and Minnesota. If Las Vegas’s team struggles in its first season and only collects 70 points the average attendance should be 14,610. While past results are no guarantee of the future, it is reasonable to expect that in the first season Las Vegas’s expansion team is likely to struggle, given similar results with expansion teams in the late 1990’s and early

Get Access