Calculating PCI2 in Excel

PCI2 Excel has 2 input forms and 1 results form

On Form 1, specify:
Scale type (e.g., Bipolar, Unipolar)
Scale width (i.e., minimum & maximum scale values)
Distance function (i.e., D1, D2, or D3)
Power function (default = 1)
Number of simulated replications (default n = 400)

On Form 2, input observed frequency distribution

Download the Excel workbook Potential Conflict Index version 2.0

Be sure to enable macros when you open the workbook