AnsweredAssumed Answered

How to forecast future data based on historical data?

Question asked by danielle-gwa on May 21, 2013
Latest reply on May 21, 2013 by alainsainson

Dear forum

 

I have created a database of 'parts'. A separate table links to the parts table called 'usage'.

(for example, part number 1234 is in the 'parts' table.

It has 3 different usage points in the 'usage' table- 10 used on 01/01/2011, 18 used on 01/03/2012, 32 used on 01/01/2013)

 

I want to use this data to forecast usage in the future.

 

For example, how many will be used in 2014?

 

 

I know there is multiple ways to forcast based on trends- for example in Microsoft Excel there is linear, logarithnic, polynomial, power, exponential trend lines.

 

What forecasting is available in Filemaker Pro 11?

Can anyone help me with advice, good links to help me develop this, and or examples on forecasting used in filemaker pro 11??

 

This would be of great help to me.

 

Thank you

 

danielle-gwa

Outcomes