Returns the slope of the linear regression line through the given data points.
この関数は Google スプレッドシートでも 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.