E
E
G
V
V
E
V
V
V
E
E
G
V
E
E
V
E
E
E
V
V
V
V
F
V
E
V
E
G
E
G
E
V
E
V
E
V
V
V
V
E
E
V
V
E
P
E
V
P
V
1. Use a percent frequency distribution and a bar chart to summarize these data.
What do these summaries indicate about the overall customer satisfaction w

Main content
Chapter Contents
Exercises
Methods
1. The response to a question has three alternatives: A, B, and C. A sample of 120 responses
provides 60 A, 24 B, and 36 C. Show the frequency and relative frequency distributions.
2. A partial relative freq

1. Are these data categorical or quantitative?
Answer
Categorical
2. Provide frequency and percent frequency distributions.
Answer
3. Construct a bar chart and a pie chart.
4. On the basis of the sample, which television show has the largest viewing
audie

Relative Frequency and Percent Frequency Distributions
A frequency distribution shows the number (frequency) of items in
each of several nonoverlapping classes. However, we are often
interested in the proportion, or percentage, of items in each class.
The

1.
Step 1
Select cells C2:D6
2.
Step 2
Click the Insert tab on the Ribbon
3.
Step 3
In the Charts group, click Column
4.
Step 4
When the list of column chart subtypes appears,
o
o
5.
Go to the 2-D Column section
Click Clustered Column (the leftmost chart)

In this chapter, you will learn about tabular and graphical methods
of descriptive statistics such as frequency distributions, bar
charts, histograms, stem-and-leaf displays, crosstabulations, and
others. The goal of these methods is to summarize data so

Enter Data: The label Brand Purchased and the data for the 50
soft drink purchases are entered into cells A1:A51.
Enter Functions and Formulas: Excels COUNTIF function can
be used to count the number of times each soft drink appears in
cells A2:A51. We fi

For the audit time data in Table 2.4, after deciding to use five
classes, each with a width of five days, the next task is to specify
the class limits for each of the classes.
Class Limits
Class limits must be chosen so that each data item belongs to
one

Colgate-Palmolive Company
NEW YORK, NEW YORK
The Colgate-Palmolive Company started as a small soap and
candle shop in New York City in 1806. Today, Colgate-Palmolive
employs more than 40,000 people working in more than 200
countries and territories around

2.2 Summarizing Quantitative Data
Frequency Distribution
As defined in Section 2.1, a frequency distribution is a tabular
summary of data showing the number (frequency) of items in
each of several nonoverlapping classes. This definition holds for
quantita