Reference no: EM13135201
a) Tell why you selected the appropriate exponential smoothing method by commenting on your Y data characteristics. (you should use a time series plot and autocorrelations to do this). Explain.
b) Apply the appropriate exponential smoothing forecast technique to your Y variable excluding the last year of data (hold out period). Show the Y data, fitted values and residuals in excel format and show your exponential smoothing model coefficients. (Find the correct coefficient and not just use the default values.) Explain.
c) Evaluate the "Goodness To Fit" using at least two error measures - RMSE and MAPE.Explain.
d) Check the "Fit" period residual mean proximity to zero nd randomness with a time series plot; check the residual time series plot and autocorrelations (ACFs) for trend, cycle and seasonality. Explain.
e) Evaluate the residuals for the "Fit" period by indicating the residual distribution using a histogram (normal or not and random or not), Explain.
f) Comment on the acceptability of the model's ability to pick up the systematic variation in your Fit period actual data. Explain.
g) Develop a one year forecast (for the hold out period of 8 quarters). Explain
h) Evaluate the "Accuracy" of the forecast for the "hold out period" using RMSE and MAPE error measures used from forecast period residuals and comment them.
i) Do the forecast period residuals seem to be random relative to the hold out period data? Check the forecast period time series plot of the residuals.
j) Did the error measures get worse, remain the same or get better from the fit to the hold out period? Do you think the forecast accuracy is acceptable?
Attachment:- Data.xlsx
|
What amount should kim report in its 2011 statement
: Kim Co. reported bonds payable of $35,000 at December 31, 2010 and $32,000 at December 31,2011. During 2011, Kim issued $20,000 of bonds payable in exchange for equipment.
|
|
Calculate ez maximum depreciation deduction
: The books of EZ Company, a calendar year taxpayer, had the following assets and related information as of December 31, 2011. EZ's policy is to record depreciation on December 31 by way of a journal entry.
|
|
Investment in the aircraft
: Management is having difficulty estimating the salvage value of the aircraft. To the nearest whole dollar how large would the salvage value of the aircraft have to be to make the investment in the aircraft financially attractive?
|
|
What adjusting entry should eager make to account for work
: It is now December 31, 2011, and Eager has provided legal services as planned. What adjusting entry should Eager make to account for the work performed from October 1 through December 31, 2011?
|
|
Develop a one year forecast
: Comment on the acceptability of the model's ability to pick up the systematic variation in your Fit period actual data and develop a one year forecast
|
|
What volume of n2o3 will be produced
: At a certain temperature and pressure 2.8 L of N2 reacts with 4.2 L of O2. If all the N2 and O2 are consumed, what volume of N2O3, at the same temperature and pressure, will be produced
|
|
What amount should be debited to the equipment account
: If similar equipment would cost $150,000 to replace and the partners agree on a valuation of $40,000 for the contributed equipment, what amount should be debited to the equipment account?
|
|
Finding volume of solid of revolution
: Using the washer method, find the volume of the solid generated when the region bounded by the curves y=(square root of)x and y=x^2 is revolved about the x-axis.
|
|
Word essay that examines a business issue has ethical issue
: Develop a 250 to 500 word essay that examines a business issue of your choosing that has ethical implications. For example, research the arguments (both for and against) advertising tobacco products to children. Present the leading opinions and comme..
|