Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > 7. Price Indexes > mmLASP, Laspeyres Price Index

Business Formulas

mmLASP, Laspeyres Price Index

Category: Pricing

A price index computes a sum of quantity-weighted prices for the current period and relates that sum to a similar sum for the base period.

Business analysis formulas for Excel. Marketing tool for professionals

Syntax

mmLASP(Price_Old, Price_New, Quantity_Old)

Price_Old The price of the previous time period
Price_New The price of the last time period
Quantity_Old The quantity of the previous time period

Example

See example file Business Formulas.xls, sheet mmLASP.

Business analysis formulas for Excel. Marketing tool for professionals

Related functions
  • mmPAASCHEP
  • mmEDGEP
  • mmFISHERP
  • mmLASQ
  • mmPAASCHEQ
  • mmEDGEQ
  • mmFISHERQ
Related MM4XL software tools
  • Differential Semantic
  • Smart Mapping
Source
Heinz Kohler, 2002, Statistics for Business and Economics
Lifetime license:
MM4XL All Tools
Price: euro 238.00

Vote this tool
403 votes: vote vote vote vote vote
5 stars:
145
4 stars:
187
3 stars:
61
2 stars:
8
1 star:
2
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: