4.2622E-217 is an error, you have too many decimals. try doing the calculus on a piece of paper, replacing and estimating the decimals with 10 to -1 (-2, ...-n power) or positive power depending on your calculus.
You certainly can, When you select the ttest function, it asks for 4 things. The first two things are the number arrays. It's ok if they have different amounts. The third thing it asks for is the number of tails. Select 2 here. The fourth thing it asks for is the type of ttest. Enter in "3" here. This is for unequal variance.
THANNK YYYOUU SO MUCH!! My bio teacher is a dunce, so thanks again. Only question i got is what is what is the results of the t test? My question in the book is literally"Results of t-test for our set of class data". My p value was .37, so i put that number down and said no statistical difference between the 2. Is that right?
if we have two independent sets of data shouldn't we have used an f test first to check if their variances were equal before deciding which t test to use?( unequal variance or equal variance)
we don't use the F test when we we have paired data because it's the same individual right??
LEGEND!!!!!!!
mobz00 5 days ago
Thanks so much!
25MKool 6 days ago
Thanks
MrPrabhubct 2 weeks ago
thaaaaaaaaaaaaaaaanks
Garahan 2 weeks ago
YOU JUST HELPED ME EARN MY PAYCHECK!
MrGtg109p 3 weeks ago
293 virgins
smiftel 3 weeks ago
4.2622E-217 is an error, you have too many decimals. try doing the calculus on a piece of paper, replacing and estimating the decimals with 10 to -1 (-2, ...-n power) or positive power depending on your calculus.
Medivh02 3 weeks ago
TY man, you saved me alot of research +1
Medivh02 3 weeks ago
ummm im trying to do this but i have vista format of excel...so can you help me?
127kawaii 3 weeks ago
My Excell doesn't give me a TSTAT option, only TTEST, TINV, and TDIST?
Marluvvy 1 month ago
@Marluvvy
TTEST is the one you want to choose.
rwinters123 1 month ago
I don't usually comment on videos, but felt I had to thank you, best explanation I've ever had! Thanks!
Northwinde1 1 month ago
Great explaination, the best I've seen having worked in market and social research for 20 years.
samwinstanley73 1 month ago
hey i cant find data analysis in the add-on list can you tell me where it is?
k1k1o7e1 1 month ago
hey this is great and all but can you do one with unequal amount of numbers please
drprettyboyhot1 1 month ago
@drprettyboyhot1
You certainly can, When you select the ttest function, it asks for 4 things. The first two things are the number arrays. It's ok if they have different amounts. The third thing it asks for is the number of tails. Select 2 here. The fourth thing it asks for is the type of ttest. Enter in "3" here. This is for unequal variance.
rwinters123 1 month ago
@rwinters123
thank you and this is the same person just a different account
k1k1o7e1 1 month ago
Why do my results make no sense? I'm getting things like 8.2234E-18
jennyinwaiting 1 month ago
@jennyinwaiting
Your results make perfect sense. The ttest number you got is just very low. many decimals worth. This means your two sets of data are very different.
rwinters123 1 month ago
Random guy teaching me stuff on youtube: I love you, will you marry me? <3
lassefan 2 months ago
Major freak out avoided. Lethal jab. Good work
movve91 2 months ago
very well explained...i was completely enlightened and i know about t test now...very elaborately explained...great work!
ronyprelude25 3 months ago
exp((Thank you!)^(Thank you!))!
krupnakobila 3 months ago
Cheers Mate
10005698 3 months ago
THANNK YYYOUU SO MUCH!! My bio teacher is a dunce, so thanks again. Only question i got is what is what is the results of the t test? My question in the book is literally"Results of t-test for our set of class data". My p value was .37, so i put that number down and said no statistical difference between the 2. Is that right?
shazzaforeverthabest 3 months ago
Thank you for this great explanation. You should give stats course.
bloodysalope 3 months ago
Really breaks things down if you never taking a stats class. Great Job!
tehtrusmartguy117 3 months ago
Comment removed
SuperNerd707 3 months ago
Great vid! Thanks! :)
BeckleswithFreckles 4 months ago
Thank you so much!
BGeeTea 4 months ago
Thank you so much for this video, it's a real life saver!
Keirico90 4 months ago
Thank you very much for sharing your knowlegde!! Thank youuuuuuu :)
Carminabb82 4 months ago
thanks a million :)
wish our teacher woulda showed this to us -,-
kimmygalea 5 months ago 9
Thank you so much for uploading this video.
MagaCarey 5 months ago
I got an e value of 4.2622E-217; Was a massive data set. What does this mean?
Castrophia1986 5 months ago
@Castrophia1986
It means the two sets of data are very, very different.
rwinters123 1 month ago
Excelent explanation. Thank you very much for sharing - added to favorites
gerardobrenes 6 months ago
isn't df supposed to be7+10-2=15 not 8?
251239 7 months ago 7
I add a link to your video in my blog about Chemometrics. Thanks.
jrcuesta1 7 months ago
Comment removed
712aznstryder712 7 months ago
Waw...perfect...thank you very much!!!!
MrEtoeth 7 months ago
Thank you for this video. Your explanation was thorough and precise.
1hottiewife 8 months ago
Than you so much!
cutycake 9 months ago
Thank you much, this video was a great help :-)
donolie21 9 months ago
if we have two independent sets of data shouldn't we have used an f test first to check if their variances were equal before deciding which t test to use?( unequal variance or equal variance)
we don't use the F test when we we have paired data because it's the same individual right??
ppumpk1nh3add 9 months ago
This video helped me very much! thank you!
rfiema 9 months ago
You are a man who made an impossible task come true. I UNDERSTAND the t-test! Thank you!
umar27891highlightss 9 months ago
thank you very much!
bollerofon 9 months ago
very useful video, ty ¡¡¡¡, i have a question, what i do with my P result in my test, should do something else.
dadse2 9 months ago
thanksss
nisha439 10 months ago
Thanks! This was so helpful. I had no idea this function was part of Excel!
jravilap 10 months ago
Thank you so much you just helped me complete my psychological research.
jithendraVS 10 months ago
Finally, it makes sense. Thank you.
chrisroecker 10 months ago
THANK YOU, YOU'RE AWESOME!!
DoctorWazabi 10 months ago
Thank you so much.
EmailWillLee 10 months ago
thank you!
marie6123 10 months ago
thanks! have a good future
pharmacistmanchester 11 months ago
Comment removed
pharmacistmanchester 11 months ago
Thanks for this. I study forensics and normally use SPSS for this, but it's very handy to know how to do it with excel... great explanation.
logical1989 11 months ago
Dziękuję! ;)
femElite 11 months ago
Thanks so much. Sooooo helpful. You rock.
ChickMy4 11 months ago
Excellent explanation ! thank you soooo much =)
beatofange1 11 months ago
very clear. thank you!
Scarakon 1 year ago
absolute gimp
MrSammyb91 1 year ago
absolute las
MrSammyb91 1 year ago
HI! This was great help! Thank you!!
saphira214 1 year ago
Great Help....Thanks alot...(Biomedical Student)
dynamobridge13 1 year ago
Thank you so Much!!!!
You make it so easy to understand...with step by step instructions.
psycho851 1 year ago
THANK YOU, this is exactly what I was looking for as a refresher for my students.
poadawg 1 year ago
it was great, thanks alot man
almomena 1 year ago
THANK YOU!! I'm in 4th year bio and I always forget how to do this, it was most helpful!!!!
sd07go 1 year ago
Thank you very much for your contribution to people like us. It became a very useful to me.
RohanSenarath 1 year ago
You are very good man. I wish you the best :) Hope you never get fat
sullivanseven 1 year ago
Thank you SO much! I had no clue how to do this. So easy to follow too. Thanks again! =D
VenusCrescentBeam 1 year ago
Super well explained!! thank you so much :D
gummybear27 1 year ago
Thank you! Its a great video.
76MGH 1 year ago
Thank you so much... excellent job... very professional.
viji156 1 year ago
Thank you so much, saved me alot of time
SuperPikeymikey 1 year ago
Thank you for taking the time to create this video!
michaelgreen06 1 year ago
Easy, thank u!
andr3ushi 1 year ago
legend
jarrydsik 1 year ago
Fantastic
shawlerstyle 1 year ago
You just saved my life. Thank you.
Somethingreallycool 1 year ago
A brief , informative introduction to the T test - thanks
serai711 1 year ago
thankkkkkkkkkkkkkkkkkkkkkkk you soo much!!!!
wildcatna147 2 years ago
Thank you, Thank you, Thank you! This has been very helpful :D
txcwgrl74 2 years ago
Thanks!
IMP2neurons 2 years ago
what is the differece between P value and T value?
Thanks in advance..
abeeerrr 2 years ago
thank you so much Sir
abeeerrr 2 years ago
thank you , helpful to learner indeed
liangheuuc 2 years ago