Excel Function : LOGEST
Returns the parameters of an exponential trend
Microsoft Excel Reference Page
Syntax and Description of the LOGEST Excel Function
According to Microsoft, the syntax for the LOGEST function is as follows: LOGEST(known_y’s, known_x’s, const, stats) Where: known_y’s – The set of y-values for which you want to predict y-values. known_x’s – The set of x-values that you already know in relation to the known_y’s const – A logical value that specifies whether to force the constant b to 0. stats – A logical value that specifies whether to return additional regression statistics.
About LOGEST Excel Function
LOGEST is an Excel function used to calculate an exponential curve that best fits your data, and returns an array of coefficients that describe the curve. The function can be used to predict future values, based on the values you already have.