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.
Search JabSto ::




Custom Search