Friday, March 9, 2012

How to get predicion for monthly intervals?

hi,

I am using timeseries algorithm.I am training my model like the following

Date StudId Perf

5/1/2005 001 99

5/10/005 001 97.6

6/1/2005 001 94

6/10/2005 001 99

6/30/005 001 96

10/1/2005 001 100

Like that.

I need prediction Output like following

Date StudId Perf

10/1/2005 001 99

11/10/005 001 97.6

12/1/2005 001 94

1/10/2006 001 99

... how to write prediction query for this.

Thanks

Karthik.

have you tried a statement like below?

SELECT FLATTENED PredictTimeSeries(Perf) FROM Model?

I assume your model has Date as KEY TIME and StuId as KEY, right?

|||yes bodgan,you are right.|||So, does the query I suggested work correctly? Or are there different kind of results that you are looking for?|||

no bodgan,

the problem is the data.please look at the data, i am using to train and mt expected prediction result.I am expecting the prediction result so that the date values should be in a monthly interval.

Now I am getting results like this

Date StuId perf

10/1/2006 001 94

10/15/2006 001 99

11/10/2006 001 100

11/31/2006 001 75 Like that.

I need

Date StuId perf

10/1/2006 001 94

11/1/2006 001 99

12/1/2006 001 100

1/1/2007 001 75 Like that.

Thanks,

Karthik

|||

I see. With the specified input, you cannot get these results. The forecasting works by predicting the next N steps of the series. In order to get the results you want, your inputs should use 10/1/2006, 11/1/2006 and so on. A solution could be to average the values, per month, for each student ID. After that, as long as your input contains one entry (per student) per month, the prediction will result in one result per month per student

No comments:

Post a Comment