SLOPE function

SLOPE( known y , known x )

SLOPE computes the slope of the linear regression line represented by columns of known x and y values.

Example

The example in this section uses this data set.

 

  A B
1 Height Weight
2 4 100
3 4.5 150
4 5 200
3 5.5 250
4 6 300

Use the SLOPE function to show the vertical distance divided by the horizontal distance between any two points on the regression line.

Formula

SLOPE( SLICE( B:B , start , end ) , SLICE( A:A ) )

Result

100

Related links:

Statistics Functions