How to Download & Prepare Survey Data for Analysis in Excel

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

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

  • @pdurgaanusha3578
    @pdurgaanusha3578 3 года назад +4

    Amazing Video David.
    I learned a trick while doing this kind of data processing.
    Instead of dragging you can just double click when the small plus sign appears as it did during your participant number section.
    It makes it so much easier.

    • @DavidDunaetz
      @DavidDunaetz  2 года назад

      That's pretty cool. Thanks for sharing that.

  • @itsnotmeitsyou4582
    @itsnotmeitsyou4582 6 лет назад +9

    omg! you just save my life and my semester! thank you, thank you!!!!!!!!!!!!!!!

  • @itsnotmeitsyou4582
    @itsnotmeitsyou4582 6 лет назад +5

    if this video help you please thumbs up!

  • @mrobireonomewilliams2998
    @mrobireonomewilliams2998 2 года назад +3

    Thanks for this awesome tutorial. Part 2 please

  • @janeojugo4979
    @janeojugo4979 9 месяцев назад

    perfect, you made coding so simple. Bravo!

  • @ca9404
    @ca9404 8 месяцев назад +1

    You're the GOAT.

  • @parulpopat5964
    @parulpopat5964 5 лет назад +5

    Thanks for the detailed explanation. It is indeed helpful.....

  • @missg7437
    @missg7437 4 года назад +3

    Thank you for this workshop was very very helpful!

  • @debbiegammie7537
    @debbiegammie7537 8 месяцев назад

    I am a beginner and this was perfect Thankyou

  • @mercylearns
    @mercylearns 8 месяцев назад

    Thank you so much it is so useful even in 2024!❤❤❤❤

  • @mivedi
    @mivedi 4 года назад +2

    Excellent tutorial. Thanks for educating us.

  • @soumaya8030
    @soumaya8030 26 дней назад

    Very helpful ❤

  • @hloniphalisa4632
    @hloniphalisa4632 2 года назад +1

    thank you sir this was very helpful

  • @TheExcessivemhz
    @TheExcessivemhz 6 лет назад +2

    That was helping. Thanks for uploading

  • @pratiksha5447
    @pratiksha5447 3 года назад +1

    It helped me a lot..thank you

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

    nice tutorial

  • @yosephmekonnen91
    @yosephmekonnen91 4 года назад +1

    Thank you very much !! Very helpful.

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

    thank you so much, but if you can do another video on how to use these data to do multiple regression analysis will be great

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

      Here are some of my videos on multiple regression: www.google.com/search?q=dunaetz+multiple+regression&oq=dunaetz+multiple+regression

  • @codybruh-oq5yz
    @codybruh-oq5yz 5 месяцев назад

    Hi do you know how to change this data for each question to its own dedicated pie chart?

    • @DavidDunaetz
      @DavidDunaetz  5 месяцев назад

      In general, bar charts are superior to pie charts. If you're using Google Forms, you can see that Google creates them for you under "responses." On Excel, it takes a bit of work. Here's a video: ruclips.net/video/PeSynxkJ-UI/видео.html

  • @buyayorrum1019
    @buyayorrum1019 2 года назад

    very amazing and helpful

  • @aeiou2525
    @aeiou2525 2 года назад

    How can I use data analysis if it is a subcategory?

  • @EyaLabastilla
    @EyaLabastilla 3 года назад +2

    THANK YOU!

  • @parvezmussarf6150
    @parvezmussarf6150 3 года назад +1

    Can you teach me how to Analyse Multiple choice Questions of a questionnaire and how to Analyse that Data in Excel ?

    • @DavidDunaetz
      @DavidDunaetz  3 года назад

      If you do a search for "item analysis" you'll find lots of useful information.

  • @prabunusantara
    @prabunusantara 4 года назад +1

    What about the multiple responses data? What to do about it?

    • @DavidDunaetz
      @DavidDunaetz  4 года назад

      When an item allows for multiple responses, it gets much more complicated. Each possible response needs to be coded as a binary dummy variable. For example, if you allow multiple responses for race/ethnicity (which I believe you should), you might have 5 categories: White, Black, Hispanic, Asian, other/prefer not to state. You need to treat this 5 variables if you want to test for relationships and differences: white vs non-white, black vs non-black, etc. Google "dummy variables" for more information.

    • @prabunusantara
      @prabunusantara 4 года назад

      @@DavidDunaetz hi David thanks for the answer, I've treated all responses as a dummy variabes. My questions were more about how to analyze this further, can we crosstab it or make pivot table out of it?

    • @DavidDunaetz
      @DavidDunaetz  4 года назад

      @@prabunusantara Yes, you can do both.

  • @midhunkm8632
    @midhunkm8632 3 года назад

    Is it possible to do correlation analysis from multiple checkbox data ?

    • @DavidDunaetz
      @DavidDunaetz  3 года назад +1

      It's possible, but it's a bit tricky and often not useful. To do so, you need need treat each checkbox as a separate variable. For example, if you gave four choices for a question on ethnicity (White, Black, Asian, Latino), you'd have four variables. The first would be White with two possible values: White and not-White, and so on for the next three. You can then calculate the correlation between the variable White and whatever else you've measured (you could equally do a t-test to compare the difference between Whites and non-Whites).

    • @midhunkm8632
      @midhunkm8632 3 года назад

      @@DavidDunaetz Oh..okay Thank you David 😊

  • @leenanambinga3165
    @leenanambinga3165 3 года назад

    Is there no continuation of this video? I coded the items, so what do I do next🧐? Tried creating pivot tables but still not giving me what I want.

    • @DavidDunaetz
      @DavidDunaetz  3 года назад

      This video might be useful: ruclips.net/video/_vfzjFJg7U8/видео.html . A lot depends on what your data is measuring and what your hypotheses are.

  • @krutipatel5603
    @krutipatel5603 3 года назад

    Really very helpful in my dissertation

  • @2007dodi
    @2007dodi 4 года назад

    Hi this is so helpful, how to do that in SPSS?

    • @DavidDunaetz
      @DavidDunaetz  4 года назад +2

      SPSS has many more sophisticated tools and ways of data cleaning and prep. If you want to keep it as simple as possible, export the data into an Excel file and clean it up as described in the video, and then reimport it into an SPSS file. Otherwise you can Google data clean up and preparation in SPSS for the specific functions and methods.

    • @2007dodi
      @2007dodi 4 года назад

      David Dunaetz
      thank you so much, I was planing to do that.
      Another question:
      I am doing a study about
      “The impact of fan influencers on fans purchase intention”
      And I have like 5 independent variables which are trustworthiness, authenticity..etc
      And 1 dependent variable: purchase intention
      So to analyse the data, I was thinking to do multiple regression and reliability analyses.
      So are these two enough to answer my question?
      Regarding testing hypotheses do I do it before or after the analyses, or is it part of the analyses? And can I do it in excel or SPSS?
      Thanks

  • @smartiee74
    @smartiee74 3 года назад

    Why do you put in those variables at the top? Why can't the variables directly from the questionnaire be used?

    • @DavidDunaetz
      @DavidDunaetz  3 года назад

      There are two reasons. First, often we need to combine questions to get the variable we're interested in. So if I have nine questions on extraversion, I want to label them so that they are easy to identify when I create a new column for the composite variable. Secondly, I will want to make tables of descriptive statistics, correlations, multiple regression, etc.; the column headings will appear in these tables when using the Data Analysis Tool Pak or pivot tables, so I want to have short, clear column headings.

  • @InfinitiCyberSolutions
    @InfinitiCyberSolutions 5 лет назад +2

    Is the excel or google sheet available at all? You know, for practice and such. This is really helpful

    • @DavidDunaetz
      @DavidDunaetz  5 лет назад +2

      Here's a link where you can download it. It should work: docs.google.com/spreadsheets/d/1NTVgytosVthievzAGFtscQ4g-zlp-3PSOdgrFS-GRQo/edit?usp=sharing

  • @budang8912
    @budang8912 3 года назад

    Hello just asking how do you do data analysis on that specific data. Can you do a tutorial?

    • @DavidDunaetz
      @DavidDunaetz  3 года назад

      The specific analysis depends on what you're looking for. For example, if you're looking for descriptive statistics or a table of correlations, Google my name and what you're trying to do. There's a good chance I've made a video for it. For the next step in preparing data for analysis, this video might be useful: ruclips.net/video/_vfzjFJg7U8/видео.html .

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

    Sir How can i download practice source file ?

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

      Go to the link in the description of the video. I believe there is a blue button to download the PDF.

  • @mrobireonomewilliams2998
    @mrobireonomewilliams2998 2 года назад

    I conducted a teacher's survey on google form, the students selected the teachers name and then rated 19 questions about classroom management as excellent(4), Very Good(3) etc. I want to get the number excellent, very good, etc of each question against the teacher. Please how can I go about it?

    • @DavidDunaetz
      @DavidDunaetz  2 года назад

      It sounds like you're interested in "pivot tables." There are several good videos on how to use pivot tables in Excel on RUclips which you can easily find. They're a bit complicated, so might find that it's easier to count them directly.

  • @tingchen753
    @tingchen753 4 года назад +1

    wow!!! super

  • @CarlosSantos-mz1kj
    @CarlosSantos-mz1kj 4 года назад

    Hi. Where can I follow the anslyze?

    • @DavidDunaetz
      @DavidDunaetz  4 года назад

      Here are a couple more videos that follow:
      ruclips.net/video/Pns9UhRH9ro/видео.html
      ruclips.net/video/Pns9UhRH9ro/видео.html
      You can go to the homepage of my channel and find many other videos on stats using Excel.

  • @archisharma561
    @archisharma561 4 года назад

    from where do i get codebook/

    • @archisharma561
      @archisharma561 4 года назад

      @Daviddunaetz sir please tell from where do i get codebook/

    • @DavidDunaetz
      @DavidDunaetz  4 года назад

      I've added the link to the video description. You can download load it here: www.researchgate.net/profile/David_Dunaetz/publication/346345948_Data_Collection_Exercise_Codebook/links/5fbe99b5299bf104cf796aa9/Data-Collection-Exercise-Codebook

  • @kamonasishbhattacharjee1805
    @kamonasishbhattacharjee1805 4 года назад

    Hey David! I have a data set of respondents who had participated on my questionnaire survey. The questionnaire had drop down options to choose from. Only one response is valid. In this way, I have collected 228 responses. Now how do I code it on Excel. The video here essentially shows a strategy to be followed when a Likert Scale data is available. What about coding for drop down choice options?

    • @DavidDunaetz
      @DavidDunaetz  4 года назад +2

      Hi Kamonasish. It demands on what type of data it is. If it's nominal (categorical) with more than 2 choices, it's difficult to analyze quantitatively. However, if it's ordinal, interval, or ratio data, numbers will generally work.

    • @kamonasishbhattacharjee1805
      @kamonasishbhattacharjee1805 4 года назад

      @@DavidDunaetz It is a nominal data. I trying to code each option by assigning them a number and then compute. But the issue is with Pivot tables where the values are not correctly computed and represented.

    • @DavidDunaetz
      @DavidDunaetz  4 года назад +2

      @@kamonasishbhattacharjee1805 With nominal data, you need to use "dummy variables." You can google it and find lots of information on how to use them.

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

      it's funny when you say 228 responses. I had to prepare a questionnaire project with 17,0000 responders for 50 questions. Whether is 228 or 1M, depending how it's set up, it will be a breeze.

  • @johnbullowenvbugie2884
    @johnbullowenvbugie2884 3 года назад

    wow i just saw this video in 2021 and I have been using spss please can someone point me to the rest of the videos. i cant find them on his channel

  • @maryadasharma4942
    @maryadasharma4942 4 года назад +1

    Thank you

  • @itsnotmeitsyou4582
    @itsnotmeitsyou4582 6 лет назад +2

    omg! lol yes i literally burst out laughing when you said i"I should have done that at the beginning " yes it at the beginning! lol because loosing data sucks! its so tedious! hahahahaahahahahahahahahahhahaha

  • @itsnotmeitsyou4582
    @itsnotmeitsyou4582 6 лет назад

    I already have everything into numbers form 1 to 5 1 being Strongly Disagree and 5 Strongly agree! doe sit mean i dont need to changed them to numbers?

    • @DavidDunaetz
      @DavidDunaetz  6 лет назад +1

      +alice p You are correct, if they are already numbers you don't need to change them, unless they are reverse coded. In that case, look up my video on how to unreverse reverse scored items.

    • @itsnotmeitsyou4582
      @itsnotmeitsyou4582 6 лет назад

      @@DavidDunaetz hi, thank you for responding! you have been a great help! i dropped mu stat class recently now i'm lost ! i would anyway as it was hard for me. so now i have 2 psych classes that require a research study and i'm stuck! i have ti all now i don't know how to get the info to write my report as i surveyed 80 students in financial aid delays and student success.

  • @adeshsolanki2221
    @adeshsolanki2221 4 года назад

    Hello sir
    This is really helpful.
    Can you please send me the sample coding sheet so i can code my data accrdingly.
    P.s- waiting for your reply!

  • @itsnotmeitsyou4582
    @itsnotmeitsyou4582 6 лет назад +2

    ok wheres the next video? now what? i suck at stats! i need to type my report for Monday and im stuck!!!! i need average of women wHo said what and man and standard deviation etc! HELP ME!!!!!!! SOMEONE ! ANYONE!!!!!!! LOL

    • @DavidDunaetz
      @DavidDunaetz  6 лет назад +1

      + Alice P
      For Windows:
      How to Calculate an Average: ruclips.net/video/dZk03_tBTO0/видео.html
      How to Calculate a Standard Deviation: ruclips.net/video/mLUn-F6iZ8c/видео.html
      If you need help on a Mac, you can google around to find the Mac version of the same videos.

  • @onlyorchids1264
    @onlyorchids1264 3 года назад

    sabka ladla ...maity petla🧐

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

    You had me until you started taking about the whole Sex and Gender topic.

  • @muhammadejaz80
    @muhammadejaz80 2 года назад

    Can i have your email Mr. David ?

    • @DavidDunaetz
      @DavidDunaetz  2 года назад

      You can find it online with a search.