Similar Posts
Survey Data in Excel
To learn more about how survey data looks in Excel from survey using Google Forms, here is an excel file from a beverage study. Survey data in spreadsheet from survey using Microsoft Forms is slightly different on multiple answer questions (discussed on previous post).
TES PRODUK – TEH TUBRUK
Kuesioner ini mengenai tes produk untuk produk teh tubruk. Dibuat di Google Forms yang boleh Anda copy ke GDrive Anda. Ada 3 produk yang dites, dicoba secara blind (tanpa informasi merek), Sequential Monadic (Dicoba satu persatu) dengan Rotasi (urutan produk dicoba bisa berbeda antara responden satu dengan yang lain). Di sini kami menggunakan fasilitas ‘branching…
LinkedIn Post – Google Forms + Splitter
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…
Evaluasi Iklan Cetak – Hutan Hujan
Kuesioner ini mengenai evaluasi iklan cetak (print ad) untuk meningkatkan awareness publik mengenai isu hutan hujan (rain forest). Kita ingin menggali respon publik terhadap iklan ini. Untuk melihat klik di sini, untuk meng-copy klik di sini.
Ground Coffee: Brand, Usage, Image Study
The questionnaire is about brand, usage and image on ground coffee products in Indonesia. To view click here, to copy click here.
LinkedIn Post – Survey Monkey and Google Forms Excel Data Format
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…