Question

According to a recent Catalyst Census, 16% of executive officers were women with companies that have company headquarters in the Midwest. A random sample of 154 executive officers from these companies was selected. What is the probability that more than 20% of this sample is comprised of female employees? Please use Excel functions in your answer.

Answer 1

Using Excel<data<megastat<confidence interval<proportion

Here is the output:

Confidence interval - proportion
	80%	confidence level
	0.16	proportion
	154	n
	1.282	z
	0.038	margin of error
	0.122	lower confidence limit
	0.198	upper confidence limit

From above output we get, z=1.22

or

Z value can be obtained using formula

Now using excel command "=1-normsdist(1.22)=0.11232"

Probability(more than 20% of this sample is comprised of female employees)

0.111232437

Please do the comment for any doubt or clarification. Please upvote if this helps you out. Thank You!