How to step-by-step | T-TEST in Google Sheets | UX Method Mondays | Zero to UX
Today we go over the T Test, or Student’s t-test, for statistical significance in UX research. We use this to compare the averages of TWO samples. A basic quantitative UX research method.
I show you step-by-step using Google Sheets on how to do the t-test and find your significant other: the p-value. Download the link for free and follow along!
docs.google.co...
The t-test is an inferential statistical method with 3 types: paired samples (aka dependent samples, aka repeated measures), unpaired samples (aka independent samples), or one-samples t-test.
Enjoy!
Don't forget to comment what you think the “t” in t-test means!
Mad love, PEACE!!
#InferentialStatistics #ttest #ZeroToUX
==================
RESOURCES MENTIONED IN THIS VIDEO:
Practice sheet (make a copy):
docs.google.co...
StatsCast: What is a T-test? KZread video
• StatsCast: What is a t...
Reject Significance And Embrace Uncertainty! (Ban Statistical Significance)
www.npr.org/se...
Google Sheets - free spreadsheet tool
docs.google.co...
==================
Say hi on social media!
Facebook: / zerotoux
Instagram: / cosmicquandary
Instagram: / zerotoux
Twitter: / zerotoux
Quora: www.quora.com/...
Medium: / pretendastronaut
==========
If you have questions about becoming a UX Researcher, feel free to email me.
I ALSO PROVIDE RESUME REVIEWS AND MOCK INTERVIEWS! Ask me about it!
kevin@zerotoux.com
• How to step-by-step | ...
Пікірлер: 38
This was actually amazing. I really learned something valuable. PLEASE DO MORE OF THESE.
@zerotoux
5 жыл бұрын
Thanks for watching! Lemme know what else you'd like to see:)
Thank you 😭
Man this was so much easier than when I learned this using SPSS!!
Thank you, thank you. Taking a UX metrics course, and your videos are so clear and helpful.
Really clear - this is exactly what I needed to refresh what I forgot in university
@zerotoux
3 жыл бұрын
Thanks for watching!! Yeah....when it comes to stats, it's really "use it or lose it, and then come back to Google it 5 years later" 😂
Love your humor! I have no idea with the "T" text is but there are NO accidents in the Universe. I've been doing alot of research these days. I'm happy to be a new subscriber and turned on my notifications to catch all of your videos.
THANKS!
This was helpful! I think it would also be helpful to have this video suggested or linked after the usability test video. It helped give me the full picture of how to analyze data from the usability test. Thank you!
@zerotoux
3 жыл бұрын
Thank you Gina!!
So enlightening to learn that Google sheets can do T-Tests haha Thank you, Kevin!
Hello Kevin, I find your video to be really helpful, so thanks for all your knowledge! However, I struggle to find a use case where I would want to know if the averages are reliably different. Could you please point out examples from your own work experience where you conducted this research method and which questions you wanted to answer with that? Also what would have been the consequences if the averages were reliably different and if they were not? That would be incredibly helpful! (:
It’s for the t distribution, but I believe it’s called as such as part of a pen name of William Seally Gosset, which was designed for beer quality control. But to be published without violating trade secrets was published under a pseudoname
Hi can you please make a video for Z-test ?
@kevinliang What do you do if your p value is >.05? Can you just increase the sample size instead of scratching your whole trial?
@zerotoux
2 жыл бұрын
Great question, Anthony!!! So if we manipulate a sample to GET 0.05, you can try to investigate = just look at the sample again, look for possible outliers to remove (and do ttest with unequal variances) and recalculate ORRR you can use a different alpha level (like 0.1 instead of 0.05), depending on your desired confidence level and risk ORRRRRR simply report that your p-value was higher than 0.05!! We can't and shouldn't manipulate data to get what we want. Data will show what the data will show :)
Great Video! I'm a fellow psychology student wanting to become a UX researcher. I always wanted to know what statistical program UX researchers mainly use???? SPSS, R, Python, Google Sheets? I can use SPSS but was thinking of learning how to use R program as well. Curious on what is the most commonly used program in UX research when conducting studies.
@zerotoux
5 жыл бұрын
UXRs use an amalgam of different tools. I know some who use R, some use SPSS, some Sheets, and some don't use any. It really doesn't matter what you use as long as you can accomplish what you need to do and it's really up to choice which you're most comfortable with. Qual UXRs don't use as much stats programs. Quant folks tend to use all kinds.
Dear Kevin, If you got enough time, would you record a video about “Chi Square Test” ? As much as I know, it’s similar to T-TEST. Thanks in advance. Love your content, keep going!
Is there any way to get the actual T-test value and not the probability?
@zerotoux
2 жыл бұрын
I'm not sure I understand. When you calculate the ttest, it returns the p-value, which is the probability Do you mean z-score?
@caspuchiha
2 жыл бұрын
@@zerotoux if I remember correctly there is a T test value capital T and I want to know if there is a way to calculate it.
@paulclifford6941
2 жыл бұрын
Yes, there is a T.INV function that works back from the p value and gives you the t-score. It would be better if TTEST returned both values, but alas and alack, it does not. The T.INV function requires only the p-value and the degrees of freedom. Depending on whether the you specified one-tailed or two-tailed when you used the TTEST you may have to multiply or divide the p-value by 2 before plugging it into the T.INV function.
The "T" does not stand for anything, as far as I was taught in my psych program- It was just a simple name given to the ratio. Thanks for the great videos.
true-test?!
My bio teacher really gave us a video in which a guy says "titty" lol
@zerotoux
2 жыл бұрын
Thats what's up 😂 I hope it was a good surprise
@rustedgoldmc
2 жыл бұрын
I'm pretty sure I audibly snorted lol
@zerotoux
2 жыл бұрын
@@rustedgoldmc 😂😂💀
@sayyidadnanhashmi3614
2 жыл бұрын
hahaha
Stats 10 without the theory
🙌🏽👏🏼👌🏿
@zerotoux
5 жыл бұрын
Haaaaiiiiii!!!
Hi Kevin! Great content as always. I was wondering, how would you write down the result of the t-test onto a case study?
@zerotoux
4 жыл бұрын
Hey Javier! The result of a t-test gives you one value, the p-value! So you would report that number.
@javxvii
4 жыл бұрын
Great! Thanks again!
Method Mondays on a.....Monday!?!?!?