Regression analysis method to calculate project attendence

Assignment Help Operation Management
Reference no: EM13100067

Southwestern University (SWU), a large state college in Stephenville, Texas, enrolls close to 20,000 students. The school is a dominant force in the small city, with more students during fall and spring than permanent residents.
Always a football powerhouse, SWU is usually in the top 20 in college football rankings. Since the legendary Bo Pitterno was hired as its head coach in 2007 (in hopes of reaching the elusive number 1 ranking), attendance at the five Saturday home games each year increased. Prior to Pitterno's arrival, attendance generally averaged 25,000 to 30,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 1975, has seating for 54,000 fans. The following table indicates attendance at each game for the past 6 years.
One of Pitterno's demands upon joining SWU had been a stadium expansion, or possibly even a new stadium. With attendance increasing, SWU administrators began to face the issue head-on. Pitterno had wanted dormitories solely for his athletes in the stadium as an additional feature of any expansion.
SWU's president, Dr. Joel Wisner, decided it was time for his vice president of development to forecast when the existing stadium would "max out."The expansion was, in his mind, a given. But Wisner needed to know how long he could wait. He also sought a revenue projection, assuming an average ticket price of $30 in 2013 and a 5% increase each year in future prices.
Please note, I need to use the Regression analysis method to calculate the project attendence through 2015.( Please show the step by step work so I can learn. not just the answer) Thanks in advance
\(\sum_{t=n}^{t=1}\)
(dt-Ft)^2
where dt= actual demand value foe period t
Ft= forecasted demand from the regression equation for period t
b= Sum of td-nt*d/ sum of t^2-nt^2
a= dt-bt
Where t= of all t values
dt= of all dt values
n= number of data point

Reference no: EM13100067

Questions Cloud

Determine the training costs : One group of 20 trainees estimated a total overall monthly cost benefit of $336,000 related to business improvements and showed an average 70 percent confidence level with that estimate.
Creating a gantt chart : A project requires completion of activities A, B, C, D, E, F, G, H, I and J.Additionally, there are two other logic relationships. Activity ‘H' can start only after 3 days have elapsed following the completion of activity ‘E'.
What restaurants are immensely successful in market : Are you aware of any restaurants in market which have failed/closed over past few years? If so, why do you believe that these restaurants failed/closed?
Probability in profession and real life : Do you use probability in your profession or real life? You most likely do. For example, chance of rain tomorrow is 27%. We hear similar probabilities in the media all the time.
Regression analysis method to calculate project attendence : Southwestern University (SWU), a large state college in Stephenville, Texas, enrolls close to 20,000 students. The school is a dominant force in the small city, with more students during fall and spring than permanent residents.
Probability calculation-titanic mortality data : In this the anniversary of the sinking of the Titanic, it is interesting to look at the distribution of those who survived, and those who died. The table below describes the number of men, women and children who were passengers on the Titanic.
Defectiveness in production process : A production process is known to produce a particular item in such a way that 5 percent of these are defective. If two items are randomly selected as they come off the production line
Understanding the dupont formula : While the industry average ROE is about 15%, average profit margin of 50%, asset efficiency of 10%, and leverage ratio of 3, the ROE for ABC, Inc., using data from January 2011, was 8.00% on an average shareholder's equity of $25,000,000.
Write issues affecting equal opportunity in education today : How did students come to receive opportunities, e.g. Title 1, they presently have in public education? What present issues are affecting equal opportunity in education today?

Reviews

Write a Review

Operation Management Questions & Answers

  What are china rights in regard to shipment in transit

Home store has already sold first shipment to a customer, who paid for goods also took them home. Illustrate what are China's rights in regard to shipment in transit.

  Drawing on hall''s high and low context

Drawing on hall's high and low context, describe some of the communication issues that might well arise when an arab company officer who hasvspent his career in the middle east is sent on temporary assignment

  Recommend that is claim is one for an intentional tort

Cortland want to sue Chandler in tort. Would you recommend that is claim is one for an intentional tort or negligence, and why? Which specific tort do you believe Cortland should pursue.

  Discuss these apparent contradictions

The Task: Millions of employees have lost their jobs due to Downsizing. At the same time, many organizations are complaining which they cannot find out qualified people to fill vacancies. Discuss these apparent contradictions.

  Elucidate what should be the optimal batch size

Elucidate what should be the optimal batch size (Q) of clay tigers to be produced also shipped to the stores in every order. Keep 4 digits after decimal points in calculations.

  The fda claims it has the right to classify new products

The FDA claims it has the right to classify new products as drugs and prevent their distribution until their safety is determined and approved for sale on the open market. Digesti-Aid disputes the FDA's decision and wants to bring a lawsuit to cha..

  Illustrate what would you recommend that they do.

WLAN worked well for one semester, but now more students have laptops with Wi-Fi built in also performance has deteriorated significantly. Illustrate what would you recommend that they do. Be sure to support your recommendations.

  Describe the roles of and relationships among the strategy

Describe the roles of and relationships among the strategy, architecture, systems and technology processes that should exist in a successful organization's IT function.

  Elucidate what is the lowest cost achievable for production

Elucidate what is the lowest cost achievable for the production also distribution network after the merger if plants can be scaled back or shut down in batches of 10 million units of capacity. Which plants serve which markets.

  What are strategic objectives

What are strategic objectives? What makes an effective strategic objective? What are some examples of strategic objectives

  Discuss major factors governing relative profitability

Current separations are far less distinct. military is eliminating some of its organization design. Discuss major factors governing relative profitability of a real estate investment.

  Business has been slow the past year due the construction

Your best friend owns a small children's clothing store located in the downtown area of a community of 50,000 citizens. Business has been slow the past year due the construction of several new strip malls and a new Wal-Mart store

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