Skip to Main Content

BUS 461: Marketing Research: Data Collection

Survey Tools

Google Forms Data Analysis

If you choose Google Forms as your method of data collection, you can easily create graphs and/or charts for your presentation and project documents.

1. When you create a Google Form, you will notice the automatic creation of Responses tab. All responses to the form will be automatically sent to this tab. To see the data in a spreadsheet, go to the Responses tab and click View in Sheets.


 

2. In the spreadsheet, you can create charts and/or graphs much in the same way you would in Excel. Select the data you want and click Insert Chart. The chart editor will open, and you can accept the default chart or make changes in the editor. 



 

When you are ready to copy and paste chart into your document or presentation, you can accomplish this one of three ways:

  1. On a PC, use the Snipping Tool (locate by typing snipping tool into the Start menu search box) to select the chart you want to showcase.
  2. On a PC, use Ctrl + PrtScn to copy your entire screen. Paste what you copied into a Word document and use Word's crop tool (right click on image and click crop symbol) to select only the portion of the image you wish to use.
  3. On a Mac, press Command + Shift + 4 and use the pointer to and select your graph. When you release your mouse, a screenshot .png file will be placed on your desktop that can be inserted into your document or presentation.

Survey Monkey Data Analysis

If you chose SurveyMonkey as your method of data collection, there is a built-in analysis feature that will provide you with charts that can be copied/pasted into your presentation and project documents. Follow the steps below for accessing this feature:
 

  1. After creating your survey with SurveyMonkey, and once responses are collected, you will see a response summary that provides details on the total number of responses and response volume by date
    survey monkey survey summary
     
  2. To view the analyzed data in graphic form, click Analyze Results from the tabbed menu.
    survey monkey analyze results
     
  3. What displays will be a graphical depiction of your response data.
    survey monkey chart

When you are ready to copy and paste chart into your document or presentation, you can accomplish this one of three ways:

  1. On a PC, use the Snipping Tool (locate by typing snipping tool into the Start menu search box) to select the chart you want to showcase.
  2. On a PC, use Ctrl + PrtScn to copy your entire screen. Paste what you copied into a Word document and use Word's crop tool (right click on image and click crop symbol) to select only the portion of the image you wish to use.
  3. On a Mac, press Command + Shift + 4 and use the pointer to and select your graph. When you release your mouse, a screenshot .png file will be placed on your desktop that can be inserted into your document or presentation.