What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Count the percentage of a question in excel?

    Asked by papillon88 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
    JotForm Founder

    Answered by aytekin 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

    Answered by papillon88 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
    JotForm Founder

    Answered by aytekin 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

    Answered by papillon88 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
    JotForm Founder

    Answered by aytekin 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.