AnsweredAssumed Answered

Scoring Exam: Correct answer and other response frequencies

Question asked by VeronicaChavez_1 on Dec 18, 2013
Latest reply on Dec 18, 2013 by philmodjunk

Title

Scoring Exam: Correct answer and other response frequencies

Post

     Hi all.

      

     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

      

Outcomes