Supun Chamara
Supun Chamara

Reputation: 1

How to Get the Monthly Sales Prediction for next year using the sales history records of past 5 years?

I need to develop a system where user can analyse the past sales records and can predict monthly sales for next year. There I am using simple linear regression and get the past monthly sales records of past 5 years and create a line chart.

 X= month 
 y= sales

e.g. I get the sales of month January for 5 years and get the average and plot the graph for 12 months. So how could I give user to predict for monthly sales for next year based on the graph of linear regression equation?

Also I would like to know whether my approach is correct? or are there any efficient ways to do that?

thanks

Upvotes: 0

Views: 1223

Answers (1)

welch
welch

Reputation: 964

Welcome to forecasting. Your question doesn't quite belong here (as MBaas points out, stackoverflow is about teh codez), but while you are here you might as well get started with an excellent book, free and online, Rob Hyndman's Forecasting: principles and practice.

https://www.otexts.org/fpp

Once you have a code-related forecasting question, stackoverflow is the place for it! Hyndman even answers an occasional question here.

Upvotes: 1

Related Questions