How to solve Use Excel to prepare an appropriate type of chart $($bar$,$ line, pie, scatter$)$ to display the following data. 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?

Domestic Market Share, Ten Largest U$.$S$.$ Airlines AirlineMkt

Airline

Percent

Alaska

$4\mathrm{.}5$

American

$18\mathrm{.}4$

Delta

$16\mathrm{.}9$

Frontier

$2\mathrm{.}0$

Hawaiian

$1\mathrm{.}7$

JetBlue

$5\mathrm{.}4$

SkyWest

$2\mathrm{.}4$

Southwest

$18\mathrm{.}3$

Spirit

$2\mathrm{.}7$

United

$14\mathrm{.}5$

Other

$13\mathrm{.}2$

Total

$100\mathrm{.}0$

$3\mathrm{.}41($a$)$ Use Excel to prepare an appropriate type of chart $($bar$,$ line, pie, scatter$)$ to display the following data. 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?

$\backslash$table$[[$Domestic Market Share, Ten Largest U$.$S$.$ Airlines AirlineMkt,$],[$Airline$,$Percent$],[$Alaska$,4\mathrm{.}5],[$American$,18\mathrm{.}4],[$Delta$,16\mathrm{.}9],[$Frontier$,2\mathrm{.}0],[$Hawaiian$,1\mathrm{.}7],[$JetBlue$,5\mathrm{.}4],[$SkyWest$,2\mathrm{.}4],[$Southwest$,18\mathrm{.}3],[$Spirit$,2\mathrm{.}7],[$United$,14\mathrm{.}5],[$Other$,13\mathrm{.}2],[$Total$,100\mathrm{.}0]]$

Source:

www$.$transtats.bts$.$gov. Data are based on $2015$ revenue passenger miles.