Microsoft Office Tutorials and References
In Depth Information
There must be at least
three data points in
the data set for the
SLOPE returns the slope of the regression line through data points in known_y’s and
The slope of line is the vertical distance divided by the horizontal distance between any two
points on the line. Figure 11.43 shows the result of calculating the slope for a set of sales data.
KNOWN_Y’S Is the set of data points or values; the dependent variable.
KNOWN_X’S Is the set of independent data points.
The equation for the slope of the regression line is
The slope of a line is
the amount of change
in y due to a change of
one unit in x.