Count the percentage of a question in excel?

  • Profile Image
    papillon88
    Asked on December 28, 2010 at 11:19 PM

    hi!

     

    I have done a survey with jotform, then i imported it in excel. And i tried to make the percentage of some answer wich the alternativ were a range from 1-5, but i dont get it.

    Can someone help me to resolve this?

     

    ThankS!

  • Profile Image
    aytekin
    Answered on December 30, 2010 at 04:15 AM

    Here is a good documentation about that:

    http://spreadsheets.about.com/od/excelfunctions/qt/average_functio.htm

    You can also use the "Visual Report Designer" available on JotForm "Report" types. It allows you to create charts and calculate average responses on surveys. 

  • Profile Image
    papillon88
    Answered on December 30, 2010 at 01:53 PM

    This link you gave me, explains how to get the average of all answer, and not the percentage of EVERY POSSIBLE answer.

    What i wanted is get the percentage. For example.

    I have a question where i can rated it with a range 1-5.
    P1 rated it with 4
    P2 rated it with 3
    P3 rated it with 1
    P4 rated it with 4
    P5 rated it with 3
    P6 rated it with 4

    I want to do the following in excel

    Rated with 4: 50%
    Rated with 3: 35&
    Rated with 1: 15%


    The "visual repport designer" is only one page and i have more than 15 answered i want to count the percentage. Wich mean that if I resize the reportage, they will be too small.

     

    I hope you understand.

     

    Thanks in advance!

  • Profile Image
    aytekin
    Answered on January 01, 2011 at 11:46 PM

    In that case, you should use Excel. I posted a link on how to find averages on it above.

    You can get an excel report in the same way you get a new report: Select your form on My Forms page, click on Reports and then click on "Add New Report". Then select the Excel option. 

  • Profile Image
    papillon88
    Answered on January 02, 2011 at 04:37 AM

    I get it my way in excel.

    Instead of Average function i used the COUNTIF(), and i got the value of amount answered. Exactly how i explained above. Then i could get the percentage.

    I'll explain so other can solve the problem if they have it.

    I have a question where i can rated it with a range 1-5.

    Field
    A1 -    P1 rated it with 4
    A2 -    P2 rated it with 3
    A3 -    P3 rated it with 1
    A4 -    P4 rated it with 4
    A5 -    P5 rated it with 3
    A6 -    P6 rated it with 4

    First. To count the number of people who rated with 4,  do the following;

    =COUNTIF(A1:A6;(4))

    You will get = 3

    If you continue with the other answer, then u marked them and choose a diagram, you will get the percentage.

     

    Thanks anyway Aytekin.

     

     

  • Profile Image
    aytekin
    Answered on January 03, 2011 at 06:46 AM

    You should be able to that with the Visual Report Builder. If you see the screenshot I posted above. You will see that there is a number near each answer. For example, do you see "Satisfied (4)". That means 4 people selected the "Satisfied" option.