Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Generalised version of LINEST using QR Decomposition
Does anyone know if a generalised version of the Excel 2003 LINEST function
using QR decomposition is available, beyond that posted in the knowledge base article(http://support.microsoft.com/kb/828533)? That shows the way in which this can be done with 2 regressors but not for n regressors and I need to know how this can be extended. Ideally, I think this should be available as a free bug fix in Excel, as Microsoft has acknowledged that this is a bug. Also, the Knowledge Base article doesn't show how the standard error of each coefficient can be determined, hence it's impossible to derive the t-stats for each coefficient. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
How to use later version Excel file in 4.0a? | Excel Discussion (Misc queries) | |||
How can I update the version of Excel 2000 9.0 to version 10.0 | Excel Discussion (Misc queries) | |||
How to use linest with variably sized data arrays? | Excel Worksheet Functions | |||
LINEST bug with cubic polynomials in Excel 2003 | Excel Worksheet Functions |