Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
Chapter 4 Describing Your Data 171

To create your own boxplot:

1 Click Create your own boxplot from the list of topics in the Boxplots
workbook.
2 Enter the following numbers into the green cells located to the left
of the empty chart: 0, 1, 2, 2, 3, 3, 3, 3, 4, 4, 4, 5, 5, 6, 7.
As you enter the numbers, the chart is automatically updated to re-
fl ect the new distribution. The fi nal form of the boxplot is shown in
Figure 4-32.

Figure 4-32
Entering
data into a
sample box
plot


The central 50% of the data is found in the range from 2.5 to 4.5. The
median value is 3, which is not in the middle of that central 50%.
From the plot we can see that the values range from 0 to 7. There
are no outliers in the distribution. Now let’s see what happens if we
change a few of those numbers.
3 Change the last two numbers in the sample data from 6 and 7 to 9
and 12. Figure 4-33 shows the updated chart.
Free download pdf