(See Solution) Boy are you lucky. Marty loved your report and thinks that you are the greatest statistician ever alive (Little does he know.). Anyway, he now


Question: Boy are you lucky. Marty loved your report and thinks that you are the greatest statistician ever alive (Little does he know.). Anyway, he now wants you to take the same raw data found in question 33 and complete the following table using single exponential smoothing, then graph the results, and tell him if there are issues he needs to understand about seasonal purchases of this motors versus forecasted number of motors. Again this is a three part answer – complete the table, graph the results (actual versus forecasted amounts), and explain the results to Marty. Oh, by the way, use .2 as the dampening factor.

NOTE: You can do this by hand; you need not us e Excel for this answer!

Quarter Motors Sold Forecast from the prior period Forecast for the next period
1 6360
2 6240
3 6110
4 6505
5 6300
6 6320
7 6470
8 6630
9 6200
10 6350
11 6390
12 6500

Price: $2.99
Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in