Microsoft Office Tutorials and References

In Depth Information

**SLOPE**

Figure 11.42

There must be at least

three data points in

the data set for the

SKEW
function.

SLOPE

SLOPE
returns the slope of the regression line through data points in
known_y’s
and

known_x’s
.

=SLOPE(known_y’s,known_x’s)

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

Figure 11.43

The slope of a line is

the amount of change

in y due to a change of

one unit in x.