Wow! I never realized how much more complex SPSS was than Excel until this video. Chi squares in Excel are much easier in Excel. I guess having learned on SPSS I never noticed. This video was clear and easy to follow even with the more complex steps.
Mandy Moore Mandy, I agree... certainly more complex. I'm glad to hear that someone who is more familiar with working with SPSS and these statistics, like you, is finding this to be complex, too!
I appreciate the detailed explanation of the research design and how to apply the statistic, your demonstration was very helpful to better understand the chi-square.
In contrast to the student sin previous classes, I really prefer using SPSS over doing these calculations in Excel. SPSS may not be quite as intuitive as Excel, but I like the outputs better in SPSS and I appreciate the very step-by-step nature of these videos in helping us understand how to do the statistics in SPSS.
I am thankful for the explanation of how to interpret the output. The interpretation of course seems to be the most important part of all that we are learning
+Mark Vanderley I liked the help with the interpretation as well. I may have missed something in the video - does the researcher put in the expected values, or does the program do that? I'm going to have to go back and look, but when I read the book, it sounded like the researcher puts in the expected values...
This video has more components to it than in Excel. It was not as easy to follow. I liked to bar graph and Dr Grande did a good job explaining how to use Chi Square. I will need to watch this again to grasp all the information.
This example of how to do Chi-Square in SPSS was helpful for me to see what I would be doing if my research proposal was sought out as a study. I appreciated learning more about how the test design works and looks.
Thank you for sharing this video Dr. Grande. I find using chi square for spss a little more complicated than using chi square in excel. I appreciate the explanation of how to interpret the data.
Brittany, I have to agree with you! I was thinking I'd much rather use chi square in excel. However, I do like that you get more data to stretch your research. Dr. Grande always does a great job of explaining as well.
thank you so much for posting this! Just what I needed and I really appreciate the citations for the method. I am using this for my dissertation analysis and will also cite the youtube video!
Katherine Beck I think that's a huge strength as well. Very helpful in a world where it's a good possibility that your groups wont be the same size just as a result of dropout.
I agree Angie, this video was interesting and of course detailed. I also think that from watching this video and talking in class I understand this one a little bit more.
This video was a little confusing to me. I had a hard time following it because there were a lot of different steps. I have the most trouble understanding the cross tabs section. I do not understand where to put what variable. In the video, Dr. Grande said it did not matter what variable was in columns or rows but is that always the case?
Brittany Vodzak I would definitely prefer using excel only to avoid all the confusion and multiple steps. I would be afraid that I would miss something.
SPSS is so much more difficult to use than Excel. I have not used SPSS prior to this class therefore I am having a difficult time understanding the system. However, I appreciate Dr. Grande using a relatable example to explain Chi squared in SPSS.
Definitely a lot more steps when calculating a chi square in SPSS. I was confused a bit and it seems that excel perhaps the way it was explained was easier.
Great, thank s again! One question on this one- in your example- what is "expected count"? And- if you wouldn't mind responding with a brief answer I had a question from our readings- can family income be both quantitative and categorical at the same time? Thank you so much!
Usually I don't have much to say about videos about SPSS because I have never used it, but this video showed me that using SPSS for chi square seems a lot more confusing than using Excel. I think this is the first time I have said that I think Excel was easier.
Nice to see how to begin the process. You mention that in the Crosstabs dialogue box that you could switch the row and column variables; why? Why is weight cases a necessary part of the process?
I found the bar chart to be helpful in interpreting the data. Chi Square seems like a straight-forward test. I wonder what other condition to use it besides unequal sample size?
does the frequency represent the passing score or the learning exercise? and why the frequency does not sum up with the total number of the survey sample?
Hi Dr.Todd Grande I have two variables such as role conflict (Independent variable) and Marital Quality (dependent Variable with 10 items on likert scale from 1=strongly disagree to 5=strongly agree). Role conflict is loaded with eight items with five points as well ...The eight items of role conflict is indexed into one variable like (role conflict). And this indexed variable is tested with every item of marital quality...I run the chi square test with 95% confidence interval..In most cases it gives me a very high chi square/Pearson value like 89.321 and for some items 54.213 etc. ...I am confused why i am getting such higher values...Please guide me whether these values are coming under the recommended range?
I chose this video because the CHI SQUARE was used to analyze data in a peer reviewed journal I am using as a reference for my research proposal. The video helped me to understand the concept a little better, but I am not fully confident that I know what I am doing.
Immediately, SPSS looks way different from Excel in for running this test. Usually I can see some cross-over but I did not see much similarity. I'm learning a little more about Chi Square in that it can handle nominal data. Not surprisingly, I've never used the Crosstabs function. It would be helpful if the Chi Square test was a choice on its own without having to go deep into another analysis to get it, but that's just the nature of SPSS.
Hi. I'm having difficulty with "expected counts". What to do if there are more than 20% of the expected counts are less than 5? In my case: 15 cells (53.6%) have expected count less than 5. The minimum expected count is .07. Thank you.
The chi- square test for independent test or chi-square test for association is used to discover if there is a relationship between two categorical variables
Coding the data numerically in SPSS now seems painfully redundant after seeing it accomplished in Excel in fewer steps. If we lived in a perfect world and all had access to SPSS, it would make much more sense as I learned how to compute Chi Square, along with other methods, in SPSS before I ever saw any of them carried out in Excel. I think a valuable tool for future cohorts would be the inclusion of SPSS and Excel software, although I'm not sure which course it could be integrated into the most seamlessly.
I find that SPSS seemed user friendly in some videos but the last few seem the opposite. Excel just seems so much easier. This video was difficult for me to follow. I know at a basic level that it is much like the video for Excel, just with more steps, but I had a difficult time with this one.
Based on what I understand about other designs, I can see the value of a statistic that allows for the use of nominal/categorical factors. But it seems that because you are using a less refined variable, that the power of the test would always be compromised.
SPSS was always just a word to me before this class that might be mentioned during lectures in other classes. I have never used SPSS or Excel for statistic work. However, Excel seems more user friendly, but that may also be due to me using Excel for other applications. Statistic work is not my strong suit so when a new program is added on top of it, it seems very confusing to me.
Danielle Duboski I completely agree! I did not have to compute any statistics like this in research classes before. Therefore, seeing SPSS and Excel for the first time in comparison, I like Excel much better. I have a difficult time following SPSS.
I agree it can be hard to understand when statistics not a person's strong suit. I have been able to understand this terms because they have been repeated several times during his videos and he gives different examples.
Comparing this with the Chi Square in excel, there are so many more steps to maintain and a bit more confusing to me. I think I would have trouble utilizing this program for a Chi Square. Having the data displayed in the chart does help to ease the confusion and make the data comprehensible.
very helpful video. as Ivy said, this seems pretty straightforward. I'm interested to see what this looks like with some of our fictitious data that we have been using for the chapter exercises.
The complexity of SPSS seems to far surpass Excel. I am beginning to think that Excel might be better and easier to use for people wanted to use it for the most common tests. There are a lot of steps todo a Chi Square, and I am still a bit confused on those steps, but I think this video was a good example of how to do do this.
Again, I am not a fan of SPSS. It was much simpler to follow the functions and analysis in Excel compared to SPSS. But it was helpful to learn how to analyze the date in SPSS.
It still just seems so much harder using SPSS. I am starting to think this system is for advanced researchers. I am going to stick with learning the functions of Excel and perhaps one day I too can master SPSS.
Eeek, I agree. After having watched Chi-square in Excel, this was overwhelming in comparison. I do think SPSS is interesting and could replicate these steps with the video as a guide.
The complexity in Chi Square in SPSS is overwhelming, but it may be because I'm not familiar with SPSS. I was able to follow along in Excel easier. It becomes confusing because the data needs to be coded numerically.
Bethany Elstrom This was even more overwhelming than the Excel chi square for sure! I've never used these functions, despite having used SPSS, and it was a lot to take in. Aside from getting more than just the chi square data, I wonder why you would use SPSS when Excel seems much more straight forward.
This video was a little overwhelming for me. In order to work my way through this process I anticipate there would be a lot of stopping and starting the video through each step. On my own, I would not know what step to go for next.
I do not like Chi Square in SPSS. Although the Chi Square in SPSS outputs much more data, it was much harder for me to follow and to understand. I think Chi-Square is much simpler and understandable in Excel. Therefore, I would attempt to use Chi Square in Excel more than in SPSS, if possible.
Rachel Foster Rachel, I did not like Chi Square in SPSS either. Which I find funny because with some of Dr. Grande's previous videos, I found SPSS more user friendly than Excel.
Yeah...more complicated than Excel! This had more elements to it and I felt lost even after viewing Chi Square using Excel. I will stick to Chi Square in Excel.
Although this video does a nice job explaining how to conduct a Chi Square Test in SPSS, I found it much more difficult to follow. Again, I feel my confusion has more to do with the computer program than the specific concepts themselves. I would probably feel more comfortable with these concepts with further practice and studying.
Jacklin Skibicki I agree that I think the program is what is tripping me up and with further practice or application I think it would be much easier for me to comprehend it better.
Happy ONE MILLION Doc!!!
Wow! I never realized how much more complex SPSS was than Excel until this video. Chi squares in Excel are much easier in Excel. I guess having learned on SPSS I never noticed. This video was clear and easy to follow even with the more complex steps.
Mandy Moore Mandy, I agree... certainly more complex. I'm glad to hear that someone who is more familiar with working with SPSS and these statistics, like you, is finding this to be complex, too!
I appreciate the detailed explanation of the research design and how to apply the statistic, your demonstration was very helpful to better understand the chi-square.
In contrast to the student sin previous classes, I really prefer using SPSS over doing these calculations in Excel. SPSS may not be quite as intuitive as Excel, but I like the outputs better in SPSS and I appreciate the very step-by-step nature of these videos in helping us understand how to do the statistics in SPSS.
Thank you so much for this video! It was really helpful, I'm so glad this exists.
0:00 a legend was born
It's a shame these sorts of videos aren't more popular!
I'm glad to see a good example of when to use Chi Square. That is, I think, the most helpful thing for me.
I am thankful for the explanation of how to interpret the output. The interpretation of course seems to be the most important part of all that we are learning
+Mark Vanderley I liked the help with the interpretation as well. I may have missed something in the video - does the researcher put in the expected values, or does the program do that? I'm going to have to go back and look, but when I read the book, it sounded like the researcher puts in the expected values...
This video was helpful and I think I have a better understanding of when to use the chi-square test and why it is important, thank you
This video has more components to it than in Excel. It was not as easy to follow. I liked to bar graph and Dr Grande did a good job explaining how to use Chi Square. I will need to watch this again to grasp all the information.
This example of how to do Chi-Square in SPSS was helpful for me to see what I would be doing if my research proposal was sought out as a study. I appreciated learning more about how the test design works and looks.
Thank you for sharing this video Dr. Grande. I find using chi square for spss a little more complicated than using chi square in excel. I appreciate the explanation of how to interpret the data.
Brittany, I have to agree with you! I was thinking I'd much rather use chi square in excel. However, I do like that you get more data to stretch your research. Dr. Grande always does a great job of explaining as well.
I appreciated the tip of comparing the bar chart with the Pearson Chi Square p value- it is helpful to have a visual.
Thank you. Very helpful in conceptualizing the utility of Chi-square.
Fantastic! You're an earth angel!
Thank you very much for this video. This example was really easy to follow and helped me to understand about Chi-Square
thank you so much for posting this! Just what I needed and I really appreciate the citations for the method. I am using this for my dissertation analysis and will also cite the youtube video!
I like that with this you don't have to have samples that are the same size. I agree That it is a strength of the chi.
Katherine Beck I think that's a huge strength as well. Very helpful in a world where it's a good possibility that your groups wont be the same size just as a result of dropout.
This was an interesting video. I think I understand better when to use the chi-squared method vs other methods.
I agree Angie, this video was interesting and of course detailed. I also think that from watching this video and talking in class I understand this one a little bit more.
This video was a little confusing to me. I had a hard time following it because there were a lot of different steps. I have the most trouble understanding the cross tabs section. I do not understand where to put what variable. In the video, Dr. Grande said it did not matter what variable was in columns or rows but is that always the case?
Brittany Vodzak I would definitely prefer using excel only to avoid all the confusion and multiple steps. I would be afraid that I would miss something.
Hi, Dr. Grande. I would like to know what to do if one cell in a 2x2 table has zero observed counts.
SPSS is so much more difficult to use than Excel. I have not used SPSS prior to this class therefore I am having a difficult time understanding the system. However, I appreciate Dr. Grande using a relatable example to explain Chi squared in SPSS.
***** I agree never used spss and I am confused with it.
***** I find it more difficult to understand as well.
Definitely a lot more steps when calculating a chi square in SPSS. I was confused a bit and it seems that excel perhaps the way it was explained was easier.
Toniette Morda I agree. I was very confused. Excel seems so much more user friendly than SPSS.
Great, thank s again! One question on this one- in your example- what is "expected count"? And- if you wouldn't mind responding with a brief answer I had a question from our readings- can family income be both quantitative and categorical at the same time? Thank you so much!
Usually I don't have much to say about videos about SPSS because I have never used it, but this video showed me that using SPSS for chi square seems a lot more confusing than using Excel. I think this is the first time I have said that I think Excel was easier.
Nice to see how to begin the process. You mention that in the Crosstabs dialogue box that you could switch the row and column variables; why? Why is weight cases a necessary part of the process?
This video has more steps and a bit more difficult to understand however thank you Dr. Grande for the exposure to this technique.
I found the bar chart to be helpful in interpreting the data. Chi Square seems like a straight-forward test. I wonder what other condition to use it besides unequal sample size?
Happy one mill
Do you need to come up with the hypothesized values before you run the Chi Square and mark the expected variables box?
Going to view it in excel to be sure I understand the interpretation of the results.
does the frequency represent the passing score or the learning exercise? and why the frequency does not sum up with the total number of the survey sample?
Hi Dr.Todd Grande
I have two variables such as role conflict (Independent variable) and Marital Quality (dependent Variable with 10 items on likert scale from 1=strongly disagree to 5=strongly agree). Role conflict is loaded with eight items with five points as well ...The eight items of role conflict is indexed into one variable like (role conflict). And this indexed variable is tested with every item of marital quality...I run the chi square test with 95% confidence interval..In most cases it gives me a very high chi square/Pearson value like 89.321 and for some items 54.213 etc. ...I am confused why i am getting such higher values...Please guide me whether these values are coming under the recommended range?
really useful lesson; well done :)
Thank you -
I chose this video because the CHI SQUARE was used to analyze data in a peer reviewed journal I am using as a reference for my research proposal. The video helped me to understand the concept a little better, but I am not fully confident that I know what I am doing.
Immediately, SPSS looks way different from Excel in for running this test. Usually I can see some cross-over but I did not see much similarity. I'm learning a little more about Chi Square in that it can handle nominal data. Not surprisingly, I've never used the Crosstabs function. It would be helpful if the Chi Square test was a choice on its own without having to go deep into another analysis to get it, but that's just the nature of SPSS.
Hi. I'm having difficulty with "expected counts". What to do if there are more than 20% of the expected counts are less than 5? In my case: 15 cells (53.6%) have expected count less than 5. The minimum expected count is .07. Thank you.
Hi. My chi sqaure keeps coming up as violated as it's more than 20. What am I doing wrong ? Or what should I do
The chi- square test for independent test or chi-square test for association is used to discover if there is a relationship between two categorical variables
Helpful in comprehending Chi-square
Coding the data numerically in SPSS now seems painfully redundant after seeing it accomplished in Excel in fewer steps. If we lived in a perfect world and all had access to SPSS, it would make much more sense as I learned how to compute Chi Square, along with other methods, in SPSS before I ever saw any of them carried out in Excel. I think a valuable tool for future cohorts would be the inclusion of SPSS and Excel software, although I'm not sure which course it could be integrated into the most seamlessly.
Is running the Chi Square through the legacy dialogues equally valid or does it give you a different result?
+Adam Wilson It still yields a valid result but the available options are different.
I find that SPSS seemed user friendly in some videos but the last few seem the opposite. Excel just seems so much easier. This video was difficult for me to follow. I know at a basic level that it is much like the video for Excel, just with more steps, but I had a difficult time with this one.
Good explanation!
Based on what I understand about other designs, I can see the value of a statistic that allows for the use of nominal/categorical factors. But it seems that because you are using a less refined variable, that the power of the test would always be compromised.
I really have to practice entering data. I can't seem to get the frequency variable to work just yet.
SPSS was always just a word to me before this class that might be mentioned during lectures in other classes. I have never used SPSS or Excel for statistic work. However, Excel seems more user friendly, but that may also be due to me using Excel for other applications. Statistic work is not my strong suit so when a new program is added on top of it, it seems very confusing to me.
Danielle Duboski I completely agree! I did not have to compute any statistics like this in research classes before. Therefore, seeing SPSS and Excel for the first time in comparison, I like Excel much better. I have a difficult time following SPSS.
I agree it can be hard to understand when statistics not a person's strong suit. I have been able to understand this terms because they have been repeated several times during his videos and he gives different examples.
Comparing this with the Chi Square in excel, there are so many more steps to maintain and a bit more confusing to me. I think I would have trouble utilizing this program for a Chi Square. Having the data displayed in the chart does help to ease the confusion and make the data comprehensible.
Candace Fernandez Agreed! I was a bit confused. This is definitely challenging stuff!
Toniette Morda I agree! Somewhat confusing, but when data is presented in the form of a chart it always helps me to understand it a little bit better.
+Toniette Morda I'm definitely lost! SPSS rattles my brain.
Candace Fernandez i agree. SPSS has many more steps but the charts make the results more understandable
While there seems to be a consensus that SPSS is more complex than Excel, I do see the value of using chi-square for categorical data.
very helpful video. as Ivy said, this seems pretty straightforward. I'm interested to see what this looks like with some of our fictitious data that we have been using for the chapter exercises.
Very helpful
There is a lot of information and a lot more steps on SPSS. Excel was a lot more simple, however, this program gives you more data to analyze.
I'm not sure if it's becuase I am biased to Excel, but this seemed much more complicated in SSPS versus Excel.
Susan Wilder I am neither an Excel or SPSS user, but SPSS does seem a lot more complicated than Excel.
Sir how to calculate chi square test for single variable
The complexity of SPSS seems to far surpass Excel. I am beginning to think that Excel might be better and easier to use for people wanted to use it for the most common tests. There are a lot of steps todo a Chi Square, and I am still a bit confused on those steps, but I think this video was a good example of how to do do this.
Jessie Howard This video was difficult to follow especially since the information has to be coded numerically.
I am right there with you on this one. It had a lot of steps and I got lost.
Jessie Howard Chi Square in SPSS does seem more complex than in Excel. I too remain confused with all the terms and steps.
Well explained but the volume of sound is very low... i watched by reading captions only..
Again, I am not a fan of SPSS. It was much simpler to follow the functions and analysis in Excel compared to SPSS. But it was helpful to learn how to analyze the date in SPSS.
It still just seems so much harder using SPSS. I am starting to think this system is for advanced researchers. I am going to stick with learning the functions of Excel and perhaps one day I too can master SPSS.
Ashlee Todd Yes, I'm sticking with Excel.
Eeek, I agree. After having watched Chi-square in Excel, this was overwhelming in comparison. I do think SPSS is interesting and could replicate these steps with the video as a guide.
Kimberly Hanna Definitely. SPSS is interesting, but I think Excel might end up being more user friendly when taking everything into account.
helpful... still struggling, but helpful!
The complexity in Chi Square in SPSS is overwhelming, but it may be because I'm not familiar with SPSS. I was able to follow along in Excel easier. It becomes confusing because the data needs to be coded numerically.
Bethany Elstrom This was even more overwhelming than the Excel chi square for sure! I've never used these functions, despite having used SPSS, and it was a lot to take in. Aside from getting more than just the chi square data, I wonder why you would use SPSS when Excel seems much more straight forward.
Bethany Elstrom I was thinking the same thing. Everything seemed to just click when I was watching the Excel video. This one, not so much.
This video was a little overwhelming for me. In order to work my way through this process I anticipate there would be a lot of stopping and starting the video through each step. On my own, I would not know what step to go for next.
I know you use Chi Square to analyze categorized data, but using SPSS is a bit too much for me so far...
thanks a lot
You're welcome, thanks for watching -
I do not like Chi Square in SPSS. Although the Chi Square in SPSS outputs much more data, it was much harder for me to follow and to understand. I think Chi-Square is much simpler and understandable in Excel. Therefore, I would attempt to use Chi Square in Excel more than in SPSS, if possible.
Rachel Foster Rachel, I did not like Chi Square in SPSS either. Which I find funny because with some of Dr. Grande's previous videos, I found SPSS more user friendly than Excel.
Yeah...more complicated than Excel! This had more elements to it and I felt lost even after viewing Chi Square using Excel. I will stick to Chi Square in Excel.
Danielle Maldonado I have to agree with you; I would definitely utilize Excel if I were computing Chi Square data because it was much less involved!
I agree I think SPSS is more difficult because it has more steps. I think I would prefer excel
Ted Bundy brought me here
thank you
Todd Big
SPPS is complex!!
Although this video does a nice job explaining how to conduct a Chi Square Test in SPSS, I found it much more difficult to follow. Again, I feel my confusion has more to do with the computer program than the specific concepts themselves. I would probably feel more comfortable with these concepts with further practice and studying.
Jacklin Skibicki I agree that I think the program is what is tripping me up and with further practice or application I think it would be much easier for me to comprehend it better.
0:00 a legend was born
That’s hilarious and TRUE!