Can I raise a matrix to a power?
"dled" skrev i en meddelelse
...
I have a couple of 40x 40 matrices, that I would like to raise to various
powers. Can this be done, short of using the mmult function and
multipling
each matrix by itself over and over?
If your matrix cover cells e.g. A1:AN40,
select a 40x40 range and enter the formula
=A1:AN40^3 (while the range is selected)
Confirm with <Shift<Ctrl<Enter
You now have your matrix raised to the third power.
--
Best regards
Leo Heuser
Followup to newsgroup only please.
|