How to Use Pivot Tables for Survey Data! 🔥 [EXCEL TIPS]

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

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

  • @yerfillag
    @yerfillag 9 дней назад +1

    THANK YOU!! I'm working with pivot tables for the first time and have been struggling to find instructions on how to best use it with text-only values

    • @SpotlightImpact
      @SpotlightImpact  9 дней назад +1

      Yay! I'm glad you liked it. I hope you'll share and subscribe.

  • @karenwillard-xh5fb
    @karenwillard-xh5fb 6 месяцев назад +2

    Thank you for this video! You helped me get some attendance data sorted for work. I really appreciate it!

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

      Yay! I’m so glad it helped. I hope you’ll share and subscribe 🙏🏻

  • @bazar4764
    @bazar4764 Год назад +2

    Hi Nick! I have found all your videos so so helpful. There is no one like you on RUclips that makes data analysis make so much more sense.
    One question I have I am finding impossible to find an answer to is creating a pivot table / cross tabulating two data points with multiple responses.
    E.g. If you had a survey about peoples goals and peoples pain points with both questions having multiple response answers.
    Do you have any experience in creating a pivot table with two multiple choice questions e.g. to find out if there are any correlations between peoples goals and pain points?

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

      Thanks Bazar! I hope you’ll subscribe and share! This is a great question and one I’m not sure I have a great answer to yet. Pivot tables with questions that are multiple select or ‘select all that apply’ are tough. I usually have to make a separate pivot table for each individual response option. You could try doing something like this (video link below) but it’s not as great as an actual pivot table that will be updated directly from the data source. ruclips.net/video/ewSpGByVR7c/видео.html

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

      @@SpotlightImpact Hi Nick, most definitely subscribed already :) Okay thanks for the information. I have asked the question around quite a bit and I think from what I understand it's difficult to do within Excel and needs external software that's a bit more advanced such as SPSS to extract correlations. Nonetheless, I will check out the video you suggested and see if I can make any progress. Thanks for the reply and keep up the good work/content!

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

      @@bazar4764 yep SPSS might be your best bet! Try PSPP the free version too! www.gnu.org/software/pspp/