5 Replies Latest reply on Jun 28, 2017 7:51 PM by PaulKneipp

# Analyse a multiple choice quiz

I have been given a very challenging job - I'm not feeling too confident about it actually but I'm giving it a go. A colleague gave me a task which he used to do in Excel - analyse the results of a multiple choice quiz. I'm starting with the simple part - display a graph for some of the key questions which shows the percentage of responses in a data set for each of the answer options. The answers are represented as 0,1,2,3, 4; or no answer. I need to sum the number of times each option appears, then display as a percentage. I've done an exercise which summarises a percentage of sales for each sales person; but that obviously adds the numbers, not their occurrences. I've searched but obviously not searching the correct terms. Any clues much appreciated. Thanks very much.

• ###### 1. Re: Analyse a multiple choice quiz

And how is the data organized into records and fields?

Assuming that your data model is similar to your sales chart excersize, it might be very close to what you need. There are summary fields and aggregate functions that can count records instead of summing them.

• ###### 3. Re: Analyse a multiple choice quiz

Thanks. I've attached a picture of the data and what I need to do. I see that a summary field can do a count of a field. But how do I go about counting the number of times each answer appears for each question? In the bottom graph, R1 etc stands for Result 1.It  shows that in the stage (year) 73.91% chose R3. School would obviously be a larger data set.

• ###### 4. Re: Analyse a multiple choice quiz

It's all in how you organize your data into tables, records, fields and link them in relationships.

Test----< Questions------<Responses>-----Test Taker    (----< means a "one to many" relationship)

would put each response in its own record linked to both the question it was given in response to and linked to a record of the person answering the question. Then "count of" summary fields and aggregate functions can be used to count the number of times a given value was given in response to a question by counting the records with that value.

• ###### 5. Re: Analyse a multiple choice quiz

Of course. It's always the relationships! Thanks, I'll start there.