How to Use Excel-The t-Test-Two-Sample Assuming Unequal Variances Tool
HTML-код
- Опубликовано: 22 авг 2024
- Computes a t value between means for two independent groups of scores when variances for each group are unequal. Also known as the independent or unpaired samples t-test.
Ty for this it really help us
thank you
is there any more reason as to when to rejct and accept the null
why is the Degree of Freedom 32 ?
Thank You!
Hello If I were to graph that data, what sample size should I put?
Thank you in advance!
I am a bit confuse at 2.48 because i think the t stats (Score) is less than the t critical value of both two-tail and one-tail so how is it greater than???? -4.02 is before 0 so less than and 1.69 and 2.04 is after 0 so greater than.
When it comes to negative t values "greater than" is probably not the correct term. If the calculated t value is beyond the critical value on the t score distribution (i.e. the bell curve), then that would indicate rejection of the null. In this example, -4.02 is beyond or to the left of the critical value and the null can be rejected.
It was an informative video, 😊
Glad it was helpful!
what version of Excel is this?
Can we use this if one sample is normally distributed and the other is skewed ?
No, both samples need to be normally distributed.
Is this Welch’s t test or something different?
The variance ratio is less than four. You should be using Equal Variance not unequal variance sir.
when do you use t test for equal and then for unequal variance in excel?
It will depend on the standard deviation values for each group; if one group has a SD value more than 2x the other, I would suggest using the unequal variances option.