Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • Create hyperlink with VLOOKUP in Excel
  • How to use Excel INDIRECT Function
  • Approximate match with multiple criteria in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples

Data Analysis Examples

  • How to sum a total in multiple Excel tables
  • Excel Bar Chart
  • Everything about Charts in Excel
  • How To Perform and Interpret Regression Analysis in Excel
  • Working With Tables in Excel

Data Validation Examples

  • Excel Data validation must not contain
  • Excel Data validation whole percentage only
  • Excel Data validation don’t exceed total
  • Prevent invalid data entering in specific cells
  • Excel Data validation require unique number

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:

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

Next Post:

F.TEST 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
  • Convert text to numbers using VALUE function in Excel
  • How to extract domain name from URL in Excel
  • Count Number of Words in Excel
  • Join Text Strings Using Concatenate or ‘& Operator’ in Excel
  • How to get first word in Excel
  • Count birthdays by month in Excel
  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • Assign points based on late time in Excel
  • Add days exclude certain days of week in Excel
  • How to calculate project start date based on end date in Excel
  • FV function: Description, Usage, Syntax, Examples and Explanation
  • XIRR function: Description, Usage, Syntax, Examples and Explanation
  • AMORDEGRC function: Description, Usage, Syntax, Examples and Explanation
  • Calculate cumulative loan interest in Excel
  • Calculate interest for given period in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles