Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Statistics and Excel
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Statistics and Excel
"James7100" wrote...
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? Assuming this is a serious question, Wikipedia seems to provide correct definitions. http://en.wikipedia.org/wiki/Price_i..._price_indices So SUMPRODUCT is the only function needed. Laspeyres: =SUMPRODUCT(Prices_thisperiod,Quantities_baseperio d) /SUMPRODUCT(Prices_baseperiod,Quantities_baseperiod ) Paasche: =SUMPRODUCT(Prices_thisperiod,Quantities_thisperio d) /SUMPRODUCT(Prices_baseperiod,Quantities_thisperiod ) Fischer: =GEOMEAN(LaspeyresIndex,PaascheIndex) and, FTHOI, Marshall-Edgeworth: =SUMPRODUCT(Prices_thisperiod,(Quantities_baseperi od+Quantities_thisperiod)) /SUMPRODUCT(Prices_baseperiod,(Quantities_baseperio d+Quantities_thisperiod)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to install statistics add-in in Excel? | Excel Discussion (Misc queries) | |||
Statistics in Excel | Excel Discussion (Misc queries) | |||
Statistics in Excel? | Charts and Charting in Excel | |||
Please help with Statistics Formulas in Excel | Excel Discussion (Misc queries) | |||
Statistics using dates in excel | Excel Worksheet Functions |