Solving System of Equations Using Excel

This video show how to solve a system of equations using Microsoft Excel.
Link to Excel file: sites.google.c...

[@mohamadabdulrahim5869]

just imagine how messy the world would be without this kind of people who make this kind of videos.. thanks... alot!

[@crowsmathclass]

You’re welcome.

[@donaldverani3794]

Mate your teaching skills are elite...didn't understand the lecturer but you made it so easy! Thank you 👏🏿👏🏿👏🏿👏🏿👏🏿

[@crowsmathclass]

Thank you.

[@christinejoyalipio2239]

Very helpful for my brother's lesson! Thank you very much! :)

[@crowsmathclass]

You’re welcome. Glad it helped.

[@luizfeliperodriguessantana5842]

I'm glad you posted this video , I learned to much things on it , thanks

[@crowsmathclass]

You’re welcome. Glad it helped.

[@matthewmcbride1655]

thanks very much steve. you make things a lot simpler than my chinese lecturer who goes too fast and also who i have trouble understanding him anyway

[@crowsmathclass]

You’re welcome. Glad it helped.

[@nathannascimento9751]

Great tutorial. Thanks from Brazil

[@crowsmathclass]

Thank you. Glad the video helped.

[@leoaung3300]

I was manually selecting each cell to calcuate each matrix. Didn't know there was a function for matrix. Thanks alot for your help

[@crowsmathclass]

You’re welcome. Glad it helped.

[@oyin0303]

Thank you so much for this video! Your teaching skills are superb.

[@crowsmathclass]

Thank you.

[@calebelino1518]

Omg, there is so useful information on that video, thank you so much

[@crowsmathclass]

You’re welcome. Glad it helped.

[@dineshmathsclasses2514]

Nice explanation of the concept and method, thank you so much for your time and effort.

[@crowsmathclass]

You’re welcome. Thank you for the comment.

[@MrRahulukey]

Dear sir, Thank you for your video, I can able to solve the 3 unknown equation for radiation heat exchange for three gray surfaces. Thank you so much :-)

[@crowsmathclass]

You’re welcome. Glad it helped.

[@edrin1855]

Great video. Thanks

[@crowsmathclass]

Thank you.

[@mgrkankunvtas9897]

Thanks so much!! very useful...keep doing your videos!!

[@crowsmathclass]

Thank you. Glad it helped.

[@marykusi6938]

Great job 👍 please a video on how to use Excel to solve lpps simplex method

[@crowsmathclass]

Thank you.

[@marcm7060]

Great tutorial

[@crowsmathclass]

Thank you.

[@andreicostin9242]

Awesome, I'm new to excel and this is a great solution that can be generalized to many problems!!

[@crowsmathclass]

Thank you. Glad it helped.

[@Crazytesseract]

I knew the mathematical concept. Only I didn't know the exact formulas in Excel! Thanks! A useful thing world be to lock all the cells other than the input cells and save with a simple password, so that the formulae are not affected.

[@saraha.3967]

Thank you! This was very helpful ^^

[@crowsmathclass]

You’re welcome. Glad it helped.

[@esbenrasmussen2944]

Hi Steve. What do you do if your 3 equations are something like r^2 = (5 - X)^2 + (3 - Y)^2 (circle equations)? Excel will not take "(5-X)^2" as parameter in the MINVERSE matrix. How do you solve something like this? 🙂

[@AS-xx6mb]

Very useful tutorial. Big thanks to you from Kuwait. By the way i love your accent. I’ve heard it a lot in movies but i do not know where its origin. I would love to know please :D

[@crowsmathclass]

Thank you. Glad it helped. Southern United States.

[@markavesi3584]

i got error saying "you´ve entered too many arguments for this function"?

[@yawarmanzoordar9968]

Very nice It helped me much

[@crowsmathclass]

Thank you. Glad it helped.

[@florenceting9824]

Hi. Your video is very helpful. But may I know why the answer calculated using calculator is different from in excel?

[@crowsmathclass]

They should be the same.

[@rashiagrawal178]

Sir please help me with this that if "b" is a zero matrix then how will we solve the equation as i am unable to do so. My all the variable values are coming 0 which isnt the answer

[@archiecabante4147]

thank you soo muchh sir you really help me with this video

[@crowsmathclass]

You’re welcome. Glad it helped.

[@prankster1590]

What if there are an infinite number of solutions?

[@jumbyvt6839]

How can I calculate the inverse of an overdetermined system of equations? m > n

[@crowsmathclass]

It has to be a square matrix. m=n

[@m4d_al3x]

I know this video is older, but what about free variables, how can i find them using excel?

[@reymarklopez2127]

Thank you very much

[@crowsmathclass]

You’re welcome.

[@adnanmahmud8691]

Life saver👍🏾

[@crowsmathclass]

Glad it helped.

[@gamesofcontent]

Oh, so I just put it into Linear ABCD form?

[@reemabuaisha8246]

Hi.. I did the minverse formula however I got a NUM error. Even though I used the same numbers you did. Would you know why I'm getting this error?

[@crowsmathclass]

Did you hit Ctrl Shift Enter

[@mstipich1]

Cool accent, luv it

[@crowsmathclass]

Thank you.

[@tzakman8697]

dont you need to find DETERMINANT too?

[@crowsmathclass]

Not if you solve using the inverse. Only Cramers Rule.

[@gadgets6641]

nice

[@ridzkyasdi2510]

what if the determinant of A = 0?

[@crowsmathclass]

Then you either have no solution or infinite solutions.

[@Rolroorlo]

I fucking love you Thank you for this video!

[@crowsmathclass]

You’re welcome.

[@warrencohen4533]

can "named" array be used

[@crowsmathclass]

I haven’t tried it but I would say yes.

[@warrencohen4533]

I'll give it a try soon and let you know

[@SultanAlawad]

Did not work for me.

[@gadgets6641]

tnx

[@crowsmathclass]

You’re welcome. Glad it helped.