Continuing previous post on survey data in Excel, Splitter provides functions to help identify error in the data in order to clean it. The video shows how to clean survey data in Excel using example from the last post.
The link post on LinkedIn here.
Following up last post on survey data entry in Excel, where data entered can be ‘code’ that is number representing text, text or numeric. Now on numeric coding for analysis by Splitter. Numeric answers need to be ‘coded’ first by specifying what interval of values (less than/between/more than/equal to) to use, later these intervals are used by Splitter as categories. Multiple values in a cell is allowed, just separate each numeric value with a comma sign.
The link post on LinkedIn here.
Question with multiple answers is the main reason why Pivot Table can not be used to analyze survey data in Excel. Common data format in Excel is to separate the multiple answers into multiple columns, requiring complicated formula for calculation, if Excel is used for analysis at all. Google Forms data format is unique and much simpler actually, that it put all answers for a question into one column whether it is a single answer or multiple answers. We have developed Splitter, an Excel add in program, that works just like pivot table to analyze survey data in Excel with format following that of Google Forms.
The post link on LinkedIn here.