For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Statistical

GROWTH Function

Excel's GROWTH function fits an exponential curve to your data and returns the y-values along that curve for the array of new x values that you specify.


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

Syntax

GROWTH(known_y's, known_x's, new_x's, const)

  • known_y's  Required. The range or array of y values you already know in the relationship y = b*m^x. (From another perspective, a chart typically displays the same "y" values in the vertical axis.)  

  • known_x's  Optional. The range or array of x values you typically know in the relationship y = b*m^x. (From another perspective, "x" values are frequently date serial numbers, counters, or other numeric categories.) If known_x's is omitted, it is assumed to be the array {1,2,3,...} that is the same size as known_y's.

  • new_x's Optional. The new x-values for which you want GROWTH to return corresponding y-values.

    • New_x's must include a column (or row) for each independent variable, just as known_x's does. So, if known_y's is in a single column, known_x's and new_x's must have the same number of columns. If known_y's is in a single row, known_x's and new_x's must have the same number of rows.

    • If new_x's is omitted, it is assumed to be the same as known_x's.

    • If both known_x's and new_x's are omitted, they are assumed to be the array {1,2,3,...} that is the same size as known_y's.

  • const  Optional. A logical value that specifies whether to force the constant b to equal 1.

    • If const is TRUE or omitted, then b is calculated normally.

    • If const is FALSE, b is set equal to 1, and the m-values are fitted to y = m^x

Applies To

Excel 2003 and above

Examples

The following examples show the use of GROWTH only when the 'const' value is omitted. This is because it's likely that you'll never use the other setting.

Other ExcelUser Information

Other Help

 

Charley's SwipeFile charts


Free Excel Dashboards