Re: value prediction
From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: Tue, 17 Feb 2009 12:07:15 -0800 (PST)
Message-ID: <c401cc16-1b71-48b3-a4b7-3d86abf77c0e_at_40g2000prx.googlegroups.com>
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 ?
>
> Thanks,
> Matthias
Date: Tue, 17 Feb 2009 12:07:15 -0800 (PST)
Message-ID: <c401cc16-1b71-48b3-a4b7-3d86abf77c0e_at_40g2000prx.googlegroups.com>
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 ?
>
> Thanks,
> Matthias
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?
Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
Received on Tue Feb 17 2009 - 14:07:15 CST