Skip to main content

SLOPE

Definition

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

Sample Usage

SLOPE(A2:A100,B2:B100)

Syntax

SLOPE(data_y, data_x)

  • data_y - The range representing the array or matrix of dependent data.

  • data_x - The range representing the array or matrix of independent data.

Notes

  • Any text encountered in the value arguments will be ignored.

In order to use the SLOPE formula, start with your edited Excellentable

Then type in the SLOPE Formula in area you would like to display the outcome:

Type in the complete SLOPE formula for a cell as shown below:

Excellentable will generate the outcome when hitting enter. 

A
B
C
1
State
Known Y
Known X
2
Alabama
1/3/1900
6
3
Alaska
1/4/1900
5
4
Arizona
1/10/1900
11
5
Arkansas
1/2/1900
7
6
California
1/9/1900
5
7
Colorado
1/8/1900
4
8
Connecticut
1/6/1900
4
9
10
0.305555556

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.