Returns the slope of the linear regression line through data points in known_y's and known_x's. The slope is the vertical distance divided by the horizontal distance between any two points on the line, which is the rate of change along the regression line.
Syntax
SLOPE(known_y's,known_x's)
Known_y's is an array or cell range of numeric dependent data points.
Known_x's is the set of independent data points.
Remarks
where x and y are the sample means AVERAGE(known_x’s) and AVERAGE(known_y’s).
Example
The example may be easier to understand if you copy it to a blank worksheet.
Selecting an example from Help
|
|