Question

(Use Excel) According to a report on workforce diversity, about 60% of the employees in high-tech firms in Silicon Valley are white and about 20% are Asian (http://moneycnn.com, November 9, 2011). Women, along with blacks and Hispanics, are highly underrepresented. Just about 30% of all employees are women, with blacks and Hispanics, accounting for only about 15% of the workforce. Tara Jones is a recent college graduate, working for a large high-tech firm in Silicon Valley. She wants to determine if her firm faces the same diversity as in the report. She collects gender and ethnicity information on 50 employees in her firm. A portion of the data is shown in the accompanying table.

Gender	Ethnicity	Gender	Ethnicity
Female	White	Male	White
Male	White	Female	Nonwhite
Male	Nonwhite	Male	White
Male	White	Male	White
Male	Nonwhite	Female	White
Female	White	Male	White
Male	White	Female	White
Male	White	Male	White
Female	White	Male	Nonwhite
Male	White	Male	Nonwhite
Female	White	Female	White
Male	Nonwhite	Male	Nonwhite
Male	Nonwhite	Female	Nonwhite
Male	Nonwhite	Female	Nonwhite
Female	Nonwhite	Male	White
Male	White	Male	Nonwhite
Female	White	Male	White
Female	Nonwhite	Female	White
Male	White	Male	White
Female	White	Female	Nonwhite
Female	White	Male	White
Male	Nonwhite	Female	Nonwhite
Male	White	Male	White
Male	White	Male	White
Female	White	Male	Nonwhite

a-1.	At the 5% level of significance, determine if the proportion of women in Tara’s firm is different from 30%. First, specify the competing hypotheses to test this belief.
	H0: p = 0.30; HA: p ≠ 0.30 H0: p ≥ 0.30; HA: p < 0.30 H0: p ≤ 0.30; HA: p > 0.30

a-2.	Calculate the value of the test statistic. (Round your answer to 2 decimal places.)

Test statistic

  

	The p-value is:
	p-value < 0.01 0.01 ≤ p-value < 0.025 0.025 ≤ p-value < 0.05 0.05 ≤ p-value < 0.10 p-value ≥ 0.10

a-3.	Interpret your results.

(Click to select)RejectDo not reject H0. At the 5% level of significance, the proportion of women in Tara’s firm (Click to select)cancannot be shown to be different from 0.30.

b-1.	At the 5% level of significance, determine if the proportion of non-white employees in Tara’s firm is less than 50%. First, specify the competing hypotheses to test this belief.
	H0: p = 0.50; HA: p ≠ 0.50 H0: p ≥ 0.50; HA: p < 0.50 H0: p ≤ 0.50; HA: p > 0.50

b-2.	Calculate the value of the test statistic. (Round your answer to 2 decimal places.)

Test statistic

  

	The p-value is:
	p-value < 0.01 0.01 ≤ p-value < 0.025 0.025 ≤ p-value < 0.05 0.05 ≤ p-value < 0.10 p-value ≥ 0.10

b-3.	Interpret your results.

(Click to select)RejectDo not reject H0. At the 5% level of significance, the proportion of non-white employees in Tara’s firm (Click to select)isis not less than 0.50.

Answer 1

Sol a) 0 num, he、 2) Given 0-3-o.3 50 p-value. 3o test statistic p(-P)