Stats Ref - Box Plots How To

Stats Ref - Box Plots How To - How to creat box plots with...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
How to creat box plots with Excel 2007 To create the general plot: 1 Position your five number summaries in adjacent columns as shown, and in the same sequence. 2 Select the block as shown in red, including the column headings but not the row labels. 3 "Insert", "Line" chart, choose chart style in the second row at the left side. 4 Right click anywhere on chart. "Format Data Series", then "Switch Row/Column" Use the up and down arrow buttons in the dialogue box to re-order the series to 2, 1, 3, 5, 4 rather than 1, 2, 3, 4, 5. To reformat the plot into a box-and-whiskers plot: 5 Right click on the legend box in the graph. "Delete" it. 6 For the top-most and bottom-most lines on the chart: Right click on the line, "format data series", "marker options", "type", choose the big hyphen near the bottom of the list, and "close". 7
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/29/2010 for the course COMM 291 taught by Professor E.fowler during the Spring '10 term at UBC.

Page1 / 2

Stats Ref - Box Plots How To - How to creat box plots with...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online