I can't figure out the formula to use for this question. I am looking at Cost per capita, which means per capita costs divided by the population. The population figures are 16,974, 18,698 & 19,151. The actual cost figures are $70,258, $136,304 & 238,041. what type of formula do I use when pop figures are listed in cells b1:b3 and cost figures are listed in A1:A3. Any help would be appriciated.
2006-09-22 04:09:11 · 4 answers · asked by mnb231 1 in Science & Mathematics ➔ Mathematics
For any one pair = A1/B1
For the whole = SUM(A1:A3)/SUM(B1:B3)
2006-09-22 04:12:48 · answer #1 · answered by Anonymous · 0⤊ 0⤋
For each pair:
=A1/B1; = A2/B2; = A3/B3
For the average cost per pop:
=SUM(A1:A3)/SUM(B1:B3)
2006-09-22 12:33:47 · answer #2 · answered by oldprof 7 · 0⤊ 0⤋
Do you want each pop and cost separatley or as a total pop and cost. I'll give you both:
Separate
=sum(a1/b1) =sum(a2/b2) =sum(a3/b3)
Total
=sum(a1+a2+a3/b1+b2+b3)
2006-09-22 11:19:36 · answer #3 · answered by Anonymous · 0⤊ 1⤋
1st ... don't list in a1 .. start in b2 to allow you to add heading or column identification ....
in the first line ... you would set up formula for division by entering (i'll do it for your cells) cost per capita is cost / pop .....so c1 is "=(a1/b1)" c2 is =(b2/c2) and so on
2006-09-22 11:18:29 · answer #4 · answered by Brian D 5 · 0⤊ 0⤋