Question

Quarterly sales growth for Netflix is in the following data set (link): Netflix_growth_pct.xlsx a). Use Excel to create a time plot of the Growth Percentage variable. Make sure the chart is easy to read, professional looking, and has a meaningful title, using the context of the problem as a guide. Do NOT title it anything like "Homework Problem." Make your chart as if it were for your job, not a class. b). Explain what time series features (trend, season, cycle) you see. c). Produce forecasts for the next year using the methods below. Because this is quarterly data, you will make four forecasts, one for each quarter of the next year. i). Weighted moving average of order k (that is, a k-period weighted moving average). Pick a value of k that makes sense to you and use Excel's Solver to find the best weights, as shown in the video and PowerPoint. You must use a k > 1 (that is, k must be two or more); otherwise you're just using Naive 1, and where's the fun in that? ii). Simple exponential smoothing. Use Excel's Solver or the Real Statistics add-in to find the best value of the smoothing parameter. iii). A Holt forecast. Use Excel's Solver or the Real Statistics add-in to find the best values of the level and trend parameters. iv). A Holt-Winters forecast. Use Excel's Solver or the Real Statistics add-in to find the best values of the level, trend, and seasonal parameters.

          Quarterly sales growth for Netflix is in the following data set (link): Netflix_growth_pct.xlsx
a). Use Excel to create a time plot of the Growth Percentage variable. Make sure the chart is easy to read, professional looking, and has a meaningful title, using the context of the problem as a guide. Do NOT title it anything like "Homework Problem." Make your chart as if it were for your job, not a class.
b). Explain what time series features (trend, season, cycle) you see.
c). Produce forecasts for the next year using the methods below. Because this is quarterly data, you will make four forecasts, one for each quarter of the next year.
i). Weighted moving average of order k (that is, a k-period weighted moving average). Pick a value of k that makes sense to you and use Excel's Solver to find the best weights, as shown in the video and PowerPoint. You must use a k > 1 (that is, k must be two or more); otherwise you're just using Naive 1, and where's the fun in that?
ii). Simple exponential smoothing. Use Excel's Solver or the Real Statistics add-in to find the best value of the smoothing parameter.
iii). A Holt forecast. Use Excel's Solver or the Real Statistics add-in to find the best values of the level and trend parameters.
iv). A Holt-Winters forecast. Use Excel's Solver or the Real Statistics add-in to find the best values of the level, trend, and seasonal parameters.

Quarterly sales growth for Netflix is in the following data set (link): Netflixgrowthpct.xlsx
a). Use Excel to create a time plot of the Growth Percentage variable. Make sure the chart is easy to read, professional looking, and has a meaningful title, using the context of the problem as a guide. Do NOT title it anything like "Homework Problem." Make your chart as if it were for your job, not a class.
b). Explain what time series features (trend, season, cycle) you see.
c). Produce forecasts for the next year using the methods below. Because this is quarterly data, you will make four forecasts, one for each quarter of the next year.
i). Weighted moving average of order k (that is, a k-period weighted moving average). Pick a value of k that makes sense to you and use Excel's Solver to find the best weights, as shown in the video and PowerPoint. You must use a k > 1 (that is, k must be two or more); otherwise you're just using Naive 1, and where's the fun in that?
ii). Simple exponential smoothing. Use Excel's Solver or the Real Statistics add-in to find the best value of the smoothing parameter.
iii). A Holt forecast. Use Excel's Solver or the Real Statistics add-in to find the best values of the level and trend parameters.
iv). A Holt-Winters forecast. Use Excel's Solver or the Real Statistics add-in to find the best values of the level, trend, and seasonal parameters.

Added by Michelle S.

Question

Please give Ace some feedback