Prediction..?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kent J - 30 Sep 2007 11:14 GMT

Hi all,

I have a serie of values like:

Month    Value
1    100
2    200
3    300
4    400
5    500
6    600
7    700

If I would like to predict the value for month 12.
In Excel it's:
=PRECICT(predicted X;known y-values;known x-values) = 1200

How can I do the same in Access?

Kent J.

Reply to this Message

'69 Camaro - 30 Sep 2007 12:20 GMT

Hi, Kent.

> I have a serie of values like:
>
[quoted text clipped - 12 lines]
>
> How can I do the same in Access?

Access doesn't have the same built-in feature. However, Access is highly
customizable, so an Access developer can write custom VBA procedures to do
the task. In other words, you'll have to do the math.

Further, since what you've displayed is obviously calculated values, you
should be warned not to store those calculated values in a table, since they
can change. Store only the values needed to do the calculation, (i.e.,
SalesMonth and Rate). In addition, don't use Reserved words for
idenitifiers (names of tables, columns, queries, VBA procedures, variables,
et cetera), because it introduces bugs that are often hard to trace. Month
is a Reserved word.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

Reply to this Message