Statistics and Excel
if your "baskets" are well defined in both the laspeyeres and Paasche
scenereos,
=sum(basket2)/sum(basket1) on each set of baskets will do the job
and the fisher index is the just the square root of the product of the other
2.
"James7100" wrote:
Hi
I'm starting on a course in statistics and we have to do a lot of index
numbers. Now Excel is good at this as long as the indexes are simple.
But I can't figure out how to do Laspeyres, Paasche and Fisher indexes using
Excel. Any Ideas?
:-) Klaus
|