Skip To Content

Analyze survey data

In the previous lesson, you submitted the HOA Emergency Preparedness survey several times in a web browser and using the Survey123 field app. Now that you've collected some survey data, you can view the results of the submitted surveys.

Analyze reports

In this section, you'll view the HOA Emergency Preparedness survey results in the Survey123 for ArcGIS website and explore its reporting capabilities.

  1. Return to the My Surveys page. (If necessary, sign in to the Survey123 website using your ArcGIS organizational account.)

    When the survey gallery page loads, notice that your survey now indicates the number of records (that is, the number of surveys that have been submitted).

    Number of survey records

  2. Click the thumbnail to open the Overview page for your HOA Emergency Preparedness survey.

    Overview page

    The survey's overview page now displays information about the survey results. The top of the overview page highlights the following key points about the survey:

    • Total number of records (surveys) submitted.
    • Total number of participants—If you were the only person who signed in and submitted sample surveys, the number of participants is one.
    • Date of the first survey submitted.
    • Date of the last survey submitted.

    In the Survey Count section, the timeline graph displays the number of surveys submitted and when they were submitted. As the survey owner (and likely member of the HOA board), you can see how many HOA members completed the HOA Emergency Preparedness survey, and when surveys were submitted the most and on which days. You'll likely see a peak on the date that you submitted several surveys (when you completed the previous lesson).

  3. Click the date range box.

    Date range options

    The timeline graph defaults to show how many surveys have been submitted since the date the first survey was submitted. You can change the timeline to show the number of surveys submitted today, the last seven days, the last 30 days, or within a specified date range.

  4. Click Clear.
  5. Scroll down to the Top Participants table.

    Here, you can see the members in your ArcGIS organization who signed in and submitted surveys, as well as the number of surveys they submitted.

    Note:

    When a publicly shared survey is submitted anonymously, a blank value will appear in the User column of the participants table.

  6. Click the Analyze tab.

    Histogram

    As noted earlier, this tab reports the results of your collected survey data. Unlike the last time you viewed this page (when no surveys had been completed or submitted), you can now see that it contains information for each of the questions in the HOA Emergency Preparedness survey.

    The survey analysis report shows responses for each survey question. This report begins with a histogram that displays the number of surveys completed over a given time period. This data is based on the answers to the date question, which was the first question in your survey.

    Note:

    If you completed and submitted several surveys in one day, you'll notice that the histogram is slightly skewed. This would not be the case in a real scenario where surveys are completed over a longer time period.

    The table below the histogram shows dates and the number of surveys submitted for each time period.

  7. Scroll down to see the responses for the next two questions, Participant Name and Participant Location.

    Notice that the tables include a row for each distinct word from the responses. For questions that require participants to type a text response, the report counts the total number of instances of each word. When 20 or more surveys are completed and submitted, the Analyze tab generates a word cloud that shows the frequency of words in the text responses to find the most commonly used words.

  8. Scroll down to the next question, which asks about the participant's type of residence.

    Column chart

    For the Single Choice question type, the report generates a column chart that shows the distribution of the survey responses. You can also display the results as a bar graph, pie chart, or as points on a map.

    Table of answer statistics for survey question

    The total count for each choice appears in the table below the chart, with the percentage relative to all the survey responses. You can click Sort to change the order of the answers in the chart and the table. If an answer count is zero, you can uncheck the Empty Categories box to exclude that choice from the report. You can also hide the table, for example, if you want to print the report with only charts. Below the table, you can see how many participants skipped the question when they completed the survey.

  9. Click Pie to view the responses in a pie chart.
  10. Point to the pie segments to view pop-ups with relevant information about the chart segment.

    Pie chart with pop-up

  11. Click Map.

    Map view of answer statistics

    The survey responses display as data points on an interactive and dynamic map. You can use your pointer to interact with the map. The map shows the spatial distribution of where your surveys were submitted. A participant's location may have affected their responses to the survey, so the map view can help you discern possible patterns or trends in the data. The map includes a Legend button to show how the answers are symbolized in the map.

  12. Scroll down through the rest of the survey analysis report and experiment with the different question types by displaying the data using these various methods.

    Notice that each question displays and reports relevant summary information. Typically, for the numeric and selection question types, the report generates charts with the option to change how the data is rendered. Numeric questions provide statistics in the table, including the minimum and maximum values, average, and sum.

    Map view and table of answer statistics for a numeric question

    The analysis reports are dynamic and will update as additional surveys are completed and submitted to the ArcGIS organization.

    You can also modify which questions you see in the report.

  13. In the View Settings box, click Set Visibility.

    View Settings

    The View Settings window opens. You can uncheck boxes to remove survey questions from the report on the Analyze tab.

  14. Click OK to close the window.

    You can print a PDF document of the survey report.

  15. Optionally, click Print Current View and save the report as a PDF.

Display individual survey responses

Next, you'll explore the actual survey data.

  1. Click the Data tab.

    Data tab

    On this tab, all the submitted surveys are shown on an interactive map. The table below the map shows all the collected survey responses. One record represents a completed individual survey. The map is similar to the one you viewed previously on the Analyze tab. In this case, however, all survey results are shown in the map—as opposed to only results that were relevant to a specific question.

  2. Click a record in the table.

    Selected record in table and map

    When you select a record in the table, its corresponding point location is selected in the map. In addition, a details pane for the selected record appears next to the table. This pane displays a print view of the individual survey response and includes a button to print a copy. You can also see which member of your ArcGIS organization submitted the survey with a timestamp of when.

    Tip:

    The option to display details for an individual survey response is active by default. You can turn this option off by unchecking the Show Individual Response box (below the table).

  3. Click the X at the upper right of the Individual Response pane to close it.
  4. Click a column heading for a column that contains numeric data (such as How many people live in your home?).

    Menu for a table column

    You can sort the table in ascending or descending order by any column. For columns that contain numeric data, you can also view simple statistics, such as a sum of values or average.

  5. In the table, click Options and choose Clear Selection.

    Options menu

    The record is no longer selected in the table or in the map. You can also use the Options menu to reset the default table sort order, show only selected records, choose which columns to show or hide in the table, and center the map display on a selected record.

  6. Below the table, click the date range box.

    Date range box and options

    You can filter the table and map to show only surveys that were submitted within a specified time period.

    Next, you'll explore the survey data export options.

  7. Click CSV.

    Export options

    The survey data can be exported in one of three formats: CSV, shapefile, or file geodatabase. Once you've selected a data format, you can click Download to export the survey data.

    One thing to keep in mind is that Survey123 for ArcGIS is part of the ArcGIS platform. The survey data collected by Survey123 is stored as a hosted feature layer in ArcGIS Online. This means that the survey data can be used within other parts of the ArcGIS platform.

  8. Click Open in Map Viewer.

    A new web browser tab opens to ArcGIS Online, displaying the survey data in Map Viewer.

  9. If necessary, in the Contents pane, point to the surveyPoint layer, click the More Options button, and choose Zoom to.

    Zoom to

    The collected survey responses are shown as points in the map. You can take advantage of the display and rendering functionality of ArcGIS Online to visualize your survey results in a web map. If you're signed in to ArcGIS Online, you can also use your survey data in any of the ArcGIS client apps, such as the configurable templates, Web AppBuilder for ArcGIS, and so on.

  10. In the Contents pane, point to the layer with surveyPoint in its name (this is the layer that contains your survey data). Click the Change Style button.

    Change Style

    The Change Style pane opens. The nature of your data determines the default style suggestions for how best to render the layer. This is known as smart mapping, which helps you display your data in a cartographically pleasing way.

  11. For the drawing style, select Heat Map and click Done.

    Points rendered as a heat map

    Your collected survey data points are now rendered as a heat map. Areas with stronger colors that appear to glow hotter indicate a higher concentration of completed surveys.

  12. Close the map window and return to your survey.

In this lesson, you evaluated the collected survey results using the available reporting capabilities in the Survey123 website. You experimented with the various options for analyzing and displaying the results in charts, tables, and maps. In addition, you learned how to access and print individual survey responses and export the survey data to multiple data formats. Finally, you viewed and styled your survey results in a web map to identify where the most surveys are being submitted in the community. In the next lesson, you'll create a web app to share with HOA members so they can view the survey results in an interactive map.