Question

Look back at your data and your regression equation. (Sample data is shown to the right, with X= pressure and Y=volume.) click all statements that are true.
Answered.

Answer 1

Select the block of cells to be included in the scatter plot by clicking and dragging, then from the Insert ribbon under Chart drop down the Scatter or Bubble menu and select Scatter.  A chart will appear on the spreadsheet.

To set up a scatter plot in Excel, enter the pairs of data in two columns with each value of a pair on the same row.  By default, Excel considers the column on the left to contain the horizontal (X) values and the column on the right to contain the vertical (Y) values.

If you click on the + sign at the upper right of the chart, a list of checkboxes will appear.  Check Axes, Axis Titles, and Trendline.  Uncheck everything else.  You should edit the Axis Titles to include the name of the factor and any units associated with it.  Double-click on the Axis numbers to bring up the Format Axis dialog, then click on the bar-graph icon to access Axis Options.  Set the bounds and units appropriately and set the tick marks to something sensible.