GROWTH Excel Function - How to Use of Growth Formula to Estimate Exponential Growth?

Показать описание

In this video on GROWTH Excel Function, here we discuss GROWTH Formula with example and how to use GROWTH in excel.

𝐆𝐑𝐎𝐖𝐓𝐇 𝐄𝐱𝐜𝐞𝐥 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧
----------------------------------------------

Exponential growth function in Excel is a statistical function that for a given set of data returns predictive exponential growth.

𝐆𝐑𝐎𝐖𝐓𝐇 𝐄𝐱𝐜𝐞𝐥 𝐅𝐨𝐫𝐦𝐮𝐥𝐚
-----------------------------------------------

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

𝐀𝐫𝐠𝐮𝐦𝐞𝐧𝐭𝐬
----------------------------

Known_y’s - Known_y’s is a set of y-values data set. It's an argument that is needed.

Known_x’s - Known_x’s is a set of x-values data set .The value of the range for known x should be the same as the values of known y.

New_x’s - Is the new x value for which we would like to calculate the corresponding predictive value.

Const - Const is also an optional argument that indicates whether the constant b for y = b * m^x equation is equal to 1.

𝐓𝐡𝐢𝐧𝐠𝐬 𝐭𝐨 𝐑𝐞𝐦𝐞𝐦𝐛𝐞𝐫 𝐰𝐡𝐢𝐥𝐞 𝐮𝐬𝐢𝐧𝐠 𝐆𝐑𝐎𝐖𝐓𝐇 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥
-----------------------------------------------------------------------------------------------------------

#1 - 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.

#2 - Excel's Growth function throws # NUM! Error if any known y array value is equal to or below zero.

#3 - Excel's growth function throws # VALUE! Error if any of the values of known y, known x or new x are not numeric.

Connect with us!