T-Test in Excel including Testing for Equality of Variances

  Рет қаралды 14,960

Dr. Todd Grande

Dr. Todd Grande

Күн бұрын

Пікірлер: 91
@katherinebeck593
@katherinebeck593 9 жыл бұрын
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.
@jackiedeleonardis1153
@jackiedeleonardis1153 5 жыл бұрын
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.
@tamarabakergibbons5715
@tamarabakergibbons5715 5 жыл бұрын
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.
@tammywitzke6642
@tammywitzke6642 8 жыл бұрын
My experience in using Excel is very limited , so I appreciate the simplistic way this video is structured.
@virginiamurrey9139
@virginiamurrey9139 6 жыл бұрын
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.
@meganblackwell8600
@meganblackwell8600 9 жыл бұрын
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!
@chelseydavis4989
@chelseydavis4989 9 жыл бұрын
This video gave me a much more thorough understanding of t testing process and when to use them.
@rebeccameece013
@rebeccameece013 9 жыл бұрын
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.
@briannagoitiandia9833
@briannagoitiandia9833 7 жыл бұрын
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.
@joe1579
@joe1579 7 жыл бұрын
Brianna Goitiandia I agree, when I learned both statistics & Excel, I learned them separately, & find these videos to be helpful all around.
@thecorgisquad9861
@thecorgisquad9861 9 жыл бұрын
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.
@thomasstarr6433
@thomasstarr6433 9 жыл бұрын
Much appreciated. The explanation of rejecting the null really made sense. Thank you.
@jhoward1129
@jhoward1129 9 жыл бұрын
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.
@meganblackwell8600
@meganblackwell8600 9 жыл бұрын
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.
@brittanyvodzak9198
@brittanyvodzak9198 9 жыл бұрын
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.
@aliciazahn1718
@aliciazahn1718 9 жыл бұрын
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!
@CandyKaneLane
@CandyKaneLane 9 жыл бұрын
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!
@CandyKaneLane
@CandyKaneLane 9 жыл бұрын
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.
@toniettemorda6247
@toniettemorda6247 9 жыл бұрын
Candace Fernandez The data was very organized..I agree!
@jacklinskibicki6098
@jacklinskibicki6098 9 жыл бұрын
Candace Fernandez I have never used this function in excel either (not that I remember) and I agree, this video provided good instruction.
@jazzynovy5400
@jazzynovy5400 9 жыл бұрын
Candace Fernandez I agree, data very neat and organized!
@aussiebreezekorb8877
@aussiebreezekorb8877 7 жыл бұрын
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.
@jazzynovy5400
@jazzynovy5400 9 жыл бұрын
Wow, never knew that we could calculate the t-test in Excel! Easy directions to follow from the video.
@rosasutton8472
@rosasutton8472 8 жыл бұрын
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.
@scottmartin7764
@scottmartin7764 8 жыл бұрын
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.
@brittanyhoffman8068
@brittanyhoffman8068 5 жыл бұрын
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.
@remygooch1393
@remygooch1393 5 жыл бұрын
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.
@toniettemorda6247
@toniettemorda6247 9 жыл бұрын
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.
@mandabear52289
@mandabear52289 9 жыл бұрын
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
@thecorgisquad9861
@thecorgisquad9861 9 жыл бұрын
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.
@MichaelSmith-jd5ki
@MichaelSmith-jd5ki 9 жыл бұрын
Toniette Morda it sometimes seems circular, right? You have to run a test to see which test to run...
@sherrietilghman2745
@sherrietilghman2745 9 жыл бұрын
Yes, it seems repetitive but definitely essential to do
@jennyjohn4526
@jennyjohn4526 9 жыл бұрын
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.
@rachelfoster5463
@rachelfoster5463 9 жыл бұрын
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.
@daniellemaldonado631
@daniellemaldonado631 9 жыл бұрын
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.
@alainavangelder5327
@alainavangelder5327 9 жыл бұрын
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.
@rebeccameece013
@rebeccameece013 9 жыл бұрын
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.
@bethanyelstrom3566
@bethanyelstrom3566 9 жыл бұрын
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.
@Pixieburglar
@Pixieburglar 9 жыл бұрын
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.
@michelemunday7653
@michelemunday7653 8 жыл бұрын
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.
@mandabear52289
@mandabear52289 9 жыл бұрын
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.
@maywest1016
@maywest1016 9 жыл бұрын
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.
@brittanyvodzak9198
@brittanyvodzak9198 9 жыл бұрын
Mandy Moore I also forgot since it has been so long! I agree that this video did a great job of explaing t-tests.
@Mjthfdj
@Mjthfdj 9 жыл бұрын
I enjoyed learning more about t tests. Good video.
@dogmandan79
@dogmandan79 5 жыл бұрын
Kudos on this, I still dont understand Stats but this helped greatly and was clearly understood.
@ariadnaaguero-roman5525
@ariadnaaguero-roman5525 9 жыл бұрын
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.
@remigiusdemby7433
@remigiusdemby7433 7 жыл бұрын
This is a clearer explanation and demonstration as to how to one can use Excel to conduct t-test.
@diane3460
@diane3460 7 жыл бұрын
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.
@ninastreet4630
@ninastreet4630 7 жыл бұрын
Remy, this video does make it easier to understand how to conduct the t-test in Excel.
@reneemendez4287
@reneemendez4287 9 жыл бұрын
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.
@MichaelSmith-jd5ki
@MichaelSmith-jd5ki 9 жыл бұрын
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.
@ariadnaaguero-roman5525
@ariadnaaguero-roman5525 9 жыл бұрын
I found it I interesting as well on how to determine which test to use.
@alexandrajones3178
@alexandrajones3178 8 жыл бұрын
I also found this helpful, I was unaware of how to determine which t test to use
@alainavangelder5327
@alainavangelder5327 9 жыл бұрын
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.
@maywest1016
@maywest1016 9 жыл бұрын
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.
@kimberlydixon8760
@kimberlydixon8760 9 жыл бұрын
***** I agree that this made it seem easy and efficient to calculate.
@jhoward1129
@jhoward1129 9 жыл бұрын
***** 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.
@reginaames3038
@reginaames3038 9 жыл бұрын
***** I too learned about this in undergrade but not having a great deal of recall
@susanwilder7616
@susanwilder7616 9 жыл бұрын
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.
@jazzmynmolson307
@jazzmynmolson307 7 жыл бұрын
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.
@joseliz8762
@joseliz8762 5 жыл бұрын
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.
@edeamn2327
@edeamn2327 7 жыл бұрын
How does this video have 6,335 views and 16 likes, give this guy some appreciation people.
@mirandat1087
@mirandat1087 8 жыл бұрын
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.
@simonehenry469
@simonehenry469 9 жыл бұрын
this made calculating t-test much easier
@wallcollegewires4731
@wallcollegewires4731 4 жыл бұрын
Very helpful video. Thanks for making it.
@kimberlydixon8760
@kimberlydixon8760 9 жыл бұрын
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.
@susanwilder7616
@susanwilder7616 9 жыл бұрын
Kimberly Dixon I agree; seeing it performed made it easier to understand.
@heather7927
@heather7927 8 жыл бұрын
I agree watching this made it easier to interpret and to understand how to do this.
@aliciazahn1718
@aliciazahn1718 9 жыл бұрын
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.
@rachelfoster5463
@rachelfoster5463 9 жыл бұрын
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.
@michellerobinson968
@michellerobinson968 9 жыл бұрын
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.
@Mjthfdj
@Mjthfdj 9 жыл бұрын
+Rachel Foster I agree. I wish they would just keep it simple.
@adamwilson4642
@adamwilson4642 9 жыл бұрын
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.
@remigiusdemby7433
@remigiusdemby7433 7 жыл бұрын
Adam, I find myself in a dilemma too as to the criteria that would warrant my choice of using Excel or SPSS.
@daniellemaldonado631
@daniellemaldonado631 9 жыл бұрын
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?
@jacklinskibicki6098
@jacklinskibicki6098 9 жыл бұрын
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.
@bethanyelstrom3566
@bethanyelstrom3566 9 жыл бұрын
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.
@kimberlykelly386
@kimberlykelly386 9 жыл бұрын
Emily Taylor Great point, Emily. It's easier to understand what Excel is doing if we can anticipate what needs to be done first.
@Pixieburglar
@Pixieburglar 9 жыл бұрын
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.
@romanvasiura6705
@romanvasiura6705 Жыл бұрын
Thank you for great explanation
@elizabethadair5545
@elizabethadair5545 9 жыл бұрын
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.
@kimberlykelly386
@kimberlykelly386 9 жыл бұрын
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.
@kimeeshareedwalker2602
@kimeeshareedwalker2602 8 жыл бұрын
These testing are new to me. So far, this is the easiest to interpret.
@pearlbutler9377
@pearlbutler9377 8 жыл бұрын
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.
@nakeshatucker6844
@nakeshatucker6844 8 жыл бұрын
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!!
@michellerobinson968
@michellerobinson968 9 жыл бұрын
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.
@reneemendez4287
@reneemendez4287 9 жыл бұрын
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.
@kyarapanula1002
@kyarapanula1002 8 жыл бұрын
I've been googling all the tests after the video :)
@reginaames3038
@reginaames3038 9 жыл бұрын
Great viedo on T-Test I do not remember what a f-test is or what the difference is between the two.
@simonehenry469
@simonehenry469 9 жыл бұрын
Regina Ames i think f-test is used after ANOVA
@sherrietilghman2745
@sherrietilghman2745 9 жыл бұрын
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.
One-Sample T Test using Excel
7:58
Dr. Todd Grande
Рет қаралды 13 М.
Conducting a Levene's Test in Excel
8:37
Dr. Todd Grande
Рет қаралды 36 М.
Andro, ELMAN, TONI, MONA - Зари (Official Music Video)
2:50
RAAVA MUSIC
Рет қаралды 2 МЛН
Levene’s Test of Homogeneity of Variance in SPSS (11-3)
9:43
Research By Design
Рет қаралды 213 М.
Calculating Percentile Rank Using Excel
8:12
Dr. Todd Grande
Рет қаралды 166 М.
The "z Test: Two Sample for Means" Analysis in Excel
10:30
Dr. Todd Grande
Рет қаралды 36 М.
Perform ANOVA Post-Hoc Tests (Bonferroni Correction) In Excel
8:02
Steven Bradburn
Рет қаралды 129 М.
t-Test - Full Course - Everything you need to know
16:14
DATAtab
Рет қаралды 416 М.
Using Multiple Regression in Excel for Predictive Analysis
9:18
Management Information Systems
Рет қаралды 1,8 МЛН
Perform Chi-Square Test Of Independence In Excel (Including P Value!)
8:35
Hypothesis Testing EXPLAINED
19:14
Ace Tutors
Рет қаралды 38 М.
I attended Trump’s inauguration yesterday. Here are my thoughts.
7:01
Senator Bernie Sanders
Рет қаралды 4 МЛН