Re: What is Excel statistical function : GROWTH?
Assuming there are p predictor variables, essentially calls growth LOGEST. LOGEST. LOGEST. LOGEST fits an equation of the form :
Code:
y = b * (m1^x1) * (m2^x2) * ... * (mp^xp)
The values of the coefficients, b, m1, m2 ,..., mp are determined that give the best fit to the data y. If the last argument "constant" is set to TRUE, you want the regression model to include the multiplication coefficient b in the regression model. If set to FALSE, b is essentially excludes set to 1. The last argument is optional if you omit the argument is interpreted as TRUE.
QTechnology Ultra-Quiet ATX PSU 460W I MSI K8N Neo4-F I AMD Opteron 144 CABNE0545 2.66Ghz I 2 x 512MB RAM I 380GB Maxtor SATAI Raid0 Hard Drive I 40GB Maxtor IDE Hard Drive I Nvidia GeForce 7900GTX I Win XP Home Service Pack 2 I Soundblaster Xtreme Fidelity Fatal1ty I Mercury Home Theater HT-4500
Bookmarks