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

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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