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

Опубликовано: 28 Сентябрь 2024
на канале: WallStreetMojo

39,802

125

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.

To know more about 𝐆𝐑𝐎𝐖𝐓𝐇 𝐄𝐱𝐜𝐞𝐥 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧, you can go to this 𝐥𝐢𝐧𝐤 𝐡𝐞𝐫𝐞:- https://www.wallstreetmojo.com/growth...

Connect with us!
Youtube ►    / @wallstreetmojo
LinkedIn ►   / mycompany
Facebook ►   / wallstreetmojo
Instagram ►   / wallstreetmojoofficial
Twitter ►   / wallstreetmojo