How to Analyze 1/0 coded [KoboToolbox] Multiple Response Survey Data in Excel Pivot Table

Поделиться
HTML-код
  • Опубликовано: 4 окт 2024

Комментарии • 16

  • @MSurveyPoint
    @MSurveyPoint  Год назад

    Connect with me if you need support on the following services
    Email: msurveypoint@gmail.com
    Book appointment here 👉 calendar.app.google/MMasAbZPDuwCCux76
    1. Survey questionnaire design
    2. Online survey scripting
    3. Survey data Analysis
    4. Research report writing
    5. Data analysis in Excel
    6. Survey Dashboard in Excel
    7. Survey Dashboard in Power Bi
    The scope of my services includes but not limited to the areas of Market Research, Customer Experience Research, Product Research, User Experience Research, Employee Engagement Surveys, NPS, CSAT & Voice of the customer, Monitoring & Evaluation, etc.

    • @denisdeusdedith5849
      @denisdeusdedith5849 Год назад

      Hello, thank you so much for this useful tutorial. But for me I have faced one challenge that when I do all the process and paths you have gone, finally I get all responses having the same counts

    • @MSurveyPoint
      @MSurveyPoint  Год назад

      @@denisdeusdedith5849
      Sorry to hear it doesn't seem to work for you. I suggest you review the structure of your data, and analytical steps.
      Also, as you have booked my calendar, I will take a closer look at the data with you and assist appropriately.

  • @homsnour641
    @homsnour641 27 дней назад

    Thank you so so much, it is very helpful

  • @ahmedabdulahimahamud3272
    @ahmedabdulahimahamud3272 Год назад

    Very very awesome, this is a simple way of analyzing multiple response, thank you so much, kindly include with other variables

    • @MSurveyPoint
      @MSurveyPoint  Год назад

      Hi Ahmed. That is now covered here ruclips.net/video/WX5hLOfC1R0/видео.html

  • @abdul-wahabinusah3340
    @abdul-wahabinusah3340 Год назад

    This is what I have been waiting for.

  • @shohratnaghiyeva3794
    @shohratnaghiyeva3794 Год назад

    So helpful, thank you so much

  • @julianasimte3712
    @julianasimte3712 6 месяцев назад

    Is the close and load to pivot an option available only on certain devices?

    • @MSurveyPoint
      @MSurveyPoint  6 месяцев назад

      Hi Juliana
      You should see that once you load your data to power query.
      Not sure. But should be available in Excel 2016 and later

  • @KizitoChawinga-l4w
    @KizitoChawinga-l4w Год назад

    So does this mean if i have say 5 multiple response questions i'll need to follow procedure for each one of them and do them separately?

    • @MSurveyPoint
      @MSurveyPoint  Год назад +1

      Hi Kizito.
      Thanks for the question. Yes.
      I have covered that for 3 multiple response question in this video. In such cases, make sure to delete columns you do not need for analysis (or data segmentation) in each unpivoted table to manage the model size, especially for large sample sizes.
      ruclips.net/video/WX5hLOfC1R0/видео.html

    • @KizitoChawinga-l4w
      @KizitoChawinga-l4w Год назад

      @@MSurveyPoint Okay, understood
      Your help is much appreciated.

  • @MSurveyPoint
    @MSurveyPoint  Год назад

    Check out these videos on multiple response survey data
    1. How to Analyze Space-separated Multiple response Survey Data in Excel Pivot Table:
    ruclips.net/video/JJjM2MpW0lw/видео.html
    2. How to Analyze Columns-separated Multiple Response Survey Data in Excel Pivot Table:
    ruclips.net/video/Uman2Q4laBE/видео.html
    3. How to Analyze TRUE/FALSE coded Multiple Response Survey Data in Excel Pivot Table
    ruclips.net/video/xUY2rJddT3E/видео.html
    4. How to Analyze Yes/No coded Multiple Response Survey Data in Excel Pivot Table
    ruclips.net/video/_e_RX4e2Y5w/видео.html

  • @MSurveyPoint
    @MSurveyPoint  Год назад

    Cross-tabulation of multiple response survey data in Excel Pivot Tables
    ruclips.net/video/WX5hLOfC1R0/видео.html