Section Questions and Get Each Section's Average

Hello, I am impressed by your site and style. However, my need is to create a diagnostic questionnaire, with about 40 questions separated into 8 thematic sections of 5 numerical rating questions (1-5) each . I then need a report to collect and average the responses so that I have the individual responses as well as the mean for each thematic section as well as a mean of all of the questions. I was not able to discover if your system can do this. Can you provide me some guidance? Do you have any templates similar to this process, which is quite common for diagnostic questionnaires. Thanks, Steven

Hi Steven,

Thanks for reaching out to Jotform Support. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

Let me help you with that:

You can create your diagnostic questionnaire in Jotform by organizing your 40 questions into 8 sections using page breaks or section collapse elements. Use numerical rating fields like Scale Rating or Input Table for the 1-5 rating questions.

For reporting, Jotform Tables allows you to summarize and group responses. You can generate automated reports that show individual answers and calculate averages for each thematic section and overall. The Reports feature updates automatically as new submissions come in.

This setup will give you both detailed individual responses and summary statistics for your diagnostic questionnaire.

Give it a try and let us know how it goes.

Best regards,
Jotform Support

Seems like it might be possible, but I need more details on how I actually do it, as it is not clear in the program.

Hi Steven,

Yes, this is possible with Jotform. We can use Scale Rating Properties and Reports getting the total answer per question. Let me show you how to do it:

1. In Form Builder, click on Add Element on the left side of the screen.
2. Add the Section Collapse and Scale Rating Properties in your form.

Check out the sample form:

After that, you can easily create pie charts with your form data in Jotform Tables by adding a new tab. Let me show you how:

1. In Jotform Tables, click on the Add Tab at the top of the page next to your tabs.
2. In the window that opens, click on Reports, then click on Next.
3. Choose the form that you want to create a report view for, and then click on Next.
4. Select one of the three options based on how much data you want to display, then click on Next.

Now, the report is created. Next, we should change the chart type. Let's do it:

1. Scroll down in your report and select your chart.
2. Then, click on the Gear icon on the top-right side of your chart.
3. In the menu on the right side of the page, you can select Pie in Chart Types and that's it.

We also have a detailed guide about How to Create Automated Reports in Jotform Tables that you can check out. You can check out this Demo Form so you can try it by yourself. If you want to clone the form, we've got a guide about How to Clone an Existing Form From a URL that will help you do it.

If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?

Give it a try and let us know how it goes.

Thanks for the email, but actually the hard part which I really don’t get yet is how to take the answers the questions and create a report which takes an average by section (i.e. the average note of five questions) and displays each individual question response, the avg of each section and the overall average response score. I actually have an excel which does all of this. Steve
...

Hi Steven,

I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

Thanks for your patience, we appreciate it.

Hi Steven,

You can use the Form Calculation widget to get the average of questions under each section. Let me walk you through it:

1. In Form Builder, click on Add Element in the upper-left corner of the page.

2. Go to the Widgets tab, and select Form Calculation from the options.

3. Add the label as needed, and click on the Wand icon on the right to open the Widget Settings panel.

4. On the panel, click on the f(x) button in the right corner, and search for Average or avg().

5. Set the formula as shown in the screencast below, and click on Save at the bottom.

Here's a screenshot of the formula or calculation you need to set up:

You can then add and set up another Form Calculation widget for each section. Now, let me walk you through setting up a Visual Report for your form:

1. On your My Workspace page, select the form, and click on Reports in the upper part of the page.

2. Click on the Add New Report button.

3. Select Visual Report from the options.

4. Enter your desired Report Name, and select Extended Report from the options on the modal.

The report will show you each question's responses, as well as the average of each section. Check out the screencast below:

Alternatively, instead of creating a report, you can achieve what you need with the help of the form's Jotform Tables. Let me show you how:

1. On your My Workspace page, select the form, and click on Submissions in the upper part of the page.

2. In Jotform Tables, scroll to the right side of the table, and click on Add to add a new column.

3. On the modal that pops up, go to the Formula tab.

4. Select Advanced Formula from the options, and click on Next at the bottom.

5. Enter your desired Column Name, and click on Next at the bottom.

6. From the options on the bottom-left, select the Form Calculation widget for Section 1.

7. Click on Create Column at the bottom.

8. On the newly added column, click on the Three Dots icon, and select Add Summary from the menu.

9. Select Avg from the options.

The average should display at the bottom part of the column. Take a look at the screenshot below:

Give it a try and let us know if you need any other help.

Great thanks Eliza, I will give it a try.
...

Hi Steven,

I’ve gone ahead and moved your other question to a separate thread to keep things tidy, and someone from our Support Team will help you out with it here.

Let us know if you have any other questions.