Рет қаралды 39,514
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 𝐥𝐢𝐧𝐤 𝐡𝐞𝐫𝐞:- www.wallstreet...
Connect with us!
KZbin ► / @wallstreetmojo
LinkedIn ► / mycompany
Facebook ► / wallstreetmojo
Instagram ► / wallstreetmojoofficial
Twitter ► / wallstreetmojo