Excel Function : LOGEST

Download now!

Excel Function : LOGEST

Category

Statistical

Description

Returns the parameters of an exponential trend

Microsoft Excel Reference Page

https://support.office.com/en-us/article/LOGEST-function-f27462d8-3657-4030-866b-a272c1d18b4b

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.