- could you pls elaborate the comment you added to Case D of your last spreadsheet:
Case D appears to show that there is only two degrees of freedom because there are only three maximum errors that are equal. With 5 variables there would be 6 of them.
- you tried to tackle the problem via a variance-covariance matrix...would you possibly have any further insights into this approach (I do not necessarily need to use LSq; it was the one approach I was reasonably familiar with but I am happy to try out other optimization approaches)This seems appropriate for the "noisy data" case where the matrix is the noisy data. Wikipedia treats this case pretty well at:
- Regarding the idea of optimizing the (node) weights): I am not per se against this (apologies if it came across as such), I just have problems understanding the practical implications of adjusting the node weights...if I can translate this into an improved hedge portfolio I am fully for it. Would you have an example of using the variance-rules to guide the specification of the weights?See: https://www.google.com/url
- In the spreadsheet attached to your poste on the 28Oct (LeastSquares-Matrices) you calculate the least squares solution directly...would there be any benefits/advantages over the solver-generated solution?Perhaps. I rather like the Solver and I'd guess it's a lot easier to set up. But, if compute time is critical then you could try both and see.
Title | # Comments | Views | Activity |
---|---|---|---|
SQL INSERT error - Excel VBA/ADO/Access 2016 | 2 | 23 | |
Excel VBA - format a Shape same as a Cell | 7 | 22 | |
userform submit button saving document, but not imputting data into worksheets | 12 | 25 | |
Manipulate Data Quickly | 2 | 13 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
8 Experts available now in Live!