Manuals/calci/LOGEST
Jump to navigation
Jump to search
LOGEST(Y, X,C,stats)
Where Y is the set of y-values and X is an optional set of x-values in the relationship y = b*m^x.
C is a logical value specifying whether to force the constant b to equal 1 and stats are a logical value specifying whether to return additional regression statistics.This function calculate an exponential curve that fits your data and returns an array of values that describes the curve.
· If you have only one independent x-variable, then you can obtain the y-intercept (b) values directly by using the following formula:
Y-intercept (b):
INDEX(LOGEST(Y, X),2)
· Use y = b*m^x equation is to predict future values of y
LOGEST
Lets see an example,
LOGEST(Y,X,C,Stats)
B C
11 32000
12 47300
13 70000
14 105000
15 120000
16 230000
LOGEST(C2:C7,B2;B7,TRUE,FALSE) is
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 11 | 32000 | ||
| Row2 | 12 | 47300 | ||
| Row3 | 13 | 70000 | ||
| Row4 | 14 | 105000 | ||
| Row5 | 15 | 120000 | ||
| Row6 | 16 | 230000 |
