REGRESSION OPTIONS |
|
To do this, call
up the regression dialog box as before and check the options for residuals, standardised
residuals and residual plots. The following will appear:
Two other options available are for a line fit plot and a normal probability plot.
   

In addition to the line fit plot option above it is also possible to fit a straight
line through a scatterplot by clicking on the series, selecting Chart > Add Trendline and
selecting the linear option on the Type tab.
Options also exist to display the regression equation and R² value on the
chart.
Basic statistics in Excel   23.2.99   Page: 25 of 25 |
|