If const is FALSE, the parameter a is equal to 1, so the function will look like y = x b.If const is TRUE or omitted, the parameter a is calculated normally,.const (optional) is a Boolean value specifying whether to force the parameter a to equal 1:. ![]() In any case, you should provide the known_x's or array that has the same size as known_y's, These variables cannot be omitted for the correct calculation of a power trend. known_x's (optional) are independent data values:.known_y's (required) are dependent data values,.The array function LOGEST () calculates the power curve that fits best the known data and then returns an array with statistics describing the trend line: ![]() The array function LINEST () calculates the linear trend that fits best the known data and then returns an array with statistics describing the trend line:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |