Re: How LOGEST interacts with LINEST in Excel?
Problems have to be collinear in known_x LOGEST or LINEST in Microsoft Excel 2002 and in earlier versions of Excel. Predictor columns, the known_x are collinear if at least one column, c, can be expressed as a sum of many other users (c1, it and other values). Column C is called redundant because it contains information that can be built on columns (c1, it and other values). The fundamental principle in the presence of collinearity is that results should not be affected by whether a redundant column is included in the original data or removed from the original data. For the version LINEST in Microsoft Excel 2002 and in earlier versions of Excel do not search for collinearity, this principle was easily violated.
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