how to analyse data from google forms

Organizing and analyzing responses
After you’ve sent your form, it’s only a matter of time before people start responding. To access these responses, simply open your form and click the Responses tab. Here, you’ll find the results from everyone who’s responded so far, along with several options.

Click the buttons in the interactive below to learn more about the Responses screen.

Using Google Sheets to organize your results
Although all of your responses can be accessed within the form itself, there may be times when it’s difficult to sort through and analyze everything. Luckily, Google Forms gives you the ability to store and organize your results in a spreadsheet with Google Sheets.

To do so, click the Create Spreadsheet icon.

This will bring up a menu where you can choose to either Create a new spreadsheet or Select existing spreadsheet. For this example, we’ll create a new one.

This automatically creates a spreadsheet and opens it in a new tab. Each row features the responses from each respondent, and each column features a question from your form.

Analyzing your results in Google Sheets
At first the spreadsheet may seem overwhelming, but luckily Google Sheets has tools to make things more manageable. We’ll go over a few useful features you can use to analyze your data.

Formulas perform simple calculations like adding and subtracting, while functions perform more complex ones like averages and counts. Let’s say you wanted to know the average rating given by employees for an event you held. You could use the AVERAGE function to calculate all of the ratings from one column.

If you’re expecting to receive additional responses, it’s best to place your formulas in a separate sheet. Any new responses will be added to the end of your current sheet, which could make it difficult to find and edit your formulas.

If your form has a large number of responses, pivot tables can help you summarize the data and make it easier to manipulate. You can go to Data > Pivot table to create one. In our example, we created a pivot table showing how many times each number was chosen for a certain question.

Histogram charts and pivot charts can also be helpful for giving you an overview of your responses. To create a chart, click Insert > Chart and select the chart you’d like to use from the Chart type drop-down list. In the example below, we made a pivot chart showing the distribution of how satisfied people were with the event.

The method you choose will depend on several factors, but all of the features mentioned above should cover most of your basic analyzing needs.
Using Forms with Google Classroom
Google Forms is typically used to create surveys, sign-ups, feedback forms, and more. It also can be used to create quizzes that you can easily incorporate into Google Classroom. There’s a variety of question types you can use to make your own quizzes, and they feature an array of customizable settings.

Watch the video below to learn more about creating and sending forms to your students using Google Classroom.

Creating a quiz
To create a quiz, you’ll first need to create a basic form. We go over this in greater detail in our lesson on creating simple forms, but we’ll cover some of the basics below.

Navigate to the Google Forms homepage, then click the Blank icon.

creating a blank form
Before writing questions and answers for your quiz, you’ll need to make some changes to the form’s settings. Click the Settings icon in the top-right corner.

clicking the settings icon
Click the Quizzes tab and toggle the Make this a quiz switch. Turning this on will make several quiz options available that allow you to choose how your students will interact with your quiz.

enabling the Make This a Quiz toggle
Click the buttons in the interactive below to learn more about the various quiz settings.

quiz settings interactive

Once you’ve chosen your desired settings, click Save. You can then name your quiz and start writing your questions. For more information on creating form questions, review our lesson on creating simple forms.

Selecting correct answers for your questions
For each question on your quiz, you’ll need to define the correct answers. To do this, click Answer Key.

clicking answer key link
This screen will appear differently depending on the question type you’ve chosen. Let’s take a look at how to choose correct answers for several popular types of questions:
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital
fundlydigital