Regression

 

 

 

 

SLOPE Formula 1

 

          N ∑ XY  -  ∑X * ∑Y

b  =   ______________________________

 

      N∑ X2 -  (∑X)2

 

 

 

SLOPE Formula 2

 

 

 

    ∑ (X - MX) * (Y- MY)

b   = ________________________

 

   ∑ (X - MX)2

 

 

 

INTERCEPT

 

         

                             a   =    MY – b * MX