TREND
Returns values along a linear trend. Fits a straight line (using the method of least squares) to the arrays known_y's and known_x's. Returns the y-values along that line for the array of new_x's that you specify.
Syntax
TREND(known_y's,known_x's,new_x's,const)
Known_y's is the set of y-values you already know in the relationship y = mx + b.
If the array known_y's is in a single column, then each column of known_x's is interpreted as a separate variable.
If the array known_y's is in a single row, then each row of known_x's is interpreted as a separate variable.
Known_x's is an optional set of x-values that you may already know in the relationship y = mx + b.
The array known_x's can include one or more sets of variables. If only one variable is used, known_y's and known_x's can be ranges of any shape, as long as they have equal dimensions. If more than one variable is used, known_y's must be a vector (that is, a range with a height of one row or a width of one column).
If known_x's is omitted, it is assumed to be the array {1,2,3,...} that is the same size as known_y's.
New_x's are new x-values for which you want TREND to return corresponding y-values.
New_x's must include a column (or row) for each independent variable, just as known_x's does. So, if known_y's is in a single column, known_x's and new_x's must have the same number of columns. If known_y's is in a single row, known_x's and new_x's must have the same number of rows.
If you omit new_x's, it is assumed to be the same as known_x's.
If you omit both known_x's and new_x's, they are assumed to be the array {1,2,3,...} that is the same size as known_y's.
Const is a logical value specifying whether to force the constant b to equal 0.
If const is TRUE or omitted, b is calculated normally.
If const is FALSE, b is set equal to 0 (zero), and the m-values are adjusted so that y = mx.
Remarks
For information about how Microsoft Excel fits a line to data, see LINEST.
You can use TREND for polynomial curve fitting by regressing against the same variable raised to different powers. For example, suppose column A contains y-values and column B contains x-values. You can enter x^2 in column C, x^3 in column D, and so on, and then regress columns B through D against column A.
Formulas that return arrays must be entered as array formulas.
When entering an array constant for an argument such as known_x's, use commas to separate values in the same row and semicolons to separate rows.
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.
Calculates predicted exponential growth by using existing data. GROWTH returns the y-values for a series of new x-values that you specify by using existing x-values and y-values. You can also use the GROWTH worksheet function to fit an exponential curve to existing x-values and y-values.
Syntax
GROWTH(known_y's,known_x's,new_x's,const)
Known_y's is the set of y-values you already know in the relationship y = b*m^x.
If the array known_y's is in a single column, then each column of known_x's is interpreted as a separate variable.
If the array known_y's is in a single row, then each row of known_x's is interpreted as a separate variable.
If any of the numbers in known_y's is 0 or negative, GROWTH returns the #NUM! error value.
Known_x's is an optional set of x-values that you may already know in the relationship y = b*m^x.
The array known_x's can include one or more sets of variables. If only one variable is used, known_y's and known_x's can be ranges of any shape, as long as they have equal dimensions. If more than one variable is used, known_y's must be a vector (that is, a range with a height of one row or a width of one column).
If known_x's is omitted, it is assumed to be the array {1,2,3,...} that is the same size as known_y's.
New_x's are new x-values for which you want GROWTH to return corresponding y-values.
New_x's must include a column (or row) for each independent variable, just as known_x's does. So, if known_y's is in a single column, known_x's and new_x's must have the same number of columns. If known_y's is in a single row, known_x's and new_x's must have the same number of rows.
If new_x's is omitted, it is assumed to be the same as known_x's.
If both known_x's and new_x's are omitted, they are assumed to be the array {1,2,3,...} that is the same size as known_y's.
Const is a logical value specifying whether to force the constant b to equal 1.
If const is TRUE or omitted, b is calculated normally.
If const is FALSE, b is set equal to 1 and the m-values are adjusted so that y = m^x.
Remarks
Formulas that return arrays must be entered as array formulas after selecting the correct number of cells.
When entering an array constant for an argument such as known_x's, use commas to separate values in the same row and semicolons to separate rows.
(ex kupi-pest dari help-fungsi-excel)
kalau sudah tertulis 'gini kan gag males lagi 'kan...
2010/9/18 Tonny <tonnysuhardiman9@gmail.com>
> Dear Rekan Rekan
> Tolong Bantu dong menjelaskan fungsi dari Trend, Forecast, Dan Growth
> Thanks
> Tonce
| oppsss... thr-nya kok cepet banget ya habisnya.... T_____T |
| 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 |
+-------------------------------------------------------------------+
Nenhum comentário:
Postar um comentário