OppScore

Yet another R script for calculating opportunity scores and plotting the Opportunity Map / Landscape.

UPDATE: OppScore calculation was yielding wrong values! It's fixed now.

This one does not require anything beyond base R. A sampledata.csv file is included for testing purposes.

How to use:

1. Format your data as a CSV file. It should have at least 3 columns: outcome, importance and satisfaction. Additional columns will be ignored. Here is an example of how your .CSV file should look like:

*subject	outcome	importance	satisfaction
student1	Passing exams	5	3
student2	Passing exams	4	3
student3	Passing exams	5	2
student1	Hiding from professors	4	4
student2	Hiding from professors	2	1
student3	Hiding from professors	2	3
student1	Getting submission accepted	5	2
student2	Getting submission accepted	5	3
student3	Getting submission accepted	4	5
...	...	...	...

(*the "subject" column will be ignored)

3. Optionally, if your input scale is not 1-5, modify the midpoint parameter in the script. It should be equal to the middle point of the scale. E.g., for a 1-5 scale midpoint should be 3. If your scale is 1-7, then it should be 4 and so on. (Values above the midpoint parameter (either importance or satisfaction) will be considered positive. This is an important consideration when computing the score. Note that using a scale other than 1-5 deviates from Ulwick's recommendation.)
4. Make sure the data and the script are in the same folder.
5. Run the whole script. Voila.

References:

• Ulwick, Anthony. What customers want. McGraw-Hill Professional Publishing, 2005. This is the main source for the Opportunity Score method.
• Function to round numbers in data frame that contains non numeric data by Jeromy Anglim.