Use the data in the Excel file Baseball Attendance to do the following a Develop spreadsheet...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use the data in the Excel file Baseball Attendance to do the following a Develop spreadsheet models for forecasting attendance using single moving average (use MA with k-2,3,4,5) Calculate the foretasted attendance for every year with every k parameter b Develop spreadsheet models for forecasting attendance using exponential smoothing method (with alpha=0.2, 04, 06 and 0.8) Calculate the foretasted attendance for every year with every alpha parameter c Using MAD MSE, and MAPE as guidance, find the best number of moving average penods (k parameter) and the best smoothing constant (alpha) for exponential smoothing Decide which method would you choose and state why? C 1 Year Attendance 1958 1273 1422 3. 1959 1960 4 1795 1961 1391 1962 1593 7. 1963 1571 8 1964 1504 9. 1965 1546 10 1966 1657 11 1967 1242 12 1968 1674 13 1969 1652 14 1970 1519 15 1971 2021 16 1972 1569 17 1973 1835 18 1974 1366 19 1975 1601 20 1976 1408 21 1977 1196 22 1978 2267 23 24 25 Use the data in the Excel file Baseball Attendance to do the following a Develop spreadsheet models for forecasting attendance using single moving average (use MA with k-2,3,4,5) Calculate the foretasted attendance for every year with every k parameter b Develop spreadsheet models for forecasting attendance using exponential smoothing method (with alpha=0.2, 04, 06 and 0.8) Calculate the foretasted attendance for every year with every alpha parameter c Using MAD MSE, and MAPE as guidance, find the best number of moving average penods (k parameter) and the best smoothing constant (alpha) for exponential smoothing Decide which method would you choose and state why? C 1 Year Attendance 1958 1273 1422 3. 1959 1960 4 1795 1961 1391 1962 1593 7. 1963 1571 8 1964 1504 9. 1965 1546 10 1966 1657 11 1967 1242 12 1968 1674 13 1969 1652 14 1970 1519 15 1971 2021 16 1972 1569 17 1973 1835 18 1974 1366 19 1975 1601 20 1976 1408 21 1977 1196 22 1978 2267 23 24 25
Expert Answer:
Answer rating: 100% (QA)
1 2YMA Year Value Forecast error abs error SE APE 1958 1273 1959 1422 1960 1795 13475 4475 4475 2002563 2493036 1961 1391 16085 2175 2175 4730625 1563623 1962 1593 1593 0 0 0 0 1963 1571 1492 79 79 62... View the full answer
Related Book For
Quantitative Analysis for Management
ISBN: 978-0132149112
11th Edition
Authors: Barry render, Ralph m. stair, Michael e. Hanna
Posted Date:
Students also viewed these business communication questions
-
Develop a three-period weighted moving average forecast for periods 4 through 11. Use weights of 0.4, 0.35, and 0.3, with the most recent observation weighted the highest. Calculate the MFE, MAD, and...
-
Develop a four-month moving average forecast for Wallace Garden Supply and compute the MAD. A three-month moving average forecast was developed in the section on moving averages in Table5.3. MONTH...
-
Use a spreadsheet to calculate the k values asked for in Prob. 13.22 In Problem 22 (a) Use Mathcad to create an animation showing how contours and three-dimensional plots of the H+2 LCAO MOs 1 and 2...
-
You require inventory and accounts receivable collateral for all C&I loans. You have a guideline of an advance rate of 70% for customer receivables of less than 60 days of age. Older receivables get...
-
Not having the computer echo the password is safer than having it echo an asterisk for each character typed, since the latter discloses the password length to anyone nearby who can see the screen....
-
Vulcan Company's contribution format Income statement for June is as follows: Vulcan Company Income Statement For the Month Ended June 30 Sales Variable expenses Contribution margin Fixed expenses...
-
Repeat Exercise 20 for samples of size 18 and 12. What happens to the mean and the standard deviation of the distribution of sample means as the sample size decreases? Data from Exercises 20 The...
-
The following determination and distribution of excess schedule is prepared on January 1, 2012, the date on which Parker Company purchases a 60% interest in Share Company: On December 31, 2013,...
-
1 Explain what leadership is, when leaders are effective and ineffective, and the sources of power that enable managers to be effective leaders. LO10-2 Identify the traits that show the strongest...
-
John Thompson, CEO of New Venture, Ic., seeks to raise $5 million in equity for his early stage venture in January 2016. NewVenture is a subscription-based software company that has experienced 75%...
-
what is the UML for this //Importing scanner class for taking user input import java.util.Scanner; //Class Helper public class Helper { /** * Using getInt method to get user to input Integer * @param...
-
Race and gender differences often correlate with poor treatment and support for mental health. What, if any, additional obligations should organizations have to act with a differential response? In...
-
How have other sports responded to athlete concerns about mental health? How have athletes in other sports brought attention to mental health concerns in their sport?
-
How should organizations be better prepared to publicly defend their governed athletes when raced or gendered attacks on those athletes occur? Moreover, for an event like the Olympics, which...
-
Update the chapter based on the current state of the COVID-19 pandemic. What role do athletes currently play in encouraging other preventive behaviors like vaccinations? Are there examples of...
-
What new developments have arisen in sports that affect how you think about this issue? How have other sports sought to deal with the issue of trans inclusion?
-
Describe an example you have experience with of the principal-agent problem (for example, you have a desire for your children to listen in school and do well, while for them, goofing off at school...
-
What is a make-or-buy decision?
-
The G. Saussy Manufacturing company is putting out four new electronic components. Each of Saussy's four plants has the capacity to add one more product to its current line of electronic parts. The...
-
What is the ROP? How is it determined?
-
Consider the following optimal tableau, where S1 and S2 are slack variables added to the original problem: (a) What is the range of optimality for the contribution rate of the variable X1? (b) What...
-
What are the basic forms of international business activity?
-
Discuss the meaning of international business.
-
What is international business? How does it differ from domestic business?
Study smarter with the SolutionInn App