Matrix Algebra using Excel

Neeraj Kaushik

unread,

Jun 18, 2021, 1:16:55 AM6/18/21

to dataanalysistraining

Dear Friends

In the playlist of SmartPLS, I've explained the Higher-Order Constructs and the calculations of CR, AVE, Cronbach alpha & HTMT

The only missing statistics is rho_A

The calculations of rho_A need a lot of Matric computations. Hence, first I'm explaining the Matrix concepts and computations using Excel and then we'll go ahead with rho_A.

-----------------------------------------------------------------------------------------------------------

Along with the Matrix, it is important to learn MS-Excel too.

At level-1 of Excel, one shd know pivot tables, lookup family functions etc

The result of normal Excel functions comes in a cell where we write formula/function

At level-2 of Excel comes the Array Functions which provides the answer in a group of cells

These functions are run NOT BY ENTER rather it needs CTRL+SHIFT+ENTER

-----------------------------------------------------------------------------------------------------------

I've explained the concept of Matric in this video

Matrix-1 Introduction to Matrix Algebra: https://youtu.be/BLEO5m8bsIw

Happy learning

Neeraj

Neeraj Kaushik

unread,

Jun 18, 2021, 11:54:47 PM6/18/21

to dataanalysistraining

Dear Friends

The Matrix Multiplication is one of the most important things used in computing higher statistics like rho_A

I've explained the concept of the same and how to use MS-Excel for the same in this video:

Matrix-2 Matrix Multiplication: https://youtu.be/Eo3MTzh0MjI

Happy Learning

Neeraj Kaushik

unread,

Jun 19, 2021, 11:38:58 PM6/19/21

to dataanalysistraining

Dear Friends

The next important concept in Matrix is the Inverse of a Matrix.

It need the understanding of the concepts of Determinant, Cofactor, Adjoint of a Matrix.

I've explained all these in the following videos:

Matrix-3 Determinant Concept and Calculations: https://youtu.be/_GeDDWa23ZE
Matrix-4 Computing Matrix Inverse: https://youtu.be/UGZbojOmc1Q

Happy Learning

Neeraj Kaushik

unread,

Jun 20, 2021, 9:13:28 PM6/20/21

to dataanalysistraining

Dear Friends

Now that we've done the Matric functions like Determinant, Cofactor, Adjoint, and Inverse of a Matrix, it's time to learn the real applications of Matric Algebra viz Solving simultaneous equations using Matrix.

Matrix-5 Simultaneous Equation Solution: https://youtu.be/cKkFHtxUaQc

Happy Learning

Neeraj Kaushik

unread,

Jun 21, 2021, 10:11:36 PM6/21/21

to dataanalysistraining

Dear Friends

While working on Matrix using MS-Excel, there are certain points to be taken care of.

I've explained these points in this quick video:

Matrix-6 Matrix Algebra Rules: https://youtu.be/YrFCy_n8iZo

Happy Learning

Reply all

Reply to author

Forward