1 Reply Latest reply on Dec 18, 2013 2:51 PM by philmodjunk

    Scoring Exam: Correct answer and other response frequencies

    VeronicaChavez_1

      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