S
Steve G
I am having problems displaying the results of the data
analysis function ({MINVERSE}) which returns the inverse
matrix for a matrix stored in an array.
I followed the first example contained in MINVERSE / help:
MINVERSE({4,-1;2,0})which equals {0,0.5;-1,2}...GOOD, but
when a larger 3x3 array is used I cannot see all the
inverse matrix results.
E.G.2. ({1,2,1;3,4,-1;0,2,0}) equals{0.25,0.25,-
0.75;0,0,0.5;0.75,-0.25,-0.25}).
What happens is , I punch in the array inncells A1...C3,
select outside the array (F6), select MINVERSE from the
data analysis tools and get the grey MINVERSE analysis
box. I then select the array, and are only shown some of
the inverse matrix results (up to 0.75 in the grey box)
before I click okay and get the formula result printed in
F6.
The analysis is working properly but I also need to output
the individual inverted cell results (0.25,0.25,-
0.75;0,0,0.5;0.75,-0.25,-0.25)to the worksheet. Currently
only the formula result is outputted to the worksheet.
I note that other data analysis tools ask where you would
like the results outputted to but MINVERSE doesn't. It
only outputs the formula result.
So my question is .. How do I get the MINVERSE function to
output the formula result and the individual inverted cell
results to the main worksheet.
analysis function ({MINVERSE}) which returns the inverse
matrix for a matrix stored in an array.
I followed the first example contained in MINVERSE / help:
MINVERSE({4,-1;2,0})which equals {0,0.5;-1,2}...GOOD, but
when a larger 3x3 array is used I cannot see all the
inverse matrix results.
E.G.2. ({1,2,1;3,4,-1;0,2,0}) equals{0.25,0.25,-
0.75;0,0,0.5;0.75,-0.25,-0.25}).
What happens is , I punch in the array inncells A1...C3,
select outside the array (F6), select MINVERSE from the
data analysis tools and get the grey MINVERSE analysis
box. I then select the array, and are only shown some of
the inverse matrix results (up to 0.75 in the grey box)
before I click okay and get the formula result printed in
F6.
The analysis is working properly but I also need to output
the individual inverted cell results (0.25,0.25,-
0.75;0,0,0.5;0.75,-0.25,-0.25)to the worksheet. Currently
only the formula result is outputted to the worksheet.
I note that other data analysis tools ask where you would
like the results outputted to but MINVERSE doesn't. It
only outputs the formula result.
So my question is .. How do I get the MINVERSE function to
output the formula result and the individual inverted cell
results to the main worksheet.