Www.lcps.org



Directions for Excel 2013:

I. Bar graph

II. Scatterplot

lll. Box plot

IV. Standard deviation bars

I. Create a Bar Chart (Graph) in Excel 2013: (qualitative or categorical IV and quantitative DV)

1. Take an average of the data (using the AVERAGE function as shown in the image below). This average will be used to create the graph.

=average (highlight column of data) Enter

(The equals sign tells Excel that this is a formula. Be sure to include the start and end parentheses.)

[pic]

2. Now highlight the averages (B23 and C23 in this example) hold down control, then highlight the means. Then click on “Insert” and click “column” and select “2D-column” as shown in image below:

3. A chart will now be added as shown here.

4. To add chart title and axis labels, click on the graph and then click on the + sign. You can then select for Axis titles and Chart Titles. This is also where you will go to add error bars (directions follow).

5. Save. See below for adding standard deviation bars.

II. Scatterplot with all the data in Excel 2013:

(quantitative IV and quantitative DV)

1. Make sure there are no letters in the headings or in the data cells.

2. Highlight the data, including the column headings.

3. Select Insert - Scatterplot in charts - then select the simple scatterplot.

4. The graph will not be what you want at this point. Right click on the white part of the graph - Select Data. Then click on Switch Row/Column. Then click OK.

5. Remove the Series text box by selecting the text box, then right click and Delete.

6. Add title and axes labels. Save.

Adding standard deviation bars. This is a little tricky; hopefully these directions are helpful. There are videos that can lead you through the process also.

Note: These directions are for Excel 2013. See other directions for Excel 2010.

7. Determine the standard deviations using the Excel formula (1):

=stdev (highlight the column of data) Enter

(The equals sign tells Excel that this is a formula. Be sure to include the start and end parentheses.)

8. Copy this formula for all columns.

9. Click on the graph.

o Select Chart Tools on the top ribbon.

o Design

o Add Chart Element

o Error Bars

o More Error Bars Options… (2)

o scroll to bottom and select Custom

o Specify Value (3)

o In Custom Error Bars box, click on the chart icon for Positive Error Value (4)

o highlight all standard deviations (5)

o click on chart icon again

o repeat for Negative Error Value using the same standard deviations

o Your graph should now have the appropriated SD bars. Check to make sure that the bars look to be the correct length.

10. Save

-----------------------

(1)

(2)

(3)

(4)

(5)

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download