This video is actually the best thing i think i have ever watched. These 4 minutes and 2 seconds made me understand more than my entire year at uni. Thank you so much sir, i hope you have a blessed life, you deserve all the happiness and abundance. Thank you.
after tons of video watched, this is by far the most easiest to understand and i just simply follow the steps to get my work done, thanks so much Joshua!
I think I finally have it. The highlighting and showing what you actually compare to what and what all this info is that it spits out is really helpful. Finally. Jesus.
Alternatively, Type = in a box, go to the functions box and select T-Test. Input array 1, array 2 (have array 2 as the hypothetical mean eg 20 and 20 as in this case), select EITHER one or 2 tailed depending on what you want, then select type 3 (unequal variance). I've validated this against Graphpad's free online 1-sample t-test calculator. It works.
Thank you so much for this video. It really helped me with my final project in Statistics. The step by step perfectly explained the information that I need.
Attention: 1) if you set an individual hypothesized mean difference you define the H0 not the HA: In short you want to reach p=0.5 onetailed & p=1 twotailed here (like common in the Levene or Kolmogorov-Smirnoff Test) and not 0.000something . 2) The range for the first variable must always contain the variable with the higher mean value, the range for the second variable must always contain the variable with the lower mean value. (This is because it cannot be smaller than ≤0, also known as undirected (blind) tests, thus not negative ) 3) the p value will be nearly near 0 in every case if you fail to suggest a very precise hypothesized difference. Thus as a stand alone this (p value) proves absolutely nothing. 4) The greater or smaller tendency results out of the sign for the t-statistic. For instance in the example of this video: if you type in 20 the t-statistic is positive, therefore your suggested difference was too low, if you type in 40 the t-statistic is negative and your suggested difference too high. 5) That is all you need to watch out for, also valid for 2 group comparisons. which could theoretically be the basis of saying it its significantly higher about xx.xx. But much fun in finding the correct value if ever prominent.
We are using a 2-variable package to solve a 1-variable problem. Since the second variable doesn’t really exist, we must create it in a way that it does not affect our one-variable results. If you enter only one zero, Excel will return error because it cannot compute the variance of a single value. This is why you need at least 2 zeros. You can use as many zeros as you want in the second variable.
Hello Joshua, thank you very much for your videos. It is helpful. I have one question here. On you videos how to conduct z test on excel, you mentioned we need to put at least 1 zero. But here, you said we need at least 2 dummy 0. My question is, does it really matter whether we put 1/ 2 dummy? Or it needs to be 1 dummy zero for T-test with 1 sample and 2 dummy zero when applying Z test Thank you
For one sample t test, at least two zeroes are needed, otherwise you will get a DIV/0 error in Excel. For one sample t-test, at least one zero. It is suggested that 0 would be the dummy values to make the usage of Data Analysis Toolpak possible. It makes the test value formula for two sample z or t test become analogous to the z or t test value formula for one sample.
Great job..You have explained very well this topic. Can you explain why I have, with a 5% of significativity, a non significant pvalue, 0.052746 and the t-stat,1.97748 significant? Thanks a lot
Friend, I have two days looking for how to solve a T-tes problem with a sample, watching many videos from 8 min to 20 min, without getting the clear answer. And you only gave me the answer in 4 minutes.
This video is actually the best thing i think i have ever watched. These 4 minutes and 2 seconds made me understand more than my entire year at uni. Thank you so much sir, i hope you have a blessed life, you deserve all the happiness and abundance. Thank you.
Oh god me too
i agree with you
You've explained this topic very well. My textbook resource rather confused me. Thanks a lot!
You literally made my day with this video! I was scratching my head at how to complete my assignment! Thank you!
This was by far the most useful video I have seen on this subject and I've been on youtube and google for 6 hours trying to figure this out.
Used this video in 2020 and it was a blessing. Great content and you made me fully understand the results I was looking at!
😀😀saved my life dude.. text book explains nothing just says perform in excel to get answers then just gives one line of data... you're awesome!!
after tons of video watched, this is by far the most easiest to understand and i just simply follow the steps to get my work done, thanks so much Joshua!
Joshua, you rock! This video is amazing. Thank you for taking the time to explain all the steps so that they are easily understood.
You answered in four minutes what I struggled to understand in one week's time. Thank you.
Your theoritical statistical analysis is straightforward and very easy to apply
Now am looking for dendograms
thank you so much for being so straightforward
Life Saver. This helped me more than anything the teacher or book ever taught!
Wow! I’ve watched so many videos and ended up confused! Thank you for this! You explained it very well!
Joshua, thank you...a concise easy-to-understand video.
Thank you so much this still works almost 5 years after your initial post. You explain it better than my textbook!
I think I finally have it. The highlighting and showing what you actually compare to what and what all this info is that it spits out is really helpful. Finally. Jesus.
Joshua you are good they're no two ways about it
Thanks, Noah. You're awesome too.
This man is talented for sure. God bless you. You know how to explain well.
WOW this is the best explanation I found in internet. Thank you very much. Now I know how to test hypothsis by myself
I really needed this video today good sir, you saved my life, and my grade. 🙏
Alternatively, Type = in a box, go to the functions box and select T-Test. Input array 1, array 2 (have array 2 as the hypothetical mean eg 20 and 20 as in this case), select EITHER one or 2 tailed depending on what you want, then select type 3 (unequal variance). I've validated this against Graphpad's free online 1-sample t-test calculator. It works.
This works if hypothesized mean difference in a given problem is zero
OMG , bro thank you so much, explained in 7 min what my professor did in 5 slides powerpoint
Thank you, I've watched a dozen videos that couldn't explain what you did easily.
Thank you for the video and explanation. Simple and easy to follow and absolutely spot-on! Thank you again Joshua
I love how easy you make it
it is an excellent video. Thank you so much for make my work done easily. Regards, From Bangladesh
Excellent video. Very informative, made the concept very simple using MS Excel.
king, i think you dropped this 👑
You literally have saved my life, thank you!!!
Nice to hear, Jenna. Thanks.
thanks you made a foreign concept much more approachable, keep up the good work!
Thank you, explained it much better than my tutor and textbook
precise and smart use of dummy variable. Thank you.
This video helped me greatly!! Thank you!!
Great job explaining. Very clear. Thank you!
Thank you for this video! This helped me for my statistics assignment!
Thank you for your creating this video. It is very clear and simple. I will wait to see another excel technique from you.
Josh bro you're a lifesaver! Really clear and easy to follow, great video.
Thanks, this was very helpful! Also, your accent in English is lovely!
Sir, you have very clearly explained. thank you
This is an excellent tutorial, beautifully done.
Joshua you are the GOAT. Thank you
I don't even find words to thank you! Your Video just save my exam=)
Thanks for dropping a note Sebastian. Glad the video helped.
Outstanding! You have a great ability to explain things with clarity!! Thank you!
Thank you so much for this video. It really helped me with my final project in Statistics. The step by step perfectly explained the information that I need.
You have explained very well. Thanks
It was a clear and concise video - thank you !
Amazing video, simple and easy, thank you for sharing!
You saved my semester! Thank you!
Absolute Legend. For real very helpful!
You've explained well am now able to do hypothesis well I would like to download an ANOVA done you
You sound like a video game NPC. I like your voice
Great video, really easy to follow and understand
Thank you so much. This video helped a lot.
Thank you so much for this easy to understand information!
Great speaker voice this was very easy to understand!
Awesome, you just saved me from failing applied statistics class...
Thank you so much for the video. God bless you.
Thank you sooo much! This is so helpful!
That was awesome and a life saver for my stat class!!
thanks alot.. you made it real easy!!
Great work! Please make more!
Anthony Prato why did he chose 20 for his hypothesized mean difference
Helpful video! Thanks
Cheers for the help Joshua.
Thank you so much, this is incredibly helpful! Keep it up
Thank you so much! This really helped with my homework :)
very well explained thank you!
thanks! precisely explained.
thank you so much, this saved me from my Test
Excellent video!
Hello please i happen to have my tstat < t critical and p < a
Do i happen to chose p < a to reject the data or i have be uncertain 🎉
You must reject Ho if p-value is less than alpha.
Thank you soo much
Now i know my focus should be on alpha and p more than t stats and t critical
Attention: 1) if you set an individual hypothesized mean difference you define the H0 not the HA: In short you want to reach p=0.5 onetailed & p=1 twotailed here (like common in the Levene or Kolmogorov-Smirnoff Test) and not 0.000something . 2) The range for the first variable must always contain the variable with the higher mean value, the range for the second variable must always contain the variable with the lower mean value. (This is because it cannot be smaller than ≤0, also known as undirected (blind) tests, thus not negative ) 3) the p value will be nearly near 0 in every case if you fail to suggest a very precise hypothesized difference. Thus as a stand alone this (p value) proves absolutely nothing. 4) The greater or smaller tendency results out of the sign for the t-statistic. For instance in the example of this video: if you type in 20 the t-statistic is positive, therefore your suggested difference was too low, if you type in 40 the t-statistic is negative and your suggested difference too high. 5) That is all you need to watch out for, also valid for 2 group comparisons. which could theoretically be the basis of saying it its significantly higher about xx.xx. But much fun in finding the correct value if ever prominent.
A well-explained video
This is very helpful, Joshua. Thank you!
My pleasure Liudmila.
you saved my life
Hi Joshua, can you explain a bit why you need the input two 0 value as dummy? What's the purpose of it?
We are using a 2-variable package to solve a 1-variable problem. Since the second variable doesn’t really exist, we must create it in a way that it does not affect our one-variable results. If you enter only one zero, Excel will return error because it cannot compute the variance of a single value. This is why you need at least 2 zeros. You can use as many zeros as you want in the second variable.
Thanks, this was a great help!
Nice job!!
thank you so much. really great help
wow that is very helpful .. thank you so much
Excellent!
thank you so very much Joshua.
I hate stats
Tommy Madrid same
same
Thanks great job!! so helpful!!
Really well done video.
Great job!
Hello Joshua, thank you very much for your videos. It is helpful.
I have one question here.
On you videos how to conduct z test on excel, you mentioned we need to put at least 1 zero. But here, you said we need at least 2 dummy 0.
My question is, does it really matter whether we put 1/ 2 dummy?
Or it needs to be 1 dummy zero for T-test with 1 sample
and 2 dummy zero when applying Z test
Thank you
For one sample t test, at least two zeroes are needed, otherwise you will get a DIV/0 error in Excel. For one sample t-test, at least one zero. It is suggested that 0 would be the dummy values to make the usage of Data Analysis Toolpak possible. It makes the test value formula for two sample z or t test become analogous to the z or t test value formula for one sample.
YOU ARE THE BEST I LVOE U
Very nice good sir. Thank you! :)
THANK YOU!
This was so helpful.. Thank you
Thank you sir!
Great Video!!
Thank you so much
Great job..You have explained very well this topic. Can you explain why I have, with a 5% of significativity, a non significant pvalue, 0.052746 and the t-stat,1.97748 significant? Thanks a lot
The t stat is not significant
Excelente vídeo.
Friend, I have two days looking for how to solve a T-tes problem with a sample, watching many videos from 8 min to 20 min, without getting the clear answer. And you only gave me the answer in 4 minutes.
Thanks so much!!!
Thank u very informative.but why did u choose t test for two samples assuming unequal variances (and not the first two ones) ?.?
Becasue " t test: Two-Sample Assuming Unequal Variances" is the most suitable for the objective here.
Thanks sir 😇
Hey ... thank you 😊