mytest > help > Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > 4. Opportunity Index > mmCDI, Category Development Index

Business Formulas

mmCDI, Category Development Index

Category: Reporting > Market Models

The Category Development Index quantifies the sales performance of a product category within a given group of customers compared to the average performance among all consumers.

Business analysis formulas for Excel. Marketing tool for professionals

Syntax

mmCDI(Area_Size, Area_Value, Optional Total_Size, Optional Total_Value)

Area_Size The number of residents in a geographic area
Area_Value The total sales of all brands by geographic area
Total_Size Optional - The total number of residents in all geographic areas
Total_Value Optional - The total sales of all brands in all geographic areas

When any Optional value is missing the total column is set equal to the sum of the values in the range.

Example

See example file Business Formulas.xls, sheet mmBDI-mmCDI-mmMOI.

Business analysis formulas for Excel. Marketing tool for professionals

Note: This is an Array Function (curly brackets { } ). To enter an array function: (1) select the range where you want to enter it, for instance, F26:F28; (2) type the formula; (3) press CTRL+SHIFT+ENTER.

Related functions
  • mmBASS
  • mmBDI
  • mmBEI
  • mmBEP
  • mmBEPR
  • mmEI
  • mmHERF
  • mmMOI
  • mmPERFCV
  • mmPERFO
  • mmPERFR
  • mmREBUY
  • mmREBUYS
  • mmPRESS
Related MM4XL software tools
  • BCG Matrix
  • Profile Manager
  • Gravity Analyst
  • Smart Map
  • Differential Semantic
Source
Luiz Moutinho, 1991, Problems in Marketing
Paul Farris, 2006, Marketing metrics: 50+ metrics every executive should master
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: