Cross-tabulation of multiple response survey data in Excel Pivot Tables

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

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

  • @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.

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

    I cant tell you how you have left me smiling and awed when I watch your videos. Its so easy to understand things I thought were tough when I listen to you do this! Your videos are very meticulous, clearly audible and great step by step guide. You are great!🤩🤗Thank you!❤❤

  • @Natnatnatnatnatnatnat
    @Natnatnatnatnatnatnat 4 месяца назад +1

    Thank you very much for this. It is very useful for someone with no experience in working with survey data! Please keep making more 🙏🏻

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

      ​@@Natnatnatnatnatnatnat
      Thank you for the encouragement 🙏

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

    Thanks for this great tutorial! It was so easy to understand.

  • @Laura-hw1bv
    @Laura-hw1bv Год назад

    Fantastic video! I've been struggling to combine my data in one table and this is exactly what I've been looking for.
    Bravo sir 👏

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

    Thanks for this!!! Easy to follow and clear explanation 😊

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

    All your videos are helpful for me as I work assessments, from the start I found your channel I have stopped using SPSS, by now I only use excel sheet thank you so much

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

      Many thanks for the feedback. We are happy you find this helpful. More coming up on survey data analysis using Pivot Tables

  • @lawrencekazibwe9751
    @lawrencekazibwe9751 3 месяца назад

    Thanks alot boss,it has been very informative 🎉

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

      @@lawrencekazibwe9751
      Glad this helped.
      Thanks for the feedback

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

    you are on point... exactly what i am trying to achieve....

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

      Thank you. We happy this helps.
      Kindly subscribe to support us

  • @PoulamiDatta-fm1oq
    @PoulamiDatta-fm1oq 6 месяцев назад

    can I do chi square of this multiple response survey data ??

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

      Yes. However, here the standard Chi-Square test is not appropriate since there is within group dependency as respondents had the option to select more than one item in each of the multiple response questions.
      Marginal Chi-Square test is recommended in this case.

  • @jessiki5711
    @jessiki5711 Месяц назад

    your videos are great! but I have one issue, if I go to "close & load to" it only shows me in the window of Import Data "Table" and "Only Create Connection". How can I get the option for "Pivot Table Report"?

    • @MSurveyPoint
      @MSurveyPoint  Месяц назад +1

      @@jessiki5711
      This could happen depending on the Excel version.
      You can still create Pivot Tables from there anyway. However, with few additional steps
      From there....
      Select create connect and check; add to data model.
      .. wait for it to load
      Now proceed as follows
      Insert>Pivot Tables>External connect>Select Unpivoted or data table you loaded>>add>Ok
      Then create your pivot table

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

    Hi! great video but im having trouble understanding why when I unpivot, only one of the columns of the answers is left. Could you please explain that to me? I want both answers to remain

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

      Great to know this helps.
      Please check if you have the responses of the columns you unpivoted in that single column.
      Also recheck if you selected all the columns you want to unpivot.
      Ideally, unpivoting regroups the responses in each of the columns into the values column and the column names into the attribute column.

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

      @@MSurveyPoint I did thanks! Another question if its not too much to ask, I closed the right window where the values, axis x y etc was, where I had all the info of the questions that I had unpivoted. I did some graphs and it was working but now it closed and I cant open it again. Coould you please help? Thank you again!!

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

      @@vickypereya8238
      Happy to hear it worked out
      Click anywhere in one of the pivot tables you have generated.
      >right-click and scroll down to the bottom.
      >select "Show Field list" at the bottom
      You can always hide/show the Field list pane that way.
      Please do support me by subscribing.

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

      Of course @@MSurveyPoint thank you!!!! Im sorry, a couple more questions. I have, like in your video, multiple questions (with multiple answers) I want to do other tables but when I copy the table it doesnt give me another pivot table, with the values on the right, it only copies the table. And as I am creating graphs from each table if I do it all on the same table it erases the last tables. Also, what would you do in questions where its order from most important to least important? I have in the "data base" table columns divided by answers, the first column is the most important, the one on the right the second most important etc. What would you do? If you tell me its ok, Ill write you on email. Thank yu again! ur videos are great,I will share them

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

      Hi Vicky Pereya
      I think the best will be to catch up on a call so I can get to understand the data better and the issue you need assistance with. Thanks
      Please pick a time here that works for you: 👉 calendar.app.google/MMasAbZPDuwCCux76

  • @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 comma-separated multiple choice survey data in Pivot Table:
    ruclips.net/video/kbCt-D7b6og/видео.html
    3. How to Analyze Columns-separated Multiple Response Survey Data in Excel Pivot Table:
    ruclips.net/video/Uman2Q4laBE/видео.html
    4. How to Analyze 1/0 coded Multiple Response Survey Data in Excel Pivot Table:
    ruclips.net/video/kdeT4O01nmU/видео.html
    5. How to Analyze TRUE/FALSE coded Multiple Response Survey Data in Excel Pivot Table
    ruclips.net/video/xUY2rJddT3E/видео.html
    6. How to Analyze Yes/No coded Multiple Response Survey Data in Excel Pivot Table
    ruclips.net/video/_e_RX4e2Y5w/видео.html

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

    Plprovide files.thankyu

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

      @ubaidillahmuhammad20
      Here is the sample data I used in all the videos on multiple response survey data analysis.
      docs.google.com/spreadsheets/d/1JC1NdgHubItR0vOKEP8mFiORdbNfILvu/edit?usp=sharing&ouid=117355798969062583983&rtpof=true&sd=true