A. Position X data column before Y data.  They do not have to be adjacent, but the dependent
       variable data must be in a column to the right of the independent variable column.

  B. Select X and Y column without labels.  If X and Y are not adjacent, hold CONTROL while
      selecting second column.

  C. Click CHART WIZARD.
       1. Under Standard Types select XY (Scatter) for the Chart type.  Then under chart sub-type
           select the first (top) box that only contains data points.  Click NEXT.
       2. Check that Data Range is correct in the next window.  The name after the = sign and
           before the ! is the name of the worksheet that contains the data.  Check also that columns
           is checked if your data is in columns rather than rows.  Click on the Series tab and check
           that the X and Y variables are not confused.  You can also name the chart in the Name: slot.
           When you have everything set here, click NEXT.
       3. In this window you can label the axes under the Titles tab.  Play around with the other tabs
           and notice how they change the chart and inform the reader.  Click NEXT.
       4. Tell Excel where to place the chart.  Click FINISH.

  D. Editing Chart
       1. Click inside chart.  Border should appear with 8 small black squares around the outside.
       2. To change Axis Scale: Click desired axis.  Click right button and choose FORMAT Axis.
           Experiment with different tabs and choices but most useful is probably Scale.  You can
            change minimum and maximum values on the axes to avoid bunching of data with large
            amounts of white space.
       3. Change Size: To move a particular side, click and hold on small black square on this side
           (two-pointed arrow appears).  Drag to desired size. To move two adjacent sides, perform
           similar move with square in corner.  To move entire diagram, click and hold inside box
           (not the chart itself) as you drag to desired position.  Four-pointed arrow appears.

E. Regression Model and Trendline
    1. Place the cursor on any point on the scatterplot.
    2. Click the right mouse button and choose ADD TRENDLINE...
    3. Choose the TYPE tab and make sure the linear model is chosen (usually the default).
    4. Choose the OPTIONS tab and make sure DISPLAY EQUATION ON CHART is checked.
    5. Press OK.

 II. Regression Output

  A. Simple Regression
        1. Under TOOLS menu, select DATA ANALYSIS.  Choose REGRESSION.  Click OK.
        2. Fill in Regression Dialog Box.
            a. Type or select Y and X ranges.  Indicate whether labels are included.  Check if want to
                force line through origin (this is not usually the case for us).
            b. Position output on new page--give it a name, Y=f(X).
            d. Selected desired residual analyses.  Select LINE FIT to show results on scatterplot.

  B. Editing Charts:  See Scatterplots

  C. Multiple Regression
       1. Position independent variable (Xs) into adjacent columns.
       2. Repeat rules for simple regression, but use range of X values rather than column, when
           defining position of independent variables.

  D. Correlation
       1. Arrange variables of interest in adjacent columns.
       2. Under TOOLS menu, select DATA ANALYSIS.  Choose CORRELATION.  Click OK.

 Return to Forensic Worksheet #9
 Return to Worksheet Menu
 Return to Handout Menu