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...
-
In Problems 29-38, simplify and express answers using positive exponents only. 12m n-
-
What was the organizational problem in this story? Can someone be responsible for something over which that person does not have authority? How should the new manager have handled Billys request to...
-
A lot of compensation information is available to employees today on the Web (e.g., www.salary.com), and much of it is inaccurate. How can an organization assure employees that they are fairly...
-
The Whistle Stop Cafe in Weems, Georgia, is well known for its popular homemade ice cream, made in a small plant in back of the cafe. People drive all the way from Atlanta and Macon to buy the ice...
-
Your company needs to make one payment of RM5 million to the supplier. The payment must be made within 6 months. You have made arrangements with the bank to obtain a 3-month loan of RM5 million...
-
On December 31, Y3, Aylmer Industries Inc. purchased 85% of the outstanding shares of Belmont Inc. The purchase price is indicated on the excel file. The entry has been recorded on the books of...
-
Please include the calculations for all of these. I'm not sure how to do it. Thank you Consider a bond with 7% annual coupon and a face value of $1000. Calculate the current price of the bond for...
-
The following table sets out information in respect of Division X and Division Y. The cost of borrowing new finance is 10% per annum. Required Explain what view the managers of each division might...
-
As technology becomes more sophisticated and complicated, which challenges presented by virtual teams might become more problematic?
-
This extract describes changes in the UK company Bunzl, which announced at the start of 2005 that it would sell Filtrona, a business making cigarette filters, and concentrate on its outsourcing...
-
Explain what is meant by the accrual of liabilities.
-
Describe the main contents of a business plan for presenting to a bank providing finance for a small business.
-
What is one of the benefits of the Madrid protocol in regard to protecting a firms intellectual property? a. It allows the extension of a firms patent into other member countries without the use of a...
-
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...
-
Explain how the financial manager might use industry norms in the design of the companys financing mix.
-
You have developed the following income statement for Sing-Tel Corporation. It represents the most recent years operations, which ended yesterday. Your supervisor in the controllers office has just...
-
Financial data for three corporations are displayed here. MEASURE FIRM FIRM FIRM INDUSTRY A B C NORM Debt ratio 21% 24% 39% 21% Times interest 7.5 10.2 7.0 9.1 times earned times times times...
Study smarter with the SolutionInn App