Saya ingin berbagi pengalaman menggunakan ChatGPT 3.5 (free version, sekarang sudah diperbarui lagi menjadi GP4.o mini di Sept 2024)) untuk data cleaning pada data survey dengan pertanyaan open-end tentang merek (brands). Data mentah ini diambil dari Excel (download as Excel dari survey menggunakan Google Forms). Karena pertanyaan tersebut open-end dimana responden menuliskan jawaban mereka sendiri,…
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…
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
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
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
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
Text coding using Splitter on Open End Questions – Survey Data in Excel Video 2/6 : Reasons to Choose Brand (milk) Raw data can be downloaded at www.maxiresearch.com
Text coding using Splitter on Closed End Questions – Survey Data in Excel Video 1/6 : Scaling Questions. Raw Data can be downloaded at www.maxiresearch.com