An analyst is exploring workforce diversity at a large high$-$tech firm in Silicon Valley. The accompanying data file shows sex and ethnicity information for $50$ employees at the firm.

Click here for the Excel Data File

a$-1.$ Specify the null and the alternative hypotheses to determine if the proportion of women at the firm is different from $0\mathrm{.}30.$

a$-2.$ Calculate the value of the test statistic.

Note: Round final answer to $2$ decimal places.

a$-3.$ Find the p$-$value.

multiple choice $1$

p$-$value $<=0\mathrm{.}01$

$0\mathrm{.}01<$ p$-$value $<=0\mathrm{.}025$

$0\mathrm{.}025<$ p$-$value $<=0\mathrm{.}05$

$0\mathrm{.}05<$ p$-$value $<=0\mathrm{.}10$

p$-$value $>0\mathrm{.}10$

a$-4.$ Interpret your results at the $5\%$ significance level.

b$-1.$ Specify the null and the alternative hypotheses to determine if the proportion of white employees is more than $0\mathrm{.}50.$

b$-2.$ Calculate the value of the test statistic.

Note: Round final answer to $2$ decimal places.

b$-3.$ Find the p$-$value.

multiple choice $2$

p$-$value $<=0\mathrm{.}01$

$0\mathrm{.}01<$ p$-$value $<=0\mathrm{.}025$

$0\mathrm{.}025<$ p$-$value $<=0\mathrm{.}05$

$0\mathrm{.}05<$ p$-$value $<=0\mathrm{.}10$

p$-$value $>0\mathrm{.}10$

b$-4.$ Interpret your results at the $5\%$ significance level.

PROVIDE THE ACTUAL ANSWERS