Posted: December 14th, 2021

Forecasting assignments | Statistics homework help

Assignment must be done using Excel – Please use automatic formulas so teacher can see the work and any linear graphs to show work.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

There are three excel files that corresponding to the book page 353.

1. Forecasting models with stationary Time series #8 and #9 in page 353:

        1.1: Closing stock prices: using moving average (AP=2 and 3) for each of the stocks and choose one of the two AP = 2 or 3;

        1.2: Closing stock prices: using simple exponential smoothing method (with alpha = 0.1 to 0.5) for each of the stocks and choose the best alpha for each stock;

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

2. Forecasting models with a linear trend for Time series #12 and #14

        2.1: Consumer Price Index: using double exponential smoothing method (with alpha = 0.1 to 0.9, beta = 0.1 to 0.9 ) and choose the best alpha and beta for the next year;

        2.2: Consumer Price Index: using Linear regression method to forecast for the next two years;

3. Forecasting Time Series with seasonality (Optional #24 on Page 353)

        3.1: CD Interest Rates: Using Holt-Winters additive seasonality model for a season of 6 years;

        3.2: CD Interest Rates: Using Holt-Winters multiplicative seasonality model for a season of 6 years;  

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Open chat
1
Order through WhatsApp!
affordablepaperwritings.com
Hello!
You Can Now Place your Order through WhatsApp

Order your essay today and save 30% with the discount code DISCOUNTS2022