Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following information is for Questions 1 through 5 : The figures below indicate the number of mergers that took place in the savings and
The following information is for Questions 1 through 5 : The figures below indicate the number of mergers that took place in the savings and loan industry over a twelve-year perind Question 1 (5 pts): Use a 2-year moving average to calculate forecasts for the years 1992-2002. Question 2 (7 pts): Use a 2-year weighted moving average to calculate forecasts for the years 19922002 , with the weight of 0.7 to be assigned to the most recent year data. ("sumproduct" function must be used.) Question 3 (6 pts): Calculate the forecasts for the years 1990-2001 using exponential smoothing with alpha =0.8. Question 4 (10 pts): Calculate the forecasts for the years 1990-2001 using the Linear Trendline. Note: Renumber the \# of periods to start with t=1. a) Plot the data and add the linear trendline. The graph will also be part of your answer. b) Use functions to obtain the estimates for a and b and format them to show two decimal places. c) Use the estimated intercept and slope to calculate the forecasts for years 1990-2001. Question 5 (12 pts): Calculate MAD, MAPD and Cumulative Error for the forecasts you derived (for years 1990-2001) using the exponential smoothing and linear trendline in Q3 and Q4. According to your results, which forecasting technique performed better
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started