Calculate and answer parts a through d. Include all calculations and spreadsheets in your post. Explain why the moving average method was used instead of another forecasting method. What might be another forecasting method that could prove to be just as useful? The figures below indicate the number of mergers that took place in the savings and loan industry over a 12-year period. Year Mergers Year Mergers 2000 46 2006 83 2001 46 2007 123 2002 62 2008 97 2003 45 2009 186 2004 64 2010 225 2005 61 2011 240 Calculate a 5-year moving average to forecast the number of mergers for 2012. Use the moving average technique to determine the forecast for 2005 to 2011. Calculate measurement error using MSE and MAD. Calculate a 5-year weighted moving average to forecast the number of mergers for 2012. Use weights of 0.10, 0.15, 0.20, 0.25, and 0.30,with the most recent year weighted being the largest. Use regression analysis to forecast the number of mergers in 2012.
Calculate and answer parts a through d. Include all calculations and spreadsheets in your post. Explain why the moving average method was used instead of another forecasting method. What might be another forecasting method that could prove to be just as useful? The figures below indicate the number of mergers that took place in the savings and loan industry over a 12-year period. Year Mergers Year Mergers 2000 46 2006 83 2001 46 2007 123 2002 62 2008 97 2003 45 2009 186 2004 64 2010 225 2005 61 2011 240 Calculate a 5-year moving average to forecast the number of mergers for 2012. Use the moving average technique to determine the forecast for 2005 to 2011. Calculate measurement error using MSE and MAD. Calculate a 5-year weighted moving average to forecast the number of mergers for 2012. Use weights of 0.10, 0.15, 0.20, 0.25, and 0.30,with the most recent year weighted being the largest. Use regression analysis to forecast the number of mergers in 2012.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.7: Exponential Smoothing Models
Problem 29P: The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building...
Related questions
Question
100%
Calculate and answer parts a through d. Include all calculations and spreadsheets in your post. Explain why the moving average method was used instead of another
The figures below indicate the number of mergers that took place in the savings and loan industry over a 12-year period.
Year | Mergers | Year | Mergers |
2000 | 46 | 2006 | 83 |
2001 | 46 | 2007 | 123 |
2002 | 62 | 2008 | 97 |
2003 | 45 | 2009 | 186 |
2004 | 64 | 2010 | 225 |
2005 | 61 | 2011 | 240 |
- Calculate a 5-year moving average to forecast the number of mergers for 2012.
- Use the moving average technique to determine the forecast for 2005 to 2011. Calculate measurement error using MSE and MAD.
- Calculate a 5-year weighted moving average to forecast the number of mergers for 2012. Use weights of 0.10, 0.15, 0.20, 0.25, and 0.30,with the most recent year weighted being the largest.
- Use regression analysis to forecast the number of mergers in 2012.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 8 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing