(1) I am unable to replicate your results even just for the base case (equal weights for nodes and instruments). It appears that my original formulae have been retained, therefore it would be very helpful to see what caused the difference. Would you be able to share how you set the solver up?The first case used I11:I15 as the variable cells.
I am looking at variant 3, i.e. any one instrument retains the same weight across nodes (as this is a necessary condition), but each node may be assigned a different weighting.Correct.
Where exactly are the node weights specified? I do noticed you have a row (64) â€˜Node Weightâ€™, but these numbers are in the order of magnitude of millions? (for weighted least squares, my understanding is that the weights are specified in the format of 1/(y^2).They are specified in Row 64. This really has nothing to do with least squares, it's just a scaling that goes along with each node. Then these node weights are also "variables" in the Solver and are given a wide range (actually the same range as the other variables just because I didn't know any better).
If you are experiencing a similar issue, please ask a related question
Title | # Comments | Views | Activity |
---|---|---|---|
Excel Question | 17 | 15 | |
And OR formula | 5 | 22 | |
EXCEL formual to calculate Quarter | 6 | 37 | |
I would like a Macro that will remove the .jpg from a column of names and seperate a first last name. | 6 | 21 |
Join the community of 500,000 technology professionals and ask your questions.