Answer the following questions using the data from the Excel file average bonus.xlsx from Problem 16.43. a.
Question:
Answer the following questions using the data from the Excel file average bonus.xlsx from Problem 16.43.
a. Using exponential smoothing with a = 0.5, forecast the average cash bonus for a financial investment employee in New York City in 2013.
b. Calculate the MAD for the forecast in part a.
c. Using exponential smoothing with trend adjustment, a = 0.5 and b = 0.5, forecast the average cash bonus for a financial investment employee in New York City in 2013.
d. Calculate the MAD for the forecast in part c.
e. Which forecast do you have most confidence in?
AppendixLO1
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answered By
Divya Munir
I hold M.Sc and M.Phil degrees in mathematics from CCS University, India and also have a MS degree in information management from Asian institute of technology, Bangkok, Thailand. I have worked at a international school in Bangkok as a IT teacher. Presently, I am working from home as a online Math/Statistics tutor. I have more than 10 years of online tutoring experience. My students have always excelled in their studies.
0 Reviews
10+ Question Solved
Related Book For 
Question Posted:
