+ Reply to Thread
Results 1 to 2 of 2

Turning multiple choice answers into graph

  1. #1
    Registered User
    Join Date
    11-06-2008
    Location
    Toronto
    Posts
    1

    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
    Last edited by aka_khan; 11-06-2008 at 01:36 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,924
    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)
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1