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

  Please link to an advertisement that exemplifies

please link to an advertisement that exemplifies consumption as described in the text and define its relation to the material in the text

  Illustrate the major barriers to implement

Illustrate what, if any, are the major barriers to implementing a lean system at Copper Kettle Catering. Illustrate what would you recommend that Wayne also Janet Williams do to take advantage of lean concepts in operating CKC.

  Calculate the average time it takes a plane to clear

Calculate the average time it takes a plane to clear the runway once it has notified the airport that it is in the vicinity and wants to land

  How willow brook school determines discounts

Create a decision table that illustrates explain how Willow brook School determines which discounts, if any, are to be applied to fixed fees for a child.

  Production scheduling information systems for ferro

Two new production scheduling information systems for Ferro Corporation could be developed at a cost of $105,000 and $135,000 respectively

  Illustrate what kinds of things would likely requisite

Illustrate what scheduling must she do? Illustrate what things might occur to disrupt schedules also cause hazel to reschedule. Elucidate how important is quality assurance to hazel's business.

  How lead time demand is distributed normally

Given this information: Expected demand during lead time 300 units Standard deviation of lead time demand 30 units determine each of subsequent, assuming that lead time demand is distributed normally.

  Briefly describe the steps you might take to resolve

You suspect that your immediate supervisor is involved in a significant fraud involving diverting of organization assets to personal use. Briefly describe the steps you might take to resolve this dilemma.

  Which functional area of the five explained in the reading

Which functional area of the five explained in the reading does your department best fit into? Explain the functional area's mission and goals. If the functional area is not IT Systems, describe how IT Systems supports the functional area.

  Discuss some competitive strategies each company can adopt

Consider Coca-Cola also PepsiCo, two successful companies that compete with each or. Discuss some competitive strategies each company can adopt also some specific actions needed to support those strategies.

  Which shipping alternative would you recommend

Annual holding costs are 37 % of unit price. Three hundred also ninety boxes are to be shipped also every box has a price of $154. Which shipping alternative would you recommend.

  Company recently issued two types of bonds

Gregg Company recently issued two types of bonds. The first issue consisted of 20-year straight debt with an 8% coupon paid annually

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