MINVERSE

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.
 
P

Peo Sjoblom

Select a 3 x 3 array, in the formula bar type

=MINVERSE(A1:C3)


enter with ctrl + shift & enter

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

constructing array using non-adjacent columns 0
displaying results of minverse 1
Minverse 4
inverse of a matrix 4
Matrix Function Operations 2
MINVERSE errors 4
Arrays 3
Remove Duplicates From VLOOKUP Result 1

Top