View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jetlag Jetlag is offline
external usenet poster
 
Posts: 2
Default Reading results for automated Myers Briggs Type Indicator?

I have been trying to automate the Myers Briggs Type Indicator and can read
the results based on numerical input. The results, individual cells, look
like this example:

I Total = 25, E Total = 15
N Total = 25,S Total = 15
T Total = 10, F Total = 30
P Total = 30, J Total = 10

This means that the person has a stye type of: INTP

How can I convert the raw numerical data to display the alpha combination.
There are 16 possible permutations as follows (Depedent on the high scores).

ESTP, ESTJ, ESFP, ESFJ, ENFP, ENFJ, ENTP, ENTJ,
ISTJ, ISTP, ISFJ, ISFP, INFJ, INFP, INTJ, INTP