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.
@jackiedeleonardis11535 жыл бұрын
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.
@tamarabakergibbons57155 жыл бұрын
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.
@tammywitzke66428 жыл бұрын
My experience in using Excel is very limited , so I appreciate the simplistic way this video is structured.
@virginiamurrey91396 жыл бұрын
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.
@meganblackwell86009 жыл бұрын
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!
@chelseydavis49899 жыл бұрын
This video gave me a much more thorough understanding of t testing process and when to use them.
@rebeccameece0139 жыл бұрын
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.
@briannagoitiandia98337 жыл бұрын
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.
@joe15797 жыл бұрын
Brianna Goitiandia I agree, when I learned both statistics & Excel, I learned them separately, & find these videos to be helpful all around.
@thecorgisquad98619 жыл бұрын
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.
@thomasstarr64339 жыл бұрын
Much appreciated. The explanation of rejecting the null really made sense. Thank you.
@jhoward11299 жыл бұрын
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.
@meganblackwell86009 жыл бұрын
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.
@brittanyvodzak91989 жыл бұрын
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.
@aliciazahn17189 жыл бұрын
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!
@CandyKaneLane9 жыл бұрын
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!
@CandyKaneLane9 жыл бұрын
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.
@toniettemorda62479 жыл бұрын
Candace Fernandez The data was very organized..I agree!
@jacklinskibicki60989 жыл бұрын
Candace Fernandez I have never used this function in excel either (not that I remember) and I agree, this video provided good instruction.
@jazzynovy54009 жыл бұрын
Candace Fernandez I agree, data very neat and organized!
@aussiebreezekorb88777 жыл бұрын
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.
@jazzynovy54009 жыл бұрын
Wow, never knew that we could calculate the t-test in Excel! Easy directions to follow from the video.
@rosasutton84728 жыл бұрын
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.
@scottmartin77648 жыл бұрын
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.
@brittanyhoffman80685 жыл бұрын
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.
@remygooch13935 жыл бұрын
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.
@toniettemorda62479 жыл бұрын
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.
@mandabear522899 жыл бұрын
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
@thecorgisquad98619 жыл бұрын
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-jd5ki9 жыл бұрын
Toniette Morda it sometimes seems circular, right? You have to run a test to see which test to run...
@sherrietilghman27459 жыл бұрын
Yes, it seems repetitive but definitely essential to do
@jennyjohn45269 жыл бұрын
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.
@rachelfoster54639 жыл бұрын
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.
@daniellemaldonado6319 жыл бұрын
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.
@alainavangelder53279 жыл бұрын
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.
@rebeccameece0139 жыл бұрын
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.
@bethanyelstrom35669 жыл бұрын
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.
@Pixieburglar9 жыл бұрын
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.
@michelemunday76538 жыл бұрын
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.
@mandabear522899 жыл бұрын
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.
@maywest10169 жыл бұрын
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.
@brittanyvodzak91989 жыл бұрын
Mandy Moore I also forgot since it has been so long! I agree that this video did a great job of explaing t-tests.
@Mjthfdj9 жыл бұрын
I enjoyed learning more about t tests. Good video.
@dogmandan795 жыл бұрын
Kudos on this, I still dont understand Stats but this helped greatly and was clearly understood.
@ariadnaaguero-roman55259 жыл бұрын
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.
@remigiusdemby74337 жыл бұрын
This is a clearer explanation and demonstration as to how to one can use Excel to conduct t-test.
@diane34607 жыл бұрын
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.
@ninastreet46307 жыл бұрын
Remy, this video does make it easier to understand how to conduct the t-test in Excel.
@reneemendez42879 жыл бұрын
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-jd5ki9 жыл бұрын
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-roman55259 жыл бұрын
I found it I interesting as well on how to determine which test to use.
@alexandrajones31788 жыл бұрын
I also found this helpful, I was unaware of how to determine which t test to use
@alainavangelder53279 жыл бұрын
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.
@maywest10169 жыл бұрын
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.
@kimberlydixon87609 жыл бұрын
***** I agree that this made it seem easy and efficient to calculate.
@jhoward11299 жыл бұрын
***** 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.
@reginaames30389 жыл бұрын
***** I too learned about this in undergrade but not having a great deal of recall
@susanwilder76169 жыл бұрын
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.
@jazzmynmolson3077 жыл бұрын
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.
@joseliz87625 жыл бұрын
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.
@edeamn23277 жыл бұрын
How does this video have 6,335 views and 16 likes, give this guy some appreciation people.
@mirandat10878 жыл бұрын
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.
@simonehenry4699 жыл бұрын
this made calculating t-test much easier
@wallcollegewires47314 жыл бұрын
Very helpful video. Thanks for making it.
@kimberlydixon87609 жыл бұрын
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.
@susanwilder76169 жыл бұрын
Kimberly Dixon I agree; seeing it performed made it easier to understand.
@heather79278 жыл бұрын
I agree watching this made it easier to interpret and to understand how to do this.
@aliciazahn17189 жыл бұрын
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.
@rachelfoster54639 жыл бұрын
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.
@michellerobinson9689 жыл бұрын
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.
@Mjthfdj9 жыл бұрын
+Rachel Foster I agree. I wish they would just keep it simple.
@adamwilson46429 жыл бұрын
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.
@remigiusdemby74337 жыл бұрын
Adam, I find myself in a dilemma too as to the criteria that would warrant my choice of using Excel or SPSS.
@daniellemaldonado6319 жыл бұрын
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?
@jacklinskibicki60989 жыл бұрын
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.
@bethanyelstrom35669 жыл бұрын
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.
@kimberlykelly3869 жыл бұрын
Emily Taylor Great point, Emily. It's easier to understand what Excel is doing if we can anticipate what needs to be done first.
@Pixieburglar9 жыл бұрын
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 Жыл бұрын
Thank you for great explanation
@elizabethadair55459 жыл бұрын
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.
@kimberlykelly3869 жыл бұрын
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.
@kimeeshareedwalker26028 жыл бұрын
These testing are new to me. So far, this is the easiest to interpret.
@pearlbutler93778 жыл бұрын
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.
@nakeshatucker68448 жыл бұрын
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!!
@michellerobinson9689 жыл бұрын
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.
@reneemendez42879 жыл бұрын
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.
@kyarapanula10028 жыл бұрын
I've been googling all the tests after the video :)
@reginaames30389 жыл бұрын
Great viedo on T-Test I do not remember what a f-test is or what the difference is between the two.
@simonehenry4699 жыл бұрын
Regina Ames i think f-test is used after ANOVA
@sherrietilghman27459 жыл бұрын
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.