Growth Function in Excel
The exponential growth function in Excel is a Statistical Function that returns the predictive exponential growth for a given set of data. For a given new value of x, it returns the predicted value of y. Growth formula in Excel helps in financial and statistical analysis; it helps to predict revenue targets, sales. It is also used in regression analysis in excel, wherever the growth is calculated exponentially. This function fits an exponential curve to the data and returns the dependent value of y for the new value of x specified.
GROWTH Formula in Excel
Below is the GROWTH Formula in Excel
Exponential Growth Curve
For GROWTH Formula in Excel, y =b* m^x represents an exponential curve where the value of y depends upon the value x, m is the base with exponent x, and b is a constant value.
For a given relation y =b*m^x
Known_y’s: is a set of y-values in the data set. It is a required argument.
Known_x’s: is a set of x-values in the data set. The range value for known_x’s should be the same as known_y’s values. It is an optional argument. 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: is the new value of x for which we want to calculate the predictive corresponding value. If we omit this value, the new value of x the function that the value as the same value of known x’s and based on that value, it returns the value of y. New_x’s must include a column (or row) for each independent variable, just as known_x’s does. 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: is also an optional argument that tells whether the constant b for equation y= b* m^x be equal to 1. It the constant value is true or is omitted. The value of b is calculated normally, else if the constant value is false, and the value of b is set equal to 1, and the values of m are adjusted such that we have the relation y = m^x.
The Exponential growth formulaExponential Growth FormulaExponential Growth refers to the increase due to compounding of the data over time and follows a curve representing an exponential function. Exponential growth formula: Final value = Initial value * (1 + Annual Growth Rate/No of Compounding ) No. of years * No. of compounding is very helpful to calculate the estimated growth when growth occurs exponentially, for example, in biology, where a microorganism increases exponentially. The human population also grows exponentially. The stock prices and other financial figures may follow the exponential growth, so in these scenarios, one can use the Exponential growth function to depict the estimated growth.
How to Use GROWTH Function in Excel?
GROWTH in excel is very simple and easy to use. Let us understand the working of GROWTH in excel by some examples.
GROWTH in Excel Example #1
We have a given data sample with given values of X and Y, and we want to calculate the Growth using the Growth formula in Excel.
So, the GROWTH formula in Excel that we will use is
GROWTH in Excel Example #2
Suppose there a company that has revenue for the previous ten years. Column A has the years mentioned, and column B contains the revenue for each given year. We want to calculate the revenue for the upcoming year. Based on the previously given data, we want to calculate the estimated revenue for the year 2019.
To predict the revenue for the year 2019, we will be using the GROWTH formula in excel. In this case, the new X value is the upcoming year, which is 2019
The GROWTH Formula in Excel that we will be using will be
So, in the year 2019, the company most probably will generate revenue of around $291181.03
GROWTH in Excel Example #3
Suppose in a lab; we have an organic solution that contains bacteria that are growing exponentially in the solution. They are increasing with the increase of time given in seconds. We have the sample data for a number of bacteria with given time periods in seconds. We need to estimate the bacteria growth after 150 seconds.
Column A contains the time values in seconds, and column B contains the number of bacteria that are multiplying exponentially.
In order to estimate the increase or growth in the product over a certain period of time, we will be using the Exponential GROWTH function.
We will select the range of known y values, which is a number of bacteria growing with time, and known x values, which is the time period given in seconds, and the new x values are 150 seconds for which we need to calculate the estimated increase in the number of bacteria.
The GROWTH formula in Excel that we will be using is:
The total estimated number of bacteria in the solution after 150 seconds will be approximately 393436223.
Things to Remember About GROWTH Function in Excel
- We can use the Exponential Growth function as an array when more than one new value of y is computed. In that case, the function is entered as an array formula by using the Crtl+ Shift+ Enter
- The Growth function in Excel throws #REF! error when the known_x’s array doesn’t have the same length equal to known_y’s array.
- The Growth function in Excel throws #NUM! error if any value of known_y’s array is less than or equal to zero.
- The Growth function in Excel throws #VALUEExcel Throws #VALUE#VALUE! Error in Excel represents that the reference cell the user has either entered an incorrect formula or used a wrong data type (mostly numerical data). Sometimes, it is difficult to identify the kind of mistake behind this error.! error if any of known_y’s, known_x’s, or new x value is not numeric.
- While using the Exponential Growth function in graphs, we can often use the exponential option from the graph trend line option.
GROWTH Excel Function Video
This has been a guide to GROWTH Function in Excel. Here we discuss the GROWTH Formula and how to use GROWTH in excel along with excel example and downloadable excel templates. You may also look at these useful functions in excel –