Free Microsoft Excel 2013 Quick Reference

# matrix symbolic algebra in excel

Hi there, I am just wondering if excel can do matrix symbolic algebra ? and how ?

I have many matrices i need to multiply to each other and they get really2 messy when i did it manually

thank you

## Related Results

### Using Macros to Calculate Matrix Algebra in Excel..... I'm STUMPED

Hello!
Here is a link to a file with my situation:

http://www.savefile.com/files/8301241

I need to find a way to set up a spreadsheet where I can input the variables
G, H, W, J, Q, S and have excel calculate the possible answers that satisfy
all of the equations in column D.

I know to do this on paper you use matrix algebra but I have no clue how to
do this in excel.

Column B is the results I should be getting for each variable in column A
(with the input values in column F) but I can't get it to work in excel.
Column C is a quick attempt I made to use iterate and circular references but
to no avail. If anyone can point me in the right direction I would REALLY
appreciate it. Oh and column A is a list of all variables used in the
equations in column D.

Is it even possible to input values for the variables in column E and have
excel use those to find answers that satisfy all of the equations in column
D??

### Matrix to table in excel 2007

Hi.
I have a matrix with 100 customers in rows and manufacturers in about 100 columns and quantities in the middle.

eksample:

man 1 man 2 man 3
customer a qty qty qty
customer b qty qty qty
customer c qty qty qty

I would like to transform this data input into a table with columns: Customer, Manufacturer, Quantity.

It used to be a PT solution to this with "multiple ranges" in excel 2003 but
i cant find it in 2007!

### What does the symbol ^ mean in Excel formulas?

I am having trouble finding out the purpose of the symbol ^ when using
calculations in Excel. Can anyone help me?

hash (#).

So when I press: 'SHIFT' and '3' I am supposed to get '£' but instead I
get '#'.

Some other keys dont work although most of the other Shift functions do
what their supposed to e.g. I can still do a dollar sign (\$), percentage
sign (%) etc. All keys work fine in other apps eg. notepad. Keyboard
setting is still the set to UK format.

Any ideas?

--
paperclip
------------------------------------------------------------------------
paperclip's Profile: http://www.excelforum.com/member.php...o&userid=32219

I cant make a (£) pound symbol/sign in excel, instead all I get is a hash (#).

So when I press: 'SHIFT' and '3' I am supposed to get '£' but instead I get '#'.

Some other keys dont work although most of the other Shift functions do what their supposed to e.g. I can still do a dollar sign (\$), percentage sign (%) etc. All keys work fine in other apps eg. notepad. Keyboard setting is still the set to UK format.

Any ideas?

### How do I add a stock symbol smart tag in Excel?

For example, GE and other stock symbols are NOT recognized by the Excel smart
tags. How do I add these so they are recognized with smart tags in Excel?

Thank you

### Include statistics symbols in Excel, e.g. y-hat, bar x, etc.

Excel is used extensively for statistical work, but does not support
specialized statistical characters. For example, the sample mean is usually
written as 'x' with a bar over it, or x-bar. The equation to approximate
regression is referred to as y-hat, the letter y with a caret (^) on top.
I believe inclusion of all of the specialized statistical symbols in the
character set would add in the presentation of statistical analysis done in
Excel.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

### How do I use the (=) symbol for cut/pasting in excel?

What is the technical term for using the (=) symbol in excel for cutting and
pasting. Are there any links to sites with this information?

### How do i write a Algebra formula in excel sheet

i want to type Algebra formula in excel sheet, e.g 1) Aa root of 2) Aa * Bb

when you writing 4th, automitically th wil go in to small word, like that
even the root sq. formula needs to come

can some one give tips on this

saravanan

### How can i build up a Matrix in EXCEl ?

Hello i need urgently help:

how can i build a Matrix in Excel combining 250 items (ex. airports) with
250 items (ex. airports)?

i schould create a row with the 62500 possible combinations... there must be
a formula to make this autmatically.

ex. ZHR JFK ATL ....
ZHR
JFK
ATL
.....
And then I should get a list in one row :

ZHR-JFK
ZHR-ATL
......
JFL-ZHR
JFK-ATL
.....
ATL-ZHR
ATL-JFK

thank you very much for your help.

regards

Mischa

### Inserting symbols not available in excel

Hi there,

I want to insert some symbols in excel and I cannot find the correct ones,
these symbols are the washing instruction symbols we have in all our clothing.
I have found some of them in the "TextilePiEF" font in the symbols menu, but
not all of the ones I need. So i wanted to know whether:
1) I could modify some of the symbols in "TextilePiEF" font ? OR
2) Find these washing instruction symbols on the internet ? OR
3) Deisgn my own in PAINT or something and put them in one of the 'insert
symbols' fonts ?

### Smart Tag in Excel does not recognize some stock symbols

The stock symbol GE for General Electric does not generate a smart tag -- can
stock symbols be added somewhere in Excel so a smart tag is generated?

### How could insert symbols e.g. micro in chart legend in Excel?

when we make a chart in Excel and chart legends need to have some symbol
character like micro molar, How could we create it, I tried but micro symbole
chane to "m".

### Truncated font list in Excel's "Insert Symbol" menu selection

Using my desktop, I am only seeing the first part of the available fonts in
Excel's "Insert Symbol" dropdown menu. I do not have this problem using the
same menu selection in Word. I can see the complete list of installed fonts
from the font menu on the Excel tool barand when formating a cell.

I don't have this problem on my laptop.

Both computers use Office XP (Excel 2002) runing under Windows XP Pro (SP2).

Any suggested solutions will be appreciated.

George

### How do you get an "X-bar" symbol in Excel?

I have figured out how to create an X-bar symbol in word, but cannot do it in
Excel. Copying it from Word doesn't appear to work either. DOes anyone know
how to do this?

### How do I change default symbols in Excel 2007?

Whenever I type (C) in Excel 2007, it defaults to the copyright symbol Â©.
How do I stop the program from doing this, and to allow me to choose when I
want to insert that or any other symbol instead of the program inserting it
by default?

### Symbols added to Word's AutoCorrect don't appear in Excel

I've added some Wingdings symbols to AutoCorrect options in Word, and I
thought I could access them in Excel but I can't. I tried to add the symbols
to AutoCorrect in Excel by using the character mapy Copy feature. But Excel
won't let me paste the symbol (or type its character code with ALT) into
AutoCorrect.

Any help greatly appreciated, and thanks.

### Re: How to do matrix operation with complex number elements in Excel

Not in Excel. Try Maple of MuPad
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"WILSON CHIRAMAL" <WILSON CHIRAMAL@discussions.microsoft.com> wrote in
message news:3AC1035D-8459-4D0D-A125-F78BC143F597@microsoft.com...
> Would like to use Analysis tool pack function , Matrix multiplication with
> elements as complex numbers.

### Inserting symbols not available in excel

Hi there,

I want to insert some symbols in excel and I cannot find the correct ones,
these symbols are the washing instruction symbols we have in all our clothing.
I have found some of them in the "TextilePiEF" font in the symbols menu, but
not all of the ones I need. So i wanted to know whether:
1) I could modify some of the symbols in "TextilePiEF" font ? OR
2) Find these washing instruction symbols on the internet ? OR
3) Deisgn my own in PAINT or something and put them in one of the 'insert
symbols' fonts ?

### Are there symbols for use in Excel to represent trees and plants?

I am trying to use the drawing functions in Excel in garden design and need
symbols to represent different types and sizes of plants. Are they available?

### Not equal to symbol in excel

What is the symbol for not equal to in excel

### How do I put 'c' in () in excel & not get copyright symbol

When I type (c) in excel I end up with the copyright symbol. I can I simply
get the letter c in parenthesis?

### How do i get the prescription symbol in excel?

Can't find the Rx symbol in
Excel. Help?