Ok, i fixed the totals.

2004 2005 2005 Distribution % Change Weight
AB 182 268 11% 47% 5.2%
MB 1,285 1,295 53% 1% 0.4%
SK 784 887 36% 13% 4.8%
TOTAL 2251 2450 8.8% 10.3%

8.8% still does not equl the sum of the weighted percentages 10.3%
Is should equal my total % change right?

"joeu2004" wrote:

On Feb 8, 9:34 am, Jessica wrote:
I need to weight my percent of change by province. E.g.
2004 2005 2005 Distribution % Change Weight
AB 182 268 6% 47% 2.8%
MB 1,285 1,295 29% 1% 0.2%
SK 784 887 20% 13% 2.6%
TOTAL 4255 4455 4.7% 5.7%

[....] why doesn't my weight formulas add up to total % change
4.7<5.7?

Mostly because AB+MB+SK does not equal TOTAL. Either you have a
computation in those columns, or there are categories contributing to
TOTAL that you have not included in the table above.

Oh, I think I see your problem: your TOTAL includes the year title,
2004 and 2005 respectively. The correct totals are 2251 and 2450. So
you total change is about 10.9%.

Of course, changing the totals affects the "distribution" (proportion)
and weighted averages. But using the numbers above, it appears that
your "distribution" and "weight" formulas are correct.

So if you fix the TOTAL formula, I think everything will work out --
especially if you fix the format so that it consistently shows tenths
of a percent.

HTH.