Returns the slope of the linear regression line through the given data points.
Cú pháp
SLOPE(known_ys, known_xs)Đối số
known_ysbắt buộc
An array or range of dependent data points.
known_xsbắt buộc
An array or range of independent data points.
The SLOPE function calculates the slope of a line based on the linear regression of two sets of data. The slope is the vertical distance divided by the horizontal distance between any two points on the line.
=SLOPE({2,3,9,1,8}, {6,5,11,7,5})→0.305555556Calculates the slope for the provided arrays of y and x values.
Prepare your data
Organize your dependent (y) and independent (x) variables into two separate columns or ranges.
Enter the formula
Type =SLOPE( and select the range for known_ys, followed by a comma and the range for known_xs.
The SLOPE function ignores cells that contain text, logical values, or empty cells.