Returns the slope of the linear regression line through the given data points.
Bu işlev, Google E-Tablolar'da Excel'deki gibi çalışır — aynı söz dizimi ve bağımsız değişkenler.
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})Sonuç: 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.