Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

SLOPE

Calculates the slope of the line resulting from the linear regression of a dataset.

Sample Usage

SLOPE(A2:A40, B2:B40)

Syntax

SLOPE(data_y, data_x)

  • data_y - The array or range representing dependent data.
  • data_x - The array or range representing independent data.

Examples

SLOPE(A2:A40, B2:B40) returns the slope of the line resulting from the linear regression of the dataset.
 

Notes

  • Any text encountered in data_y and data_x will be ignored.