Scoring Exam: Correct answer and other response frequencies
I have a test that is conducted every year to 100 participants with 230 questions.
I have a field for each of the 230 questions for each year (4 years).
Each of the 100 participants have answers in each of these fields.
I am trying to figure out a good way of scoring and finding frequencies of responses.
I can do this in excel, but would rather have it in FM.
What I want:
If the correct answer for question 1 in year 1 is "A",
I want to see the percent of the 100 people that put A;
and the percent of the 100 people that put B, C, D, or E.
I can sort the field, add trailing subgroups, and count the number of each response and give me a percentage; but I'd have to do this for 230 QuestionsX4years..
Is there a way to do this in FileMaker Pro 11?
Thanks in advance