Develop a forecasting model

Assignment Help Mathematics
Reference no: EM131068167

Southwestern University (SWU), a large state college in Stephenville, Texas, 30 miles southwest of the Dallas/Fort Worth metroplex, enrolls close to 20,000 students. In a typical town-gown relationship, the school is a dominant force in the small city, with more students during fall and spring than permanent residents.

A longtime football powerhouse, SWU is a member of the Big Eleven conference and is usually in the top 20 in college football rankings. To bolster its chances of reaching the elusive and long-desired number-one ranking, in 2005 SWU hired the legendary Bo Pitterno as its head coach. Although the number-one ranking remained out of reach, attendance at the five Saturday home games each year increased. Prior to Pitterno's arrival, attendance generally averaged 25,000 to 29,000 per game. Season ticket sales bumped up by 10,000 just with the announcement of the new coach's arrival. Stephenville and SWU were ready to move to the big time!

The immediate issue facing SWU, however, was not NCAA ranking. It was capacity. The existing SWU stadium, built in 1953, has seating for 54,000 fans. The following table indicates attendance at each game for the past six years.

One of Pitterno's demands upon joining SWUhad been a stadium expansion, or possibly even a new stadium. With attendance increasing, SWU administrators began to face the issue head on. Pitterno had wanteddormitoriessolely for his atheletes in the stadium as additional feature of any expansion.

SWU's president Marty Starr, decidedit was time for his vice presidentof development to forecast when the existing stadium would "max-out". He also sought a revenue projection, assuming an average ticket price of $20in 2011 and a 5% increase each year in the future prices.

Southwestern University Football Game Attendance, 2005-2010


2005
2006 2007
GAME ATTENDEES OPPONENT ATTENDEES OPPONENT ATTENDEES OPPONENT
1 34,200 Baylor 36,000 Oklahoma 35,900 TCU
2* 39,800 Texas 40,200 Nebraska 46,500 Texas Tech
3 38,200 LSU 39,100 UCLA 43,100 Alska
4** 26,900 Arkansas 25,300 Nevada 27,900 Arizona
5 35,100 USC 36,200 Ohio State 39,200 Rice


2008 2009 2010
GAME ATTENDEES OPPONENT ATTENDEES OPPONENT ATTENDEES OPPONENT
1 41,900 Arkansas 42,500 Indiana  46,900 LSU
2* 46,100 Missouri 48,200 North Texas 50,100 Texas
3 43,900 Florida 44,200 Texas A&M 45,900 Prairie View A&M
4** 30,100 Miami 33,900 Southern 36,300 Montana
5 40,500 Duke 47,800 Oklahoma 49,900 Arizona State

Discussion Questions:

1. Develop a forecasting model, justify its selection over other techniques, and project attendance through 2012.

2. What revenues are to be expected in 2011 and 2012?

3. Discuss the school's options.

Reference no: EM131068167

Questions Cloud

What is the decision rule : A sample of 64 observations is selected from a normal population. The sample mean is 215, and the population standard deviation is 15. Conduct the following test of hypothesis using the .025 significance level.
Data file description : Describe the context of the data set. Cite a previous description if the same data set is used from a previous assignment. To increase formal tone of the DAA, avoid first-person perspective "I." For example, do not write, "I ran a scatter plot sho..
Information about the records of the two local teams : As a statistician that makes you wonder, is this true?  Are these two events actually dependent or independent?  After the end of the season you collect the following information about the records of the two local teams (identifying a total of 82 ..
Purpose of conducting an experiment : From Jackson (2016): Chapter Exercises #1, 2, and 4 only for Ch. 9 (p. 252-253). What is the purpose of conducting an experiment? How does an experimental design accomplish its purpose? In an educational study, what are the advantages and disadvantag..
Develop a forecasting model : Develop a forecasting model, justify its selection over other techniques, and project attendance through 2012.  What revenues are to be expected in 2011 and 2012
What are degrees of freedom : From Jackson (2016): even-numbered Chapter exercises for Ch. 8 and 10 (p. 223-224; 274-275) What are degrees of freedom? How are they calculated?
What fraction of kindergarten kids should the company expect : What fraction of kindergarten kids should the company expect to be less than36inches? tall?Aboutnothing?%of kindergarten kids are expected to be less than36inches tall.?(Round to one decimal place as? needed.)
Literary analysis essay on two kinds by amy tan : Background: Amy Tan's story, "Two Kinds," demonstrates the importance of the past on shaping characters' present identity, thus reinforcing the notion that personal history shapes an individual's cultural identity and attitudes about the world in ..
What is value for the chi-sq critical : A reasearcher is running a chi-sq test. She would like to test her hypothesis at the alpha=.05 and finds that her research situation has 5 degrees of freedom. What is value for the chi-sq critical?

Reviews

Write a Review

Mathematics Questions & Answers

  Determining cosets and subgroups

Let G = RxR (R is the real numbers) with addition (x,y) + (x', y') = (x+x', y+y'). Let H be the line y=mx through the origin: H = {(x,mx)such that x belongs to R (R is real numbers).

  You notice the plane is at an angle of elevation 18

an airplane is flying a speed of 238 mph toward you. you notice the plane is at an angle of elevation 18 degrees.

  Find the equation of the line for the demand equation

Find the equation of the line for the demand equation. Write your answer in the form p = mx + b. (Hint: Write an equation using two points in the form (x,p)).

  Find the area a of the region r.

Find the values α and β of θ in [-π,π] corresponding to the points at which the graphs intersect, withα

  Compute the conversion factor between light-years and meters

A light-year is a measure of length equal to the distance that light travels in 1 year. Compute the conversion factor between light-years and meters, and find the distance to the star Proxima Centauri 4 1016 m in light-years.

  A initial step unit head decides to investigate most

nbspchannel 4 news story claims that the city environmental preservation unit pays too much for routine automobile

  How many days would be needed to add 15 million

In the early months of 2010, Twitter added 0.3 million new accounts every day. At this rate, how many days would be needed to add 15 million new Twitter accounts? (Source: Twitter.)

  How many weeks will the pond have the same depth

the depth of a pond is 180 cm and is being reduced by 1 cm per week. the depth of a second pond is 160 cm and is being reduced by 1/2 cm per week. if the depths of both ponds continue to be reduced at these constant rates, in about how many weeks ..

  State the estimated linear regression equation

State the estimated linear regression equation. State and interpret the slope coefficient, b1 which depicts the changes in the braking distance by the vehicle speed.

  The data below are the final exam scores of 10 randomly

the data below are the final exam scores of 10 randomly selected statistics students and the number of hours they

  A building is located at the end of a street that is

question a building is located at the end of a street that is inclined at an angle of 8.4ordm with the horizontal. at a

  Functions and reversal of variables

Where in the real world might be a situation arise where it would be preferable for data to form a relation but not a function? Please explain it to me in detail

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd