Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to calculate correlation coefficient Correlation in Excel
  • Conditional Formatting Data bars Examples in Excel
  • Create Scatter Chart in Excel
  • How To Create Frequency Distribution in Excel
  • Excel Pie Chart

References

  • How to use Excel FORMULATEXT function
  • How to get address of first cell in range in Excel
  • Lookup entire row in Excel
  • How to use Excel TRANSPOSE Function
  • How to calculate two-way lookup VLOOKUP in Excel Table

Data Validations

  • Data validation must not exist in list
  • Excel Data validation must begin with
  • Excel Data validation unique values only
  • Excel Data validation exists in list
  • Excel Data validation whole percentage only

GROWTH function: Description, Usage, Syntax, Examples and Explanation

by

What is GROWTH function in Excel?

GROWTH function is one of Statistical functions in Microsoft Excel that calculates predicted exponential growth by using existing data. GROWTH returns the y-values for a series of new x-values that you specify by using existing x-values and y-values. You can also use the GROWTH worksheet function to fit an exponential curve to existing x-values and y-values.

Syntax of GROWTH function

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

The GROWTH function syntax has the following arguments:

  • Known_y’s    Required. The set of y-values you already know in the relationship y = b*m^x.
    • If the array known_y’s is in a single column, then each column of known_x’s is interpreted as a separate variable.
    • If the array known_y’s is in a single row, then each row of known_x’s is interpreted as a separate variable.
    • If any of the numbers in known_y’s is 0 or negative, GROWTH returns the #NUM! error value.
  • Known_x’s    Optional. An optional set of x-values that you may already know in the relationship y = b*m^x.
    • The array known_x’s can include one or more sets of variables. If only one variable is used, known_y’s and known_x’s can be ranges of any shape, as long as they have equal dimensions. If more than one variable is used, known_y’s must be a vector (that is, a range with a height of one row or a width of one column).
    • 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. Are 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 specifying whether to force the constant b to equal 1.
    • If const is TRUE or omitted, b is calculated normally.
    • If const is FALSE, b is set equal to 1 and the m-values are adjusted so that y = m^x.

GROWTH formula explanation

  • Formulas that return arrays must be entered as array formulas after selecting the correct number of cells.
  • When entering an array constant for an argument such as known_x’s, use commas to separate values in the same row and semicolons to separate rows.

Example of GROWTH function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

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)

Post navigation

Previous Post:

CUBEVALUE function: Description, Usage, Syntax, Examples and Explanation

Next Post:

AVERAGE function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • IF with boolean logic in Excel
  • Excel If, Nested If, And/Or Criteria Examples
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel NOT Function
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Convert Excel time to decimal hours in Excel
  • NOW function: Description, Usage, Syntax, Examples and Explanation
  • Get first Monday before any date in Excel
  • Get work hours between dates in Excel
  • Sum through n months in Excel

Grouping

  • Map text to numbers in Excel
  • Running count group by n size in Excel
  • Group times into 3 hour buckets in Excel
  • Categorize text with keywords in Excel
  • Group arbitrary text values in Excel

General

  • Cell References: Relative, Absolute and Mixed Referencing Examples
  • Index and match on multiple columns in Excel
  • Create dynamic workbook reference to another workbook in Excel
  • How to calculate percent variance in Excel
  • Zoom Worksheet in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning