I am trying to make a algorithm that can convert between dichotomy and small group scores.

I'm imagining each item can be answer 1 for yes, -1 for no, and 0 for unsure, with gradation in between

Score for Extrovert % Chance of being an extrovert % Chance of being an introvert
1 100% 0%
.5 75% 25%
0 50% 50%
-.5 25% 75%
-1 0% 100%

The same scoring system is used for the small groups

I've hacked together something that works pretty well in excel, but I know the statistics are wrong, and you can input the small groups in a way that cannot be described by dichotomies. If anyone knows how to fix this, let me know

This is the excel file. It also works if you open it in google docs
https://drive.google.com/open?id=1gi...WquGV1cHTmIAAc