3.4
Excel
Activity
2
-
Five-Number
Summary
and
Box
Plot
Construction
for
Multiple
Data
Sets
(Structured)
A
magazine
provided
overall
customer
satisfaction
scores
for
AT&T,
Sprint,
T-Mobile,
and
Verizon
cell-phone
services
in
major
metropolitan
areas
throughout
the
United
States.
The
rating
for
each
service
reflects
the
overall
customer
satisfaction
considering
a
variety
of
factors
such
as
cost,
connectivity
problems,
dropped
calls,
static
interference,
and
customer
support.
A
satisfaction
scale
from
0
to
100
was
used
with
0
indicating
completely
dissatisfied
and
100
indicating
completely
satisfied.
The
ratings
for
the
four
cell-phone
services
in
20
metropolitan
areas
are
contained
in
the
Excel
Online
file
below.
Construct
a
spreadsheet
to
answer
the
following
questions.
Open
spreadsheet
a.
Consider
T-Mobile
first.
What
is
the
median
rating
(to
1
decimal)?
755
@)
b.
Develop
a
five-number
summary
for
the
T-Mobile
service.
Smallest
value
70
First
quartile
(to
2
decimals)
73.25
Median
(to
1
decimal)
755
Third
quartile
(to
2
decimals)
76.75
CRrRReE@
Largest
value
79
C.
Are
there
outliers
for
T-Mobile?
