![]() ![]() Regression sum of squares (also known as SSR) Standard error of y estimate (also known as Standard Error of a regression) shows how big the prediction error is ![]() If stats is TRUE, the function returns the additional regression statistics in the form of an array:.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 |