Re: value prediction
Date: Tue, 17 Feb 2009 21:41:37 +0100
"Charles Hooper" <hooperc2000_at_yahoo.com> wrote in message
On Feb 17, 2:59 pm, "Matthias Hoys" <a..._at_spam.com> wrote:
> I'm using Oracle 10g.
> Are there any analytic/statistic functions in Oracle to predict future
> values based on existing historical data ?
> For example: I have a table with product sales of the last 5 years, can we
> make an estimation of the sales for the next year ?
My mathematics are quite rusty, but I seem to recall something about doing the above in a class called Linear Algebra. Check this page: http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/analysis.htm#BCFHHEHC
Linear regression is the answer?
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
I'll check it out. Received on Tue Feb 17 2009 - 14:41:37 CST