**Launch Excel.****Enter the data.**- In cell A1, type "
`Pressure`" - In cell B1, type "
`Density`" - In cells A2-A16, enter the pressure data from the
*x*column in Table 4.1 (p. 124). - In cells B2-B16, enter the density data from the
*y*column in Table 4.1.

*Screenshot:*- In cell A1, type "
**Plot density vs. pressure.**- Select
**"Tools --> Data Analysis."** - In the dialog box that follows, select
**"Regression"**from the list. - Click
**"OK."** - Fill out the resulting dialog box as follows:
Input Type Label Value **Input Y Range:**`$B$1:$B1$16`**Input X Range:**`$A$1:$A$16`**Labels***checked***Constant is Zero***unchecked***Confidence Level***unchecked***New Worksheet Ply:***selected***New Worksheet Ply:****Residuals***checked***Residual Plots***unchecked***Standardized Residuals***checked***Line Fit Plots***checked***Normal Probability Plots***unchecked* - Click
**"OK."**

*Excel places the regression summary and line-fit plot in a new sheet of the workbook.***Note:**you can resize all columns to fit their contents by selecting all the cells you want to resize, then selecting**"Format --> Column --> Autofit Selection."**- Select