Uncategorized

LinkedIn Post – Survey Data Entry and Analysis Using Excel

Previous posts showed how to use Splitter to analyze survey data in Excel downloaded from Google Forms or exported from Survey Monkey. Splitter can also handle survey data entered in Excel from survey using pen paper, ie row for respondents and column for question answers. For multiple answer separate each answer with a comma sign-within the column question, Data entered can be ‘code’ that is number representing text, text (such as in other mention or open question), mixed or numeric.

The link post on LinkedIn here.

Comments Off on LinkedIn Post – Survey Data Entry and Analysis Using Excel
October 21, 2018
Uncategorized

LinkedIn Post – Splitter Handles Survey Monkey Data

In previous post, Survey Monkey survey data in Excel is rearranged to follow Google Forms format to allow Splitter to do deep dive. One of Splitter key function is to handle question with multiple answers. It splits multiple values/contents in a cell by splitting it into its individual value/content. Google Forms uses comma sign to separate each answer in multiple answer question. And since we also use comma the same way in writing, ie to separate clauses/items (I like the brand because price is cheap, good build quality, large screen, upgradable OS, long battery life), Splitter can be used to analyze open end question.

The link post on LinkedIn here.

Comments Off on LinkedIn Post – Splitter Handles Survey Monkey Data
October 21, 2018
Uncategorized

LinkedIn Post – Survey Monkey and Google Forms Excel Data Format

In Survey Monkey website, there is an example of Survey Monkey survey raw data exported to Excel, a copy can be downloaded here. As mentioned in previous post, question with multiple answer is the main reason you can not use Pivot Table, notice that question with multiple answers are separated into multiple column, the common survey data format in Excel. Had the survey been conducted using Google Forms, the format would’ve looked like a file in my comment. Notice the difference. So if you are using other online survey platform, you need to rearrange the Excel data to follow that of Google Forms in order for Splitter to analyze.

The link post on LinkedIn here.

Comments Off on LinkedIn Post – Survey Monkey and Google Forms Excel Data Format
October 21, 2018