**PLEASE NOTE** - I am using Excel and it is CRUCIAL that I know the excel funct

Question

**PLEASE NOTE** - I am using Excel and it is CRUCIAL that I know the excel functions to discover the answers. PLEASE HELP ME UNDERSTAND THIS BY LISTING THEM!!! Finding the answer isn't as hard for me as being able to input the functions via excel. THANK YOU SO MUCH!!!!

**PLEASE NOTE** - I am using Excel and it is CRUCIAL that I know the excel functions to discover the answers. PLEASE HELP ME UNDERSTAND THIS BY LISTING THEM!!! Finding the answer isn't as hard for me as being able to input the functions via excel. THANK YOU SO MUCH!!!!

Use Excel functions, not tables or calculators, for your calculations and be sure to label each number appropriately. To get full credit for an answer, I need to be able to see the Excel functions and formulas you used. According to the U.S. Census Bureau, 43% of men who worked at home were college graduates. In a sample of 500 women who worked at home, 162 were college graduates a. Find a point estimate for the proportion of college graduates among women who work at home b. Construct a 98% confidence interval for the proportion of women who work at home who are college graduates. c. Based on the confidence interval, is it reasonable to believe that the proportion of college graduates among women who work at home is the same as the proportion of college graduates among men who work at home? Explain

Explanation / Answer

a Point estimate for the proportion of college graduates among women who work at home is x/n=162/500 0.324 b. Now n=500 so we will use z distribution Margin of Error=E=z*SEp SEp =sqrt(p*(1-p)/n) 0.020929596 z value for 98% CI is 2.33 as P(-2.33

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.