** Syntax**. LOGEST(

** Definition**. This function calculates the exponential curve in regression analyses and returns a value array describing this curve. Because this function returns an array of values, it must be entered as an array formula.

**Arguments**

. The y-values you already know from the relationship*known_y’s*(required)*y*=*b***m*^{x}If the

*known_y’s*array consists of a single column, then each column in the*known_x’s*array is interpreted as a separate variable.If the

*known_y’s*array consists of a single row, then each row in the*known_x’s*array is interpreted as a separate variable.

. The x-values you already know from the relationship*known_x’s*(optional)*y*=*b***m*^{x}The

*known_x’s*array can include one or more sets ...

Start Free Trial

No credit card required