How to Download & Prepare Survey Data for Analysis in Excel

The survey questions and codebook can be downloaded here: www.researchgate.net/profile/...

[@pdurgaanusha3578]

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]

That's pretty cool. Thanks for sharing that.

[@itsnotmeitsyou4582]

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

[@parulpopat5964]

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

[@itsnotmeitsyou4582]

if this video help you please thumbs up!

[@mrobireonomewilliams2998]

Thanks for this awesome tutorial. Part 2 please

[@TheExcessivemhz]

That was helping. Thanks for uploading

[@missg7437]

Thank you for this workshop was very very helpful!

[@DavidDunaetz]

You're very welcome!

[@janeojugo4979]

perfect, you made coding so simple. Bravo!

[@yosephmekonnen91]

Thank you very much !! Very helpful.

[@changeme454]

Excellent tutorial. Thanks for educating us.

[@DavidDunaetz]

Glad it was helpful!

[@mercylearns]

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

[@debbiegammie7537]

I am a beginner and this was perfect Thankyou

[@pratiksha5447]

It helped me a lot..thank you

[@hloniphalisa4632]

thank you sir this was very helpful

[@ca9404]

You're the GOAT.

[@EyaLabastilla]

THANK YOU!

[@buyayorrum1019]

very amazing and helpful

[@aeiou2525]

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

[@InfinitiCyberSolutions]

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

[@DavidDunaetz]

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

[@clyneirene]

nice tutorial

[@krutipatel5603]

Really very helpful in my dissertation

[@DavidDunaetz]

Glad it helped.

[@tingchen753]

wow!!! super

[@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]

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

[@itsnotmeitsyou4582]

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

[@leenanambinga3165]

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]

This video might be useful: kzbin.info/www/bejne/lafJq518f8xqi5o . A lot depends on what your data is measuring and what your hypotheses are.

[@kamonasishbhattacharjee1805]

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]

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]

@@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]

@@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]

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.

[@budang8912]

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

[@DavidDunaetz]

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: kzbin.info/www/bejne/lafJq518f8xqi5o .

[@maryadasharma4942]

Thank you

[@parvezmussarf6150]

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

[@DavidDunaetz]

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

[@codybruh-oq5yz]

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

[@DavidDunaetz]

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: kzbin.info/www/bejne/hpa2qqGuoK9gi6s

[@mrobireonomewilliams2998]

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]

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

[@johnbullowenvbugie2884]

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

[@smartiee74]

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

[@DavidDunaetz]

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.

[@midhunkm8632]

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

[@DavidDunaetz]

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]

@@DavidDunaetz Oh..okay Thank you David 😊

[@prabunusantara]

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

[@DavidDunaetz]

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]

@@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]

@@prabunusantara Yes, you can do both.

[@CarlosSantos-mz1kj]

Hi. Where can I follow the anslyze?

[@DavidDunaetz]

Here are a couple more videos that follow: kzbin.info/www/bejne/hp_Waoieh61sqNE kzbin.info/www/bejne/hp_Waoieh61sqNE You can go to the homepage of my channel and find many other videos on stats using Excel.

[@2007dodi]

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

[@DavidDunaetz]

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]

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

[@adeshsolanki2221]

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!

[@albertpinto3705]

Chal lavde

[@user-tr6uj8zy9y]

Sir How can i download practice source file ?

[@DavidDunaetz]

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

[@archisharma561]

from where do i get codebook/

[@archisharma561]

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

[@DavidDunaetz]

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

[@itsnotmeitsyou4582]

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]

+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]

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

[@itsnotmeitsyou4582]

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]

+ Alice P For Windows: How to Calculate an Average: kzbin.info/www/bejne/movOYWaVqaeHhZI How to Calculate a Standard Deviation: kzbin.info/www/bejne/o324n2B8a86NbsU If you need help on a Mac, you can google around to find the Mac version of the same videos.

[@onlyorchids1264]

sabka ladla ...maity petla🧐

[@muhammadejaz80]

Can i have your email Mr. David ?

[@DavidDunaetz]

You can find it online with a search.