- 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.
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.
| Month | Units | Formula (Corresponding Units) | |
|---|---|---|---|
| 11 | 33,100 | 32,618 | |
| 12 | 47,300 | 47,729 | |
| 13 | 69,000 | 69,841 | |
| 14 | 102,000 | 102,197 | |
| 15 | 150,000 | 149,542 | |
| 16 | 220,000 | 218,822 | |
| Month | Formula (Predicted Units) | Formula used in C2:C7 array above | |
| 17 | 320,197 | =GROWTH(B2:B7,A2:A7) | |
| 18 | 468,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
Return the smallest value in a data set with SMALL
Tabulate blank cells with COUNTBLANK
Determine frequency distributions with FREQUENCY
Other Links
Back to Excel Tutorial Homepage