quota sampling formula Hello all! I need help with the appropriate excel formula

Question

quota sampling formula
Hello all! I need help with the appropriate excel formula to enter into c11 and F11 and C 21 and F 21. My numbers are not coming out right. They should show the second photos numbers. Thank you. 100000 5% 3 Population 4 Quota 7 Number of people in each category Male 55% Female | 45% Social class A 300% 500% | 20% | 30% | 50% | 20% |TOTAL 1 11116-29 i 12 30-44 13 45-64 14 65 and over l 15 25% 30% 15% TOTAL 17 Number of people to be surveyed in each category 18 19 Male | 55% Female 45% Social class A C A 30% | 50% | 20% | 30% | 50% | 20% |TOTAL | 21 16-29 2230-44 | 23 45- 64 24 65 and over | 25% 30% 30% 15% TOTAL 25 27

Explanation / Answer

The correct formula to put in C11 is =$B$3*$D$8*C$10*$B11

For F11 is =$B$3*$G$8*F$10*$B11

For C21 is =$B$3*$B$4*$D$18*C$20*$B21

For F21 is =$B$3*$B$4*$G$18*F$20*$B21

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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