BookmarkSubscribeRSS Feed
jctran123
Calcite | Level 5

Hi SAS Community, 

 

I am working on a sales forecasting project with about 20 different products. Some products have very high MAPEs and I would like to lower the MAPE as much as I can. I created a custom model and was able to lower some of the MAPEs by performing a BOX COX transformation with a parameter of -5, but I am not sure whether that is statistically correct. Does anyone have any tips on how I can work towards a better forecast?

 

Jessica

1 REPLY 1
alexchien
Pyrite | Level 9

Hi Jessica,

There are a few things you can look into:

1. As long as the data is good, any model can produce fair forecasts. What do i mean by data is good? There could be outliers that would bais the model or there are additional input variables required to capture variations not explained by the time selrs itself.

2. You should look at both in-sample and out-of-sample forecast error measures. You might get lucky to find a model that fits well with data but perform poorly for future forecast. 

3. Consider combination models. Try a bouch of different types of models and ensemble them. The combo model typically out-perform a single model for futurte forecasts

4. You could also try using machine learning models such as neural net and tree models for forecasting if you have license to STAT or EM.

5. keep your model simple and intuitive!!

6. break time reading - https://www.otexts.org/book/fpp   a very good online book for forecasting in general

 

boxcox with lambda = -5 seems extreme. I have no idea why this particular transformation works for you. Please try to holdback the data to see if the model actully performs well for the totally unseen data. 

 

tough question 😆

Alex

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 602 views
  • 0 likes
  • 2 in conversation