![]() ![]() The more a plot of your data resembles an exponential curve, the better the calculated line will fit your data. If stats is FALSE or omitted, LOGEST returns only the m-coefficients and the constant b.įor more information about additional regression statistics, see the LINEST function. If known_x's is omitted, it is assumed to be the array. If more than one variable is used, known_y's must be a range of cells with a height of one row or a width of one column (which is also known as a vector). If only one variable is used, known_y's and known_x's can be ranges of any shape, as long as they have equal dimensions. ![]() The array known_x's can include one or more sets of variables. ![]() An optional set of x-values that you may already know in the relationship y = b*m^x. If the array known_y's is in a single row, then each row of known_x's is interpreted as a separate variable. If the array known_y's is in a single column, then each column of known_x's is interpreted as a separate variable. The set of y-values you already know in the relationship y = b*m^x. The LOGEST function syntax has the following arguments: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |