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




Custom Search