Fitting a Line in Microsoft® Excel

Chapter 4, Printout 1


Section 1: Making a Fitted Line Plot

  1. Enter the data.

    Screenshot: screenshot

  2. Plot density vs. pressure.

    Excel places the regression summary and line-fit plot in a new sheet of the workbook.

    Screenshot (summary output): screenshot

    Screenshot (plot): screenshot

    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."

  3. Edit the plot for a more informative display.


Section 2: Generating Additional Summary Information and Plots

  1. Return to the worksheet with the pressure and density data.

  2. Generate new summary information and plots.

    Excel creates a new sheet in the workbook with the summary statistics and three plots.

    Screenshot (summary output): screenshot

    Screenshot (plots): screenshot

    Note: you can move the charts as necessary by clicking a blank area in the chart and dragging it to a new location. You can add the line to the fitted line plot and resize the charts as described in Section 1. Other changes can be made by double-clicking various elements in the charts.