Excel 2013 Statistical Analysis #60: T.DIST, T.DIST.RT, T.DIST.2T, T.INV, T.INV.2T functions

Topics in this video:
1. (00:29) Upper Tail (Right) Test to calculate p-value and Critical Value for Hypothesis Test using T.DIST & T.DIST.RT functions for P-value and T.INV function for Critical Value. Also degrees of freedom, Standard Error and the Test Statistic.
2. (04:32) Lower Tail (Left) Test to calculate p-value and Critical Value for Hypothesis Test using T.DIST function for P-value and T.INV function for Critical Value.
3. (06:20) Two Tail Test to calculate p-value and Critical Value for Hypothesis Test using T.DIST & T.DIST.2T functions for P-value and T.INV & T.DIST.2T for Critical Value.

[excelisfun]

Excel 2013 Statistical Analysis #60: T.DIST, T.DIST.RT, T.DIST.2T, T.INV, T.INV.2T functions
Topics in this video:
1. (00:29) Upper Tail (Right) Test to calculate p-value and Critical Value for Hypothesis Test using T.DIST & T.DIST.RT functions for P-value and T.INV function for Critical Value. Also degrees of freedom, Standard Error and the Test Statistic.
2. (04:32) Lower Tail (Left) Test to calculate p-value and Critical Value for Hypothesis Test using T.DIST function for P-value and T.INV function for Critical Value.
3. (06:20) Two Tail Test to calculate p-value and Critical Value for Hypothesis Test using T.DIST & T.DIST.2T functions for P-value and T.INV & T.DIST.2T for Critical Value.

[liyitong]

thanks for sharing, that is so useful!

[Chloe-ghmg]

Thanks for helping my uni statistic homework! You have explained the points so clear!

[rishabhsubrahmanian]

Bro you're the best, thank you so much!

[IExcelAndSoCanYou]

I have 9 women making on average $47.12 with Var= $53.24 vs.
33 men making $35.11 average, and $487.42 var.

I calculated this to have a test statistic of -2.64

To test to see if men make more that women with alpha=.05 I used:
TDIST(abs(-2.64), ((9+33)-2), 1) which gave me .005787968 which is < .05

Do these numbers really suggest men make more than women despite the average suggesting otherwise? Or am I missing a step? Admittedly men do have a much wider variance.