English / Indonesia

Paragraph Question in Google Forms for Asking List of Answers

Other than for open end question, Paragraph question in Google Forms can be used for asking list of answers. In the survey data which is available in Excel spreadsheet that would mean multiple value in a cell in which case Pivot Table would not be suitable. Splitter Excel Add-In splits that multiple values into its individual data so that data tabulation can be created. Survey data example here.

Comments Off on Paragraph Question in Google Forms for Asking List of Answers
February 18, 2023
English / Indonesia

Text Coding for Survey Data in Excel (Video 6/6) : Open End Questions

Text coding using Splitter on Open End Questions – Survey Data in Excel Video 6/6 : Dislikes aspects of (coffee milk) product. In survey question asking ‘dislikes’ similar to asking weaknesses, negatives, bad, unfavorable aspects.

Raw data can be downloaded at www.maxiresearch.com

Comments Off on Text Coding for Survey Data in Excel (Video 6/6) : Open End Questions
July 3, 2022
English / Indonesia

Text Coding for Survey Data in Excel (Video 5/6) : Open End Questions

Text coding using Splitter on Open End Questions – Survey Data in Excel Video 5/6 : Likes aspects of (coffee milk) product. In survey question asking ‘likes’ similar to asking strengths, positives, good, favorable aspects.

Raw data can be downloaded at www.maxiresearch.com

Comments Off on Text Coding for Survey Data in Excel (Video 5/6) : Open End Questions
July 3, 2022
English / Indonesia

Text Coding for Survey Data in Excel (Video 4/6) : Open End Questions

Text coding using Splitter on Open End Questions – Survey Data in Excel Video 4/6 : Dislikes aspects of (milk) product. In survey question asking ‘dislikes’ similar to asking weaknesses, negatives, bad, unfavorable aspects.

Raw data can be downloaded at www.maxiresearch.com

Comments Off on Text Coding for Survey Data in Excel (Video 4/6) : Open End Questions
July 3, 2022
English / Indonesia

Text Coding for Survey Data in Excel (Video 3/6) : Open End Questions

Text coding using Splitter on Open End Questions – Survey Data in Excel Video 3/6 : Likes aspects of (milk) product. In survey question asking ‘likes’ similar to asking strengths, positives, good, favorable aspects.

Raw data can be downloaded at www.maxiresearch.com

Comments Off on Text Coding for Survey Data in Excel (Video 3/6) : Open End Questions
July 3, 2022
Indonesia

Survey HR – Contoh NPS Score dan Alasan

Spreadsheet berikut berisi contoh raw data exercise NPS dari sebuah survey HR di sebuah perusahaan farmasi. Pada dasarnya NPS (Net Promoter Score) adalah satu pertanyaan seberapa ingin responden merekomendasikan sesuatu dengan menggunakan skala 0-10 yang kemudian nilai dari seluruh responden diolah untuk mendapatkan skor NPS dengan menggunakan formula tertentu. Untuk memperkaya analisa dapat ditanyakan mengapa memberi skor demikian. Lihat spreadsheet tersebut di sini.

Comments Off on Survey HR – Contoh NPS Score dan Alasan
April 2, 2021
Indonesia

Survey Data di Excel (2)

Untuk mengetahui lebih banyak mengenai bagaimana data survey terlihat di Excel dari survey menggunakan Google Forms, berikut contoh lain file excel tentang study kebiasaan snacking. Untuk survey menggunakan Microsoft Forms data di spreadsheet sedikit berbeda untuk pertanyaan multiple answer (dibahas di post lain).

Comments Off on Survey Data di Excel (2)
March 15, 2021
English

Survey Data in Excel (2)

To learn more about how survey data looks in Excel from survey using Google Forms, here is another excel file from a snacking study. Survey data in spreadsheet from survey using Microsoft Forms is slightly different on multiple answer questions (discussed in another post).

Comments Off on Survey Data in Excel (2)
March 15, 2021