Business Finance Homework Help

DS 604 SFSU Microsoft Corporation NasdaqGS Real Time Price Currency in USD Excel Task

 

Continuation of Assignment #1.

Using your time series data from Assignment #1, use an appropriate smoothing forecasting method to prepare forecasts and calculate the RMSE. Then prepare forecasts for three periods beyond your data set.

For example, if you have 30 data points, then you would prepare forecasts for periods 1 -30 (less any periods that require initialization), calculate RMSE using all periods for which you have a forecast and an actual, and then forecast out for periods 31, 32, and 33.

Turn in your spreadsheet to ilearn. If you worked with a partner, then one of you turn in the spreadsheet and the other person turn in a document with your partner’s name.