New Podcast Episode – Diversity Index

My video “Diversity Index as Business Performance Indicator” is now added as episode #14 in my BPMSG podcast feed.

Share on Facebook

Update AHP Excel Template Version 16.10.12

Thanks to the feedback from Pascal a bug is corrected, when you select the results of individual participants in the summary sheet. Selection/display  of results from participant 4 to 7 was not shown correctly.

Please go to the AHP template download page to get the updated version (latest version 11.12.12).

Incoming search terms:

  • ahp 엑셀
Share on Facebook

Canon XA-10 Video Camera – Damage or normal?

Just now I realized a problem with my (still) quite new Cannon XA-10 camera. Obvious under low light conditions and white colored background the corners getting dark – vignetting; you see it clearly on the second picture. Of course – lens hood removed, it’s medium focal length …
Question: damage under warranty or normal?

Result from several visits and discussions with the Canon Service center in Singapore:

It is a limitation of the camera. (I would call it a design problem). Workaround: use manual focus & switch image stabilizer off (if possible use a tripod).

Share on Facebook

Diversity Index as Busines Performance Indicator – The Concept of Diversity

A business relying on a single type of product or services can be highly risky. Any change in the market place – a change of customer behavior, a new competitor – might have a high impact on the business results. Diversification is an opportunity to spread and reduce the potential risks.

The mathematical concept of diversity has many applications, ranging from ecology over demography to information science. In the context of business performance diversity indices can be used as key performance indicators (KPIs) to analyze markets, define targets for diversification, and track the success of derived business actions.

Download Presentation Slides (pdf)

See also

Video: Diversity as Business KPI – Alpha and Beta Diversity

Diversity Calculation in Excel – Diversity Indices and True Diversity

Incoming search terms:

  • Diversity & Inclusion performance indicators
  • diversity and inclusion performance indicator policy
  • diversity kpi
Share on Facebook

AHP Consistency Ratio CR

Q: I read in some texts that a consistency ratio (actually inconsistency ratio) of less than 0.1 (10%) is good. I am not sure if your consistency ratio is a consistency ratio (i.e. the higher the percentage of the CR, the better and the more consistent the results are) vs inconsistency ratio (i.e. the consistency ratio percentage in your spreadsheet should be less in order to be more consistent).

Can you please let me know if a lower of higher percentage of the consistency ratio reflects a better more consistent response? Also, how important is the CR in the interpretation of results? If two consecutive rounds of solicited info yields very similar results, would that be acceptable even if the consistency ratio may not be good?

A: The CR in my spreadsheet is exactly the same you can find in the literature. A value less than 0.1 (10%) is good, but the threshold of 0.1 is a rule of thumb . Lower values are better than higher values, but values above 0.1 can be acceptable. It depends on the nature of your project. When you process the inputs from a group (several participants), it happens that individual CRs are above 10%, but the consolidated matrix CR is ok. Please read also my comment here.

Incoming search terms:

  • consistency ratio
  • ahp consistency ratio
  • consistency ratio ahp
  • inconsistency ratio
  • ahp cr
  • explanation about consistency ratio
Share on Facebook