LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Will
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Recover earlier version of excel sheet after new version saved? stephanie38 Excel Discussion (Misc queries) 3 June 17th 05 03:52 AM
How to use later version Excel file in 4.0a? ajimmo Excel Discussion (Misc queries) 1 May 30th 05 10:26 AM
How can I update the version of Excel 2000 9.0 to version 10.0 Ramsey Can Excel Discussion (Misc queries) 1 May 11th 05 03:28 PM
How to use linest with variably sized data arrays? [email protected] Excel Worksheet Functions 0 April 13th 05 04:56 PM
LINEST bug with cubic polynomials in Excel 2003 byundt Excel Worksheet Functions 3 March 21st 05 02:15 PM


All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"