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…
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…
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…
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…
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…
Umumnya isi utama dari Employee Survey adalah pertanyaan yang menanyakan opini responden yang dijawab menggunakan skala seberapa setuju (contoh: dari Sangat Tidak Setuju ke Sangat Setuju) terhadap kumpulan atribut. Jumlah atribut bisa berkisar antara 40-50, kemudian atribut yang memiliki aspek sama (misal mengenai kerjasama, gaji & benefit, komunikasi, dll) dikelompokkan agar memudahkan saat pengisian. Idealnya…
Typical main content for employee survey is questions asking respondent opinion using degree of agreement format (strongly disagree to strongly agree) towards set of attributes. The number of attributes can be around 40-50 and attributes of similar aspects (teamwork, pay & benefit, communication etc) are grouped to make it easy for respondents to fill out….
Here we have example of raw survey data (individual responses) from Survey Monkey and the same data in Google Forms format. Survey monkey data download here, in Google Forms format download here. If you have survey data from Survey Monkey or other online survey platform and wants to do in-depth analysis using spreadsheet, you’d want…