Returns the slope of the linear regression line through the given data points.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
SLOPE(known_ys, known_xs)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.305555556
Calculates the slope for the provided arrays of y and x values.
The SLOPE function ignores cells that contain text, logical values, or empty cells.