FORECAST

Calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. The known values are existing x-values and y-values, and the new value is predicted by using linear regression. You can use this function to predict future sales, inventory requirements, or consumer trends.

Syntax

FORECAST(x,known_y's,known_x's)

X is the data point for which you want to predict a value.

Known_y's is the dependent array or range of data.

Known_x's is the independent array or range of data.

Remarks

If x is nonnumeric, FORECAST returns the #VALUE! error value.
If known_y's and known_x's are empty or contain a different number of data points, FORECAST returns the #N/A error value.
If the variance of known_x's equals zero, then FORECAST returns the #DIV/0! error value.
The equation for FORECAST is a+bx, where:

and:

and where x and y are the sample means AVERAGE(known_x's) and AVERAGE(known y's).

-zam-

-----Original Message-----
From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf Of rina_fam
Sent: Friday, September 04, 2009 3:37 PM
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ Forecast penjualan

Halo, Salam kenal..

Saya mau memforcast penjualan kue saya kedepan jadi berapa ?
Ada yang bisa bantu rumusnya ngak ?

Mis...
2006 : 500 roti
2007 : 1000 roti
2008 : 1200 roti
2009 : ?
2010 : ?
2011 : ?

dan

jan : 30
feb : 10
mar : 50
apr : 55
Mei : 52
berapa tuk bulan jun, juli dan agustus...

Terimakasih ya...

__._,_.___

Messages in this topic (2) Reply (via web post) | Start a new topic

Messages

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Papa ga pulang beibeh... Papa ga bawa uang beibeh...              |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+