Re: How GROWTH interacts with LOGEST in an Excel?
In Excel 2003 and later versions of Excel, the message is conveyed not in an alert or a text string, but in the output table LOGEST. Growth has no mechanism to deliver that message to the user. In the results table LOGEST a regression coefficient is one, and whose standard error is zero, corresponding to a ratio of a column that was removed the model. LOGEST Results tables are included in rows 23 to 35 for the output growth of the rows 10 to 16. The entries in cells I24: I25 show a column eliminated redundant predictor. In this case, LOGEST decided to remove the column C (cells K24 coefficients I24, J24, correspond to columns C, B and Excel is constant column, respectively). When there is collinearity present, you can remove any of the columns involved and the choice is essentially arbitrary.
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