mytest > help > Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > 5. Performance Ranking > mmPERFR, Relative Performance Rank

Business Formulas

mmPERFR, Relative Performance Rank

Category: Reporting > Ranking

The Relative Performance Rank index returns the ratio of the Overall Performance Rank to the Average Overall Performance Rank.

Business analysis formulas for Excel. Marketing tool for professionals

Where:

PERFR = Relative Performance Rank
PERFOi = Overall Performance Rank of brand i
Business analysis formulas for Excel. Marketing tool for professionals
PERFO = Sum of all Performance Ranks of all brands
N = Number of brands

Syntax

mmPERFR(Input_Number, Overall_Performance)

Input_Number The performance rank of a brand or item on an attribute
Overall_Performance The performance rank of all items on an attribute

Example

See example file "Business Formulas.xls", sheet "mmPERFR".

Business analysis formulas for Excel. Marketing tool for professionals

Related functions
  • mmDBAVG
  • mmDBCOUNT
  • mmDBSUM
  • mmEI
  • mmPERFCV
  • mmPERFO
  • mmAUC
  • mmBDI
  • mmCDI
  • mmHERF
  • mmMOI
  • mmPRESS
  • mmRANK
Related MM4XL software tools
  • Quality Analyst
  • BCG Matrix
  • McKinsey Matrix
  • Profile Manager
  • Descriptive Statistics
Source
Roger J. Best, Market-Based Management. Strategies for growing customer value and profitability
Lifetime license:

Price: euro

Vote this tool
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: