Excel SLOPE Function
Use:- Computes slope of linear regression equation between two variables
- Syntax:
- SLOPE( y-range , x-range )
- Example:
- Cell E9 formula: SLOPE( C2:C9 , B2:B9 )
-
- Notes:
- The order of the X and Y data is extremely important. SLOPE( C2:C9 , B2:B9 ) is not the
same as SLOPE( B2:B9 , C2:C9 ).
- Related Functions:
- INTERCEPT, COVAR, CORREL, RSQ