Problem $1$:

$($a$)$ Use Excel to prepare a Pareto chart of the following $($b$)$ In your own words, what does this chart say?

Cell Phone Service Provider n $=158$

Service Provider

Percent

Cumulative Percent

Verizon

$37\mathrm{.}3$

$37\mathrm{.}3$

AT&T

$29\mathrm{.}7$

$67\mathrm{.}1$

T$-$Mobile

$13\mathrm{.}3$

$80\mathrm{.}4$

Sprint

$8\mathrm{.}9$

$89\mathrm{.}2$

Other

$4\mathrm{.}4$

$93\mathrm{.}7$

Nextel

$3\mathrm{.}2$

$96\mathrm{.}8$

Al$1$te$1$

$2\mathrm{.}5$

$99\mathrm{.}4$

Virgin

$0\mathrm{.}6$

$100\mathrm{.}0$

Problem $2$:

$($a$)$ Use Excel to prepare an appropriate type of chart $($bar$,$ line, pie, scatter$)$ to display the following Modify the default colors, fonts, etc., as you judge appropriate to make the display effective. $($b$)$ Would more than one kind of display be acceptable? Why or why not?

U$.$S$.$ Energy Consumption by Source

Source

Quad BTU

Percent

Petroleum

$37\mathrm{.}06$

$38\mathrm{.}4\%$

Natural Gas

$23\mathrm{.}15$

$24\mathrm{.}0\%$

Coal

$20\mathrm{.}49$

$21\mathrm{.}2\%$

Nuclear

$8\mathrm{.}52$

$8\mathrm{.}8\%$

Renewables

$7\mathrm{.}17$

$7\mathrm{.}4\%$

Other

$0\mathrm{.}21$

$0\mathrm{.}2\%$

Total

$96\mathrm{.}60$

$100\mathrm{.}0\%$

Problem $3$:

$($a$)$ What kind of display is this? $($b$)$ Identify its strengths and weaknesses, using the tips and checklists shown in this $($c$)$ Can you suggest any improvements? Would a different type of display be better?

Picture$1.$jpg

Problem $4$:

$($a$)$ What kind of display is this? $($b$)$ Identify its strengths and weaknesses, using the tips and checklists shown in this chapter. $($c$)$ Can you suggest any improvements? Would a different type of display be better?

Picture$2.$jpg