I'm not sure in which topic to put this question... but here goes.
I want to make a test (a MBTI one indeed).
I want to put it on my website. If necessary, I'll use a link, but I'd prefer to incorporate it into my website.
I want to use questions with five answering possibilities: "absolutely not", "not really", "neutral", "rather yes" and "absolutely yes". These should score -2, -1, 0, 1, 2 points towards a trait. (eg. J, then "Minus J" = "P"). Of course, if I can use 1, 2, 3, 4, 5 instead that's not a problem.
I want to show the result in two different ways: the type and the percentages.
You are an ESTJ. [description]
You score 30% E, 50%S, 40%T and 20% J.
You are an ENTP [description]
You score 30% E, 50%N, 40%T and 20% P.
- OR -
You score 30% E, -50%S, 40%T and -20% J. (but preferably the former... I don't want to curse the INFPs with totally negative results )
I've created the test already in Excel.
Any ideas how to do it?