The $"WA{1}_{W}A{5}_E$xecutive Compensation" file indicates that the $85\%of$ the sampled top$-$compensated executives

are male, and $15\%106\mathrm{.}6,m,53t-$test $or$ the nonpooled $t-$test.

Provide a rationale.

Perform the hypothesis test.

Analyze the test results, state your conclusion$(s),$ and provide the rationale for your statement$(s).$

Using Excel statistical functions and formulas:

Calculate the confidence interval.

Looking $at$ the result, state your conclusion.

How does this result change $or$ confirm your analysis and conclusion$(s)$ from the hypothesis test? Provide $a$

rationale.

$WA1-$ Executive Compensation

$WA5-$ Executive Compensation

$1$ Year Pay

$ID$ Industry $($$ mil$)$ Gender Age

$1$ health $106\mathrm{.}6m58$

$2$ communications $68\mathrm{.}8m64$

$3$ entertainment $55\mathrm{.}7m60$

$4$ health $53\mathrm{.}9m56$

$5$ entertainment $51\mathrm{.}7m65$

$6$ retail $45\mathrm{.}0f71$

$7$ health $44\mathrm{.}7m59$

$8$ energy $40\mathrm{.}7m57$

$9$ industrial $39\mathrm{.}7m61$

$10$ communications $38\mathrm{.}4f64$

$11$ health $35\mathrm{.}3m58$

$12$ health $35\mathrm{.}3m46$

$13$ energy $35\mathrm{.}0m61$

$14$ health $33\mathrm{.}9m52$

$15$ communications $33\mathrm{.}0m63$

$16$ communications $32\mathrm{.}8f48$

$17$ energy $32\mathrm{.}0m56$

$18$ energy $31\mathrm{.}9f75$

$19$ industrial $31\mathrm{.}7m59$

$20$ industrial $31\mathrm{.}5m56$

$21$ energy $31\mathrm{.}4m57$

$22$ retail $31\mathrm{.}1m57$

$23$ retail $31\mathrm{.}0m58$

$24$ retail $30\mathrm{.}9m55$

$25$ energy $30\mathrm{.}3m56$

$26$ industrial $29\mathrm{.}8m59$

$27$ health $28\mathrm{.}3m83$

$28$ entertainment $27\mathrm{.}6f62$

$29$ industrial $26\mathrm{.}5m64$

$30$ industrial $26\mathrm{.}0m62$

$31$ retail $25\mathrm{.}5m54$

$32$ industrial $25\mathrm{.}1m53$

$33$ health $24\mathrm{.}9m60$

$34$ industrial $24\mathrm{.}7m68$

$35$ industrial $24\mathrm{.}2m64$

$36$ industrial $24\mathrm{.}2m47$

$37$ transportation $24\mathrm{.}1m59$

$38$ transportation $23\mathrm{.}4m62$

$39$ health $23\mathrm{.}4m56$

$40$ health $23\mathrm{.}2m56$

$41$ financial $23\mathrm{.}0m58$

$42$ financial $22\mathrm{.}3m49$

$43$ communications $22\mathrm{.}3m51$

$44$ financial $22\mathrm{.}2m59$

$45$ retail $21\mathrm{.}7m66$

$46$ energy $21\mathrm{.}6m63$

$47$ financial $21\mathrm{.}3m65$

$48$ industrial $21\mathrm{.}2m57$

$49$ energy $21\mathrm{.}1m64$

$50$ communications $20\mathrm{.}9m57$

$51$ transportation $20\mathrm{.}8m60$

$52$ industrial $20\mathrm{.}6m60$

$53$ retail $20\mathrm{.}6f55$

$54$ financial $20\mathrm{.}2m65$

$55$ financial $20\mathrm{.}1m58$

$56$ industrial $20\mathrm{.}1m59$

$57$ financial $20\mathrm{.}0m59$

$58$ transportation $19\mathrm{.}9m66$

$59$ communications $19\mathrm{.}9m61$

$60$ retail $19\mathrm{.}8m62$

$61$ financial $19\mathrm{.}8m48$

$62$ financial $19\mathrm{.}7m53$

$63$ industrial $19\mathrm{.}6m61$

$64$ health $19\mathrm{.}2m62$

$65$ energy $18\mathrm{.}9m60$

$66$ industrial $18\mathrm{.}5m55$

$67$ industrial $18\mathrm{.}5m60$

$68$ industrial $18\mathrm{.}5m48$

$69$ financial $18\mathrm{.}2m59$

$70$ transportation $18\mathrm{.}2m63$

$71$ health $18\mathrm{.}0m62$

$72$ retail $17\mathrm{.}7m56$

$73$ communications $17\mathrm{.}6m51$

$74$ industrial $17\mathrm{.}5m51$

$75$ retail $17\mathrm{.}5f57$

$76$ retail $17\mathrm{.}4m49$

$77$ retail $17\mathrm{.}4m62$

$78$ health $17\mathrm{.}3m58$

$79$ energy $17\mathrm{.}3f50$

$80$ industrial $17\mathrm{.}2m60$

$81$ health $17\mathrm{.}1m64$

$82$ retail $17\mathrm{.}0f60$

$83$ health $16\mathrm{.}7m57$

$84$ financial $16\mathrm{.}7m58$

$85$ retail $16\mathrm{.}6m58$

$86$ health $16\mathrm{.}3m56$

$87$ communications $16\mathrm{.}1f55$

$88$ communications $16\mathrm{.}1f58$

$89$ industrial $16\mathrm{.}0m47$

$90$ communications $15\mathrm{.}8m80$

$91$ entertainment $15\mathrm{.}8f62$

$92$ industrial $15\mathrm{.}7m53$

$93$ industrial $15\mathrm{.}6m62$

$94$ financial $15\mathrm{.}4m55$

$95$ energy $15\mathrm{.}4f60$

$96$ industrial $15\mathrm{.}3f48$

$97$ retail $15\mathrm{.}2m55$

$98$ industrial $15\mathrm{.}1m59$

$99$ industrail $14\mathrm{.}9f61$

$100$ industrial $14\mathrm{.}9m47$