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

  Illustrate what is percent change in multifactor product

Illustrate what is the percent change in multifactor productivity if the manufacturer can reduce the energy bill by $2000 per day without cutting production or changing any other inputs.

  A company has recorded the last five days of daily

A company has recorded the last five days of daily demand on their only product. Those values are 120, 125, 124, 128, and 133. The time from when an order is placed to when it arrives at the company from its vendor is 5 days

  Hospital medical staff office at the rural outreach

You are the assistant director of the hospital medical staff office at The Rural Outreach Community Hospital in a tiny town in Arkansas. It is your job to verify physician credentials for staff privileges

  Calculations for the average at the bottom of the sheet

Do your work on scratch paper and transfer your two RN tables and your five daily sales tables NEATLY onto this page, please be clear, putting your calculations for the average at the bottom of the sheet clearly marked

  Beth zion hospital has received initial certification

Beth Zion Hospital has received initial certification from the state of California to become a center for liver transplants. The hospital, however, must complete

  Discuss how to increase a team''s potential to survive

Discuss a, b, c, d, and e fully and separately: (a) the phases of a team life cycle; (b) why teams lose momentum; (c) how to increase a team's potential to survive, be productive, and flourish in the long term

  What are your managerial motives

you are very enthusiastic about the oppoertunity to be a leading captain of industry and the associated power, prestige, and income.( you expect your salary, bouns, and stock option to double next year)

  Compute mape for management''s technique

(a) Compute MAPE for management's technique,  (b) Do management's results outperform (ex have smaller MAPE than) a naive forecast?, (c) Which forecast do you recommend, based on lower forecast error?

  Describe b2b technologies also applications

Describe B2B technologies also applications also ways B2C can use technology to utilize e-business strategies.

  Discuss advantages also disadvantages of intermediaries

Discuss advantages also disadvantages of utilizing intermediaries like wholesalers, agents also brokers to distribute your organizations products or services.

  What are four products that company makes

A company makes four products that have the following characteristics. The processing requirements for each product on each of the four machines are explain how in the table.

  Elucidate how do the required skills differ for someone work

Elucidate how do the required skills differ for someone working in a factory. Illustrate what are the implications for hiring criteria also training.

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