Excel Matrix Multiplication, Transpose and Inverse functions

In this video we're going to be looking at a general view on how to use Excel for Matrix equations in a step by step process. The formula used in this video is what's known as Multiple Regression, Widely used in order to estimate correlations between different variables. Using this formula you can estimate β (Beta) and find the answer to:
Y = β¹X + β²X'' + β³INC

Formula used in video:
(X'X)¯¹X'Y = β

The functions used are:
=TRANSPOSE(MATRIX)
=MMULT(MATRIX,MATRIX)
=MINVERSE(MATRIX)

As I mentioned in the video, there is a LOG(logarithmic) Matrix in there as well, I will be posting a video on how to do it in a few days if not tomorrow.

Please press "Like" or "Subscribe" If you're interested in more videos like these. Any comment is greatly appreciated and if you have any questions don't be afraid to ask. I'll try and answer as soon as possible.

[Nuralinur]

Thank you very much for this video. It helped me a lot with my homework..

[thegamechannel]

calculator++ fx by graficlux can do vector calculations like projection, cross, dot products, vectors angle, also matrix calculations determinants, rank, LU, QR decompositions, ref, rref, solve system of equations, draw graphs, and editing is very easy, it can help to do your homework or at list check your results, check it out: Matrix calculations