AnsweredAssumed Answered

Analyse a multiple choice quiz

Question asked by PaulKneipp on Jun 28, 2017
Latest reply on Jun 28, 2017 by PaulKneipp

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.