Hi guys,

I've tried everything now. I can't seem to make it work with the different functions for matrix algebra in Excel (MMULT etc...) to work out a linear regression between these two matrices:

Matrix A:
1 20
1 20
1 30

Matrix Y:
7
5
5

Can anybody help me out how to make a linear regression on these two matrices using excel matrix calculation?