LinkBack URL
About LinkBacks
Hi everyone!
I want to generate a matrix with two input variables (X;Y) which are automatically upscaled on the "edge" of the matrix. Example let's say X=$10 and Y=10% then the upper row of the matrix (X) will be automatically scaled by e.g. $10, $11, $12,... and the same for the collumn Y e.g. 10%, 11%, 12%. All based on the input data.
Now the challenge: How can I calculate the matrix values so e.g. 10$ x 10% ... $12 x 12% but automatically with a flexible layout so it will fit to the different size/ length of the X;Y "edge" (sometimes it will be $10-$20 and for the next input it could be $15-$50 so the size differs).
In the end I want to calculate the Standard Deviation out of all this data (maybe there is even a way to let Excel calculate the matrix without the need of showing the output somewhere? somebody knows a formula for that?).
Thank you for your help and time!
Best
Philipp
Register To Reply
Bookmarks