I would like to change the population and quota and have the data in the table c

Question

I would like to change the population and quota and have the data in the table change. What formula should I put in C11(F11, etc.) to drag down and over?

fx 3 Population 4 Quota 100000 5% 7 Number of people in each category Male Female 45% Social classA 50% TOTAL Age 16-29 30-44 45-64 65 and over 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 30% 30% 15% Number of people to be surveyed in each category Male Female l 45% Social class 50 20% 30% 50% 20% TAL Age 16-29 30-44 45-64 65 and over L 25% 15 % TOTAL 27 28

Explanation / Answer

The formula in C11 should be $B11*C$10

You can copy this and pull down and across C11 to E14.

The formula in C21 should be $B21*C$20

You can copy this and pull down and across C21 to E24

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---