QUESTION 7 To assess how women are doing in the workforce, we have gathered data from 120 firms with 100 to 500 employees, and have recorded how many of the top 25 highest paid employees are female. Use the data provided in T_opLS_Female.xlsx to answer Questions 7 through 12. What is the overall proportion of females in the top 25'? NOTE: Enter a numerical value only, and round your response to 4 digits after the decimal point. For example, you would enter the proportion of .34561 (equivalent to 34. 561 %) as .3456 in the box below; and .34566 {or 34.566%) as .3457. if you do not follow these formatting and rounding rules, you may not receive credit for your answer: l:l QUESTION 8 Flefer to the scenario presented in Question 7. What is the lower bound of the 95% confidence interval for the mean proportion of females in the top 25? NOTE: Enter a numerical value only, and round your response to 4 digits after the decimal point. For example, you would enter the value of .34561 (equivalent to 34.561 %) as .3456 in the box below; and .34566 (or 34.566%) as .3457. ll you do not follow these formatting and rounding mles, you may not receive credit for your answer: E QUESTION 11 Refer to the scenario presented in Question 7. What is the upper bound of the 95% confidence interval for the proportion of firms that have more than 50% female in the top 25 list? NOTE: Enter a numerical value only, and round your response to 4 digits after the decimal point. For example, you would enter the value of.34561 (equivalent to 34.561 %) as .3456 in the box below; and .34566 (or 34.566%) as .3457. If you do not follow these formatting and rounding mles, you may not receive credit for your answer: :