Thread: Turning multiple choice answers into graph

Hi my student took a multiple choice exam and i am trying to turn their answers into a graph.

I have a chart with their names, student numbers, and the letter they chose for every question on the exam that they answered. Now what i want to do is to be able to look at a table or chart that depicts the choices made for question 1, question 2, etc.

For example.

Question 1 - Answer "A" chosen by 10% of student, Answer "B" chosen by 90% of students, etc.

Or something similar. I just want to know the frequency of each choice for each question. Thanks.

http://www.uploading.com/files/GIGJG...sults.xls.html

On a new sheet in your data file enter the question numbers in row 1 B:AO
In column A A2:A5 enter the Grade letter.

in B2 enter this formula and then copy it across and down.

=COUNTIF(Answers!C$2:C$129,Choice!$A2)/ROWS($2:$129)