Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Company sells devices which are capable of efficiently turning solar power into usable and efficient energy for consumers. They have provided the last five years
Company sells devices which are capable of efficiently turning solar power into usable and efficient energyfor consumers. They have provided the last five years of monthly sales figures and are looking to generate a forecasting technique which will project sales into the future with the minimum amount of error.
Note The first data point represents sales for the month of January in the first year.
1. Create a line plot to evaluate the properties of the monthly sales data. Provide a comment on the general properties of the sales data.
2. Create a 3-period moving average forecast (MA3).
3. Create an exponential forecast. Use a smoothing constant alpha = 0.2
4. Create a linear trend forecast.
5. Evaluate each of the forecasting techniques by comparing mean absolute error (MAE), the root- mean square error (RMSE), and the mean absolute percentage error (MAPE).
6. Provide a summary of your findings, to include anassessment of the best forecasting technique for this company.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started