He does give really clear explanations! Now that I've been watching the videos the terminology is clear as well. For instance the p value was below .05 so reject the null hypothesis, I was excited to understand.
I have been intimidated by t-tests since undergrad. This video was not as bad as I had feared but I do not have as clear of an understanding as I would like. I will definitely be re-watching!
I remember doing T Tests in undergrad and I don't know why but I always found them difficult. Maybe I just never really got the hang of it. I really need to know what to do in Excel when it comes to this, and this video did help me with that. Without this video, I would probably be lost when trying to generate my own T Test.
Easy to follow and comprehend with the given directions, I have never used excel in order to conduct a T-Test before, this is definitely a much more simpler way to keep the data organized, neat, and to assure that it is correct.
I find this video along with the others helpful in not only showing how to use Excel to run statistical analyses, but the descriptions provided along with the demonstrations helpful in teaching when certain analyses should be utilized and why.
I most appreciated the explanation of all of the different values in the table that he calculated. It was helpful for him to explain why we would be accepting the null hypothesis; the alpha of 0.05 would be less than the P value of 0.17 which would confirm the null.
This video is a clearer explanation on how to conduct a t-test between two variables in excel and makes it much more convenient to find this information in future research.
As a visual learner, it really did help to watch this; I was able to understand the terminology and functions of the tests better. After watching this, I would like to try these tests in Excel for more practice. Being that most of us don't have SPSS, it is helpful to know that the same functions can be performed in Excel.
I completely agree Rosa, I am also a visual learner and this was really helpful I completely agree that more experience with actually doing this would be very beneficial.
This video did a good job of explaining one of the basics of calculations in research. T-tests are something that I sort of remember from undergrad, but this was a good refresher video, I came away form this video with a good understanding of what to do in Excel. I like the idea of statistical significance, because it helps you understand if your data shows a results that supports a hypothesis or not.
Jessie Howard I agree with it being a good refresher video and I also like the idea of statistical significance. It helps me understand how to translate research into reality.
When I took a class that was similar to this I felt like I was lost when it came t -tests; I just never really got it. This video made it clear to me to what a t-test actually is and how you conduct one.
Brittany Vodzak This video definitely made it easier to understand t-tests, I remember in my stats class, our professor tried to show us how to do these and I was struggling to follow his directions!
This video made me realize that there is a lot to consider when doing a T-Test. There is a lot to remember as well. However, I thought Dr. Grande explained it all very well. I actually feel like I have a good understanding on this video.
Rachel Foster At first, I was apprehensive about this video, thinking I would not understand. Although I still feel uneasy, I do feel like I grasp the concept.
Rachel Foster There is a lot to consider in doing a T-Test and a great deal to remember. I think I have a fairly okay understanding of this video as well.
Rachel Foster I agree, there is a lot to consider and remember when doing T Tests. Thanks to the video, I feel a little bit better about the possibility of maybe generating my own T Test in the future because I can refer to this if needed. I'm glad we were able to go over this video because I really needed a refresher on this.
The data analysis tool seems to apply to most of these functions. Data analysis seems to be an important excel tool. Also, I learned about T-test in undergrad but I am having quite a bit of trouble recalling the information. However, I was surprised to learn that Excel calculates T Tests too!!! What a time saver.
I appreciated seeing the math behind the Cohen's D test. Knowing those steps helps me to better understand what we're measuring. I miss this in the automatic processing on SPSS.
This was very interesting! It was interesting to see how we have to test to actually test to see what type of T test to use. A T test basically is used to determine if two sets of data are different.
Toniette Morda I had forgotten all about the F-tests to determine which t-test you run. So this was a great reminder. Thinking that I will use a t-test for my research proposal to see if there is a statistically significant difference between my pre-test and post-test
Toniette Morda T-tests definitely seem to have the some of the most salience for us in terms of calculating and interpreting results, and whether or not they are significant.
Thank you for the video Dr. Grande. The table for the t test seems simple enough to interpret. I'm glad you specified whether you reject or accept the null hypothesis. This concept always seems to confuse me but it may be because I forget when it's less than or greater than, when to reject it or accept it.
This video was helpful in that I couldn't remember doing a T-Test as it has been a long time. Dr. Grande gave a fantastic explanation so that I could replicate this when needed.
Either I learned about T-tests during undergrad (and I don't remember) or I have never heard about them at all. They sound vaugly familer, but I could not pinpoint exactly wha they mean or do. Needless to say the very title of this video scared me. However, Dr. Grande made it very easy to understand how to do them in Excel. I still had to google some things during the video to make sure I understood, but overall I think this video helped me a great deal.
Thank you. I intend to use this in my research. I appreciate that there is some information that I will need to review more than once and even then, may have to learn by trial and error; but I can refer back to this demonstration and it will be useful to me. Thank you for taking the time to present this information in this way.
I liked this video a lot. It was bothering me that I was having trouble remembering t-tests and how to run them. I had also forgotten what the t-tests actually showed us. I thought this video did a great job of explaining t-tests in clear terms.
It was really interesting that Dr. Grande at first said we would accept the null hypothesis with the first P value but when the T-Test was run we actually ended up rejecting the null hypothesis. I do not think I really want to know how anyone came up with these formulas but it is amazing that they did, allowing for many different ways to check your data for statistical significance.
Alicia Zahn Accepting and rejecting the null hypothesis is always the opposite of what seems logical, almost as if the person who created it did it backwards. I have a really hard time remembering when to reject and when to accept. I agree that whoever came up with these formulas was very intelligent.
Alicia Zahn Dr Grande does a great job explaining the concepts but it was difficult to grasp. It is amazing that someone or some people, came up with all these formulas.
I appreciate this video because it shows me how I would need to run statistical analyses for my research proposal. I did find it a little confusing because I'm not sure why we would need to run two different tests for variance. Overall, the video is helpful.
thank you for the video. i have found that SPSS and excel are very similar. it is good to see that we can perform this type of research on just excel, especiially a t-test given how common they are, much like anovas. thank you for sharing.
When I last took statistics (something like 10 years ago), I did well but I was not taught how to do any of this is Excel. It's great to see how it can be used with the t-test because I am thinking that I would use this method to calculate my data for my research project.
I thought this was really interesting to see and somewhat easy to interpret. I wasn't really sure how to do T-Tests before and performing them in Excel made it seem easy to do.
I remember discussing t-tests in class and understanding that it measured variance between or among groups, but this video was helping in demonstrating how to carry out the test. Overall, very informative. However, I think I would need hands-on practice actually performing this function in Excel, as I am not quick to pick up on technology or computer programs.
Jacklin Skibicki This video does provide a great overall view of how to perform the T Test, but I am like you I will need to work with this on a continuous bases before I would be comfortable with the task.
Biggest take-away is that we can assume equal variances if the p value is greater than alpha; assume unequal variances if the p value is less than alpha. Then, after running the t-test, compare the p value to alpha to determine if you should reject the null hypothesis (which is that there is no significant difference between the means of the two groups studied). In this case, the p value is 0.007, less than the alpha of 0.05, so we reject the null hypothesis. There is a statistically significant difference between the two means.
There seems to be many areas that using the data analysis tool pack would be essential to calculating different data sets. It is used in many of these videos. I feel like there are many situations that prior knowledge would be necessary to be able to conduct these calculations. For example, in order to correctly calculate the date set in this video, one would need to know before hand that you would need to run a test first to see which T-Test to run.
I'm not sure what a p one tail or two tail is , but I was able to grasp that depending if there is statistical significance, a test is selected. I do like how data can be compared between the two groups being studied.
This was a neat little video. I did not feel like a lost puppy while watching. I think found it a little tricky when Dr. Grande started going into accepting and rejecting the null hypothesis. When he rejected it, I could see the difference in the Mean between the Control group and the Treatment group. So, was it rejected because you could obviously see the difference?
Having watched the companion video with t-tests in SPSS, I can't help feeling that Excel is the manual transmission of data analysis while SPSS is the automatic. As a novice, I am leaning toward SPSS, however, using Excel seems to give the researcher greater control.
These tests are new to me as well. I really like how Dr. Grande explains the method. I just wish that as a graduate student I had some prior experience with these test. As an undergraduate, some test were explained but not in great detail. I do not know if I will ever get it even after reading the chapters and watching the videos. I would love to be a statistical genius. Wishful thinking!!
This video was slightly confusing and I had to watch it a few times. I think by using the F-test two sample, assuming equal variables, that will decide what test to use such as the T-test. I was confused with P two-tail value, etc.
Michelle Robinson Some things, like those you mentioned, I had to google to make sure I had the right understanding during the video. It was confusing, but the combination of the video and good ol' google made it easier for me to comprehend.
I found it helpful that we could see the f test two sample test for variance first so that I know what I need to select when I run the T test. Both of these tests save time and effort on our part.
Bethany Elstrom This is the one part of the video that I was easily able to follow and understand the how and why with. I think that it was helpful to see the different things that must take place throughout the process.
Thorough explanation of how to conduct a t-test between two variables. I can see how this could be a beneficial tool when conducting research.
He does give really clear explanations! Now that I've been watching the videos the terminology is clear as well. For instance the p value was below .05 so reject the null hypothesis, I was excited to understand.
Learning how to tell when you need to use an f-test vs a t-test was a very helpful tip and it was a great refresher of t tests.
I have been intimidated by t-tests since undergrad. This video was not as bad as I had feared but I do not have as clear of an understanding as I would like. I will definitely be re-watching!
I remember doing T Tests in undergrad and I don't know why but I always found them difficult. Maybe I just never really got the hang of it. I really need to know what to do in Excel when it comes to this, and this video did help me with that. Without this video, I would probably be lost when trying to generate my own T Test.
This video gave me a much more thorough understanding of t testing process and when to use them.
Easy to follow and comprehend with the given directions, I have never used excel in order to conduct a T-Test before, this is definitely a much more simpler way to keep the data organized, neat, and to assure that it is correct.
Candace Fernandez The data was very organized..I agree!
Candace Fernandez I have never used this function in excel either (not that I remember) and I agree, this video provided good instruction.
Candace Fernandez I agree, data very neat and organized!
I find this video along with the others helpful in not only showing how to use Excel to run statistical analyses, but the descriptions provided along with the demonstrations helpful in teaching when certain analyses should be utilized and why.
Brianna Goitiandia I agree, when I learned both statistics & Excel, I learned them separately, & find these videos to be helpful all around.
I most appreciated the explanation of all of the different values in the table that he calculated. It was helpful for him to explain why we would be accepting the null hypothesis; the alpha of 0.05 would be less than the P value of 0.17 which would confirm the null.
This video is a clearer explanation on how to conduct a t-test between two variables in excel and makes it much more convenient to find this information in future research.
As a visual learner, it really did help to watch this; I was able to understand the terminology and functions of the tests better. After watching this, I would like to try these tests in Excel for more practice. Being that most of us don't have SPSS, it is helpful to know that the same functions can be performed in Excel.
I completely agree Rosa, I am also a visual learner and this was really helpful I completely agree that more experience with actually doing this would be very beneficial.
This video did a good job of explaining one of the basics of calculations in research. T-tests are something that I sort of remember from undergrad, but this was a good refresher video, I came away form this video with a good understanding of what to do in Excel. I like the idea of statistical significance, because it helps you understand if your data shows a results that supports a hypothesis or not.
Jessie Howard I agree with it being a good refresher video and I also like the idea of statistical significance. It helps me understand how to translate research into reality.
My experience in using Excel is very limited , so I appreciate the simplistic way this video is structured.
When I took a class that was similar to this I felt like I was lost when it came t -tests; I just never really got it. This video made it clear to me to what a t-test actually is and how you conduct one.
Brittany Vodzak This was a very straight-forward, easy to understand demonstration. T-tests without Excel is not something I would like to be doing!
Brittany Vodzak This video definitely made it easier to understand t-tests, I remember in my stats class, our professor tried to show us how to do these and I was struggling to follow his directions!
This was a great refresher on T-test, I have not reviewed this material in a few years. Great example! It was very easy to follow along to the video.
This video made me realize that there is a lot to consider when doing a T-Test. There is a lot to remember as well. However, I thought Dr. Grande explained it all very well. I actually feel like I have a good understanding on this video.
Rachel Foster At first, I was apprehensive about this video, thinking I would not understand. Although I still feel uneasy, I do feel like I grasp the concept.
Rachel Foster There is a lot to consider in doing a T-Test and a great deal to remember. I think I have a fairly okay understanding of this video as well.
Rachel Foster I agree, there is a lot to consider and remember when doing T Tests. Thanks to the video, I feel a little bit better about the possibility of maybe generating my own T Test in the future because I can refer to this if needed. I'm glad we were able to go over this video because I really needed a refresher on this.
Much appreciated. The explanation of rejecting the null really made sense. Thank you.
This is a clearer explanation and demonstration as to how to one can use Excel to conduct t-test.
Remy I agree this video was a little easier to understand how to conduct the t-test, I still feel like I need hands on for more clarity.
Remy, this video does make it easier to understand how to conduct the t-test in Excel.
The data analysis tool seems to apply to most of these functions. Data analysis seems to be an important excel tool. Also, I learned about T-test in undergrad but I am having quite a bit of trouble recalling the information. However, I was surprised to learn that Excel calculates T Tests too!!! What a time saver.
***** I agree that this made it seem easy and efficient to calculate.
***** Agreed! Anything that saves me time is a good tool to me. I also vaguely remember doing this, but can't really remember all that I learned.
***** I too learned about this in undergrade but not having a great deal of recall
I appreciated seeing the math behind the Cohen's D test. Knowing those steps helps me to better understand what we're measuring. I miss this in the automatic processing on SPSS.
Wow, never knew that we could calculate the t-test in Excel! Easy directions to follow from the video.
This was very interesting! It was interesting to see how we have to test to actually test to see what type of T test to use. A T test basically is used to determine if two sets of data are different.
Toniette Morda I had forgotten all about the F-tests to determine which t-test you run. So this was a great reminder. Thinking that I will use a t-test for my research proposal to see if there is a statistically significant difference between my pre-test and post-test
Toniette Morda T-tests definitely seem to have the some of the most salience for us in terms of calculating and interpreting results, and whether or not they are significant.
Toniette Morda it sometimes seems circular, right? You have to run a test to see which test to run...
Yes, it seems repetitive but definitely essential to do
I agree with Rosa, it is great to learn that Excel can do many of the same functions SPSS can do. I honestly had no idea Excel was capable of so much.
Thank you for the video Dr. Grande. The table for the t test seems simple enough to interpret. I'm glad you specified whether you reject or accept the null hypothesis. This concept always seems to confuse me but it may be because I forget when it's less than or greater than, when to reject it or accept it.
This video was helpful in that I couldn't remember doing a T-Test as it has been a long time. Dr. Grande gave a fantastic explanation so that I could replicate this when needed.
Either I learned about T-tests during undergrad (and I don't remember) or I have never heard about them at all. They sound vaugly familer, but I could not pinpoint exactly wha they mean or do. Needless to say the very title of this video scared me. However, Dr. Grande made it very easy to understand how to do them in Excel. I still had to google some things during the video to make sure I understood, but overall I think this video helped me a great deal.
Thank you. I intend to use this in my research. I appreciate that there is some information that I will need to review more than once and even then, may have to learn by trial and error; but I can refer back to this demonstration and it will be useful to me. Thank you for taking the time to present this information in this way.
Great information on t-tests. It's helpful to know first how to do an f-test in excel in order to determine which t-test to use.
I found it I interesting as well on how to determine which test to use.
I also found this helpful, I was unaware of how to determine which t test to use
I liked this video a lot. It was bothering me that I was having trouble remembering t-tests and how to run them. I had also forgotten what the t-tests actually showed us. I thought this video did a great job of explaining t-tests in clear terms.
Mandy Moore No worries. I am having trouble recalling the information too. The video was very informative in showing how to calculate the T test.
Mandy Moore I also forgot since it has been so long! I agree that this video did a great job of explaing t-tests.
It was really interesting that Dr. Grande at first said we would accept the null hypothesis with the first P value but when the T-Test was run we actually ended up rejecting the null hypothesis. I do not think I really want to know how anyone came up with these formulas but it is amazing that they did, allowing for many different ways to check your data for statistical significance.
Alicia Zahn Accepting and rejecting the null hypothesis is always the opposite of what seems logical, almost as if the person who created it did it backwards. I have a really hard time remembering when to reject and when to accept. I agree that whoever came up with these formulas was very intelligent.
Alicia Zahn Dr Grande does a great job explaining the concepts but it was difficult to grasp. It is amazing that someone or some people, came up with all these formulas.
+Rachel Foster I agree. I wish they would just keep it simple.
I enjoyed learning more about t tests. Good video.
this made calculating t-test much easier
I appreciate this video because it shows me how I would need to run statistical analyses for my research proposal. I did find it a little confusing because I'm not sure why we would need to run two different tests for variance. Overall, the video is helpful.
Very helpful video. Thanks for making it.
thank you for the video. i have found that SPSS and excel are very similar. it is good to see that we can perform this type of research on just excel, especiially a t-test given how common they are, much like anovas. thank you for sharing.
When I last took statistics (something like 10 years ago), I did well but I was not taught how to do any of this is Excel. It's great to see how it can be used with the t-test because I am thinking that I would use this method to calculate my data for my research project.
Kudos on this, I still dont understand Stats but this helped greatly and was clearly understood.
I thought this was really interesting to see and somewhat easy to interpret. I wasn't really sure how to do T-Tests before and performing them in Excel made it seem easy to do.
Kimberly Dixon I agree; seeing it performed made it easier to understand.
I agree watching this made it easier to interpret and to understand how to do this.
I remember discussing t-tests in class and understanding that it measured variance between or among groups, but this video was helping in demonstrating how to carry out the test. Overall, very informative. However, I think I would need hands-on practice actually performing this function in Excel, as I am not quick to pick up on technology or computer programs.
Jacklin Skibicki This video does provide a great overall view of how to perform the T Test, but I am like you I will need to work with this on a continuous bases before I would be comfortable with the task.
Emily Taylor Great point, Emily. It's easier to understand what Excel is doing if we can anticipate what needs to be done first.
This video was very intruiging for me. As always, it was easy to follow along with. I can absolutely see how this fucntion is essential in research.
How does this video have 6,335 views and 16 likes, give this guy some appreciation people.
Biggest take-away is that we can assume equal variances if the p value is greater than alpha; assume unequal variances if the p value is less than alpha. Then, after running the t-test, compare the p value to alpha to determine if you should reject the null hypothesis (which is that there is no significant difference between the means of the two groups studied). In this case, the p value is 0.007, less than the alpha of 0.05, so we reject the null hypothesis. There is a statistically significant difference between the two means.
There seems to be many areas that using the data analysis tool pack would be essential to calculating different data sets. It is used in many of these videos. I feel like there are many situations that prior knowledge would be necessary to be able to conduct these calculations. For example, in order to correctly calculate the date set in this video, one would need to know before hand that you would need to run a test first to see which T-Test to run.
Thank you for great explanation
I'm not sure what a p one tail or two tail is , but I was able to grasp that depending if there is statistical significance, a test is selected. I do like how data can be compared between the two groups being studied.
This was a neat little video. I did not feel like a lost puppy while watching. I think found it a little tricky when Dr. Grande started going into accepting and rejecting the null hypothesis. When he rejected it, I could see the difference in the Mean between the Control group and the Treatment group. So, was it rejected because you could obviously see the difference?
Having watched the companion video with t-tests in SPSS, I can't help feeling that Excel is the manual transmission of data analysis while SPSS is the automatic. As a novice, I am leaning toward SPSS, however, using Excel seems to give the researcher greater control.
These testing are new to me. So far, this is the easiest to interpret.
I feel the same way, I'm still getting caught up on what what a the terms mean so I think I need to go back and read the first two chapters again.
These tests are new to me as well. I really like how Dr. Grande explains the method. I just wish that as a graduate student I had some prior experience with these test. As an undergraduate, some test were explained but not in great detail. I do not know if I will ever get it even after reading the chapters and watching the videos. I would love to be a statistical genius. Wishful thinking!!
Great viedo on T-Test I do not remember what a f-test is or what the difference is between the two.
Regina Ames i think f-test is used after ANOVA
This video was slightly confusing and I had to watch it a few times. I think by using the F-test two sample, assuming equal variables, that will decide what test to use such as the T-test. I was confused with P two-tail value, etc.
Michelle Robinson Some things, like those you mentioned, I had to google to make sure I had the right understanding during the video. It was confusing, but the combination of the video and good ol' google made it easier for me to comprehend.
I've been googling all the tests after the video :)
How do you personally decide whether you will use Excel or SPSS? Excel seems a bit cleaner to me, but obviously requires more of a knowledge base.
Adam, I find myself in a dilemma too as to the criteria that would warrant my choice of using Excel or SPSS.
I realize before you perform a t-test you need to do an f-test to determine if the variances of the two populations are equal.
I found it helpful that we could see the f test two sample test for variance first so that I know what I need to select when I run the T test. Both of these tests save time and effort on our part.
Bethany Elstrom This is the one part of the video that I was easily able to follow and understand the how and why with. I think that it was helpful to see the different things that must take place throughout the process.