![]() ![]() stats (optional) is a Boolean value specifying whether to return additional regression statistics:.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 |