Microsoft Office Tutorials and References

In Depth Information

**Getting It Straight: Using SLOPE and INTERCEPT to Describe Linear Data**

It seems clear that the data is linear and that you can validly use SLOPE and

INTERCEPT with them. The first step is to put these functions in the

worksheet as follows. You can use any worksheet that has linear X-Y data in it.

Figure 11-2:

The scatter

plot

indicates that

the X and Y

data in this

worksheet

are linear.

1. Enter the label
Slope
in an empty cell.

2. In the cell to the right, enter
=SLOPE(
to start the function entry.

3. Drag the mouse over the range containing the Y data values, or enter

the range address.

4. Enter a comma (
,).

5. Drag the mouse over the range containing the X data values, or enter

the range address.

6. Enter a ).

7. Press Enter to complete the formula.

8. In the cell below the slope label, enter the label
Intercept
.

9. In the cell to the right, enter
=Intercept(
.

10. Drag the mouse over the range containing the Y data values, or enter

the range address.

11. Enter a comma (
,).

12. Drag the mouse over the range containing the X data values, or enter

the range address.

13. Type a
) and press Enter to complete the formula.

At this point, the worksheet displays the slope and intercept of the linear

regression line for your data. The next task is to display this line on the chart: