How to use the GROWTH Function?

bright countryside dawn daylight

  • Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel ,2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.

In this post, you will learn how to use the GROWTH function in Microsoft Excel. This includes a summary of its use, its formula syntax, important conditions to remember when using it, and also an example to test it for yourself.

Summary of the GROWTH Function

Calculates forecast exponential growth on the basis of current data. GROWTH returns the y-values for a series of new x-values that you confirm by employing present x-values and y-values. Also, you can deploy the GROWTH worksheet function to position an exponential curve to existing x-values and y-values.

Syntax

GROWTH(known_y’s, [known_x’s], [new_x’s], [const])

The GROWTH function syntax contains these specific arguments:

  • Known_y’s  –  Required. The set of y-values you are already aware of in the relationship y = b*m^x.
    • For when the array known_y’s is in a single column, then each column of known_x’s is deduced as a separate variable.
    • If the array known_y’s is in a single row, then each row of known_x’s is construed as a separate variable.
    • If any of the numbers in known_y’s is 0 or negative, GROWTH captures the #NUM! error value.
  • Known_x’s  –  Optional. An optional set of x-values that you might currently be familiar with in the relationship y = b*m^x.
    • The array known_x’s can have one or additional groups of variables. Should merely one variable is used, known_y’s and known_x’s can be ranges of any shape, provided they have similar dimensions. If multiple variables are employed, known_y’s have to be a vector (that is, a range with a height of one row or a width of one column).
    • If known_x’s is missed out altogether, it is presumed to be the array {1,2,3,…} that is the exact size as known_y’s.
  • New_x’s  –  Optional. Are new x-values for your preferred use of GROWTH to yield matching y-values.
    • New_x’s are required to contain a column (or row) for each separate variable, like as known_x’s does. So, if known_y’s is in a single column, known_x’s and new_x’s are mandated to include the same number of columns. When known_y’s is in a single row, known_x’s and new_x’s must occupy the equal number of rows.
    • Whenever new_x’s is skipped, it is interpreted to be the same as known_x’s.
    • If both known_x’s and new_x’s are skipped, they are automatically deemed to be the array {1,2,3,…} that is the same size as known_y’s.
  • Const  –  Optional. A logical value dictating whether to force the constant b to equal 1.
    • If const is TRUE or ignored, b is calculated as usual.
    • If const is FALSE, b is set equal to 1 and the m-values are modified to ensure that y = m^x.
Growth of a plant and money.
Image by Nattanan Kanchanaprat from Pixabay.

Remarks of the GROWTH Function

  • Formulas that yield arrays have to be typed as array formulas once you have chosen the right number of cells.
  • Whilst inputting an array constant for an argument like known_x’s, enter commas to divide values in the same row and semicolons to split rows.

GROWTH Function Example

Copy the sample data in the table below, and paste it into cell A1 of a brand new Excel worksheet. For formulas to display results, pick them, press F2, and then press Enter. If you must at any point, you can amend the column widths to gain a full view of the entire dataset.

MonthUnitsFormula (Corresponding Units)
1133,10032,618
1247,30047,729
1369,00069,841
14102,000102,197
15150,000149,542
16220,000218,822
MonthFormula (Predicted Units)Formula used in C2:C7 array above
17320,197=GROWTH(B2:B7,A2:A7)
18468,536
Formula used in B9:B10 array above
=GROWTH(B2:B7,A2:A7,A9:A10)

Other Statistical Functions Topics

Find the middle value with MEDIAN

Rank data without sorting with RANK

LARGE Function

Return the smallest value in a data set with SMALL

Tabulate blank cells with COUNTBLANK 

Determine frequency distributions with FREQUENCY 

All statistical functions

Other Links

Back to Excel Tutorial Homepage

Software Bytes – Homepage

Leave a Reply

%d bloggers like this: