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…
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…