The standard error values for the coefficients m1,m2.,mn. The additional regression statistics are as follows. If stats is False or omitted, LinEst returns only the m-coefficients and the constant b. The m-values are coefficients corresponding to each x-value, and b is a constant value. + b (if there are multiple ranges of x-values), where the dependent y-value is a function of the independent x-values. The equation for the line is y = mx + b or y = m1x1 + m2x2 +. Stats - a logical value specifying whether to return additional regression statistics. Known_x's - an optional set of x-values that you may already know in the relationship y = mx + b.Ĭonst - a logical value specifying whether to force the constant b to equal 0. Known_y's - the set of y-values that you already know in the relationship y = mx + b. LinEst ( Arg1, Arg2, Arg3, Arg4)Įxpression A variable that represents a WorksheetFunction object. Because this function returns an array of values, it must be entered as an array formula. Calculates the statistics for a line by using the least squares method to calculate a straight line that best fits your data, and returns an array that describes the line.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |