Microsoft Excel 2016 T - tests -

i using microsoft excel 2016 data analysis, can carry out test fine cannot produce t value along p value?

the function t.inv can used critical values. documentation describes "returns left-tailed inverse of student's t-distribution." thus, e.g. t.inv(0.05,9) returns value -1.83311. corresponding right-tailed value abs(t.inv(0.05,9)) = 1.83311 returns right-tailed version of more traditionally used in stats books.

there function t.inv.2t might prefer if using 2-tailed t-test.

the dots in function names t.inv unusual in excel naming conventions. reason behind decade excel used statistical functions mathematically correct had implementations not numerically stable. these tended fine in 99% of cases behave poorly when applied values several standard deviations away mean. microsoft responded persistent criticism , (with excel 2010?) revamped statistical functions. old version kept reasons of backwards. new versions have similar names in cases use dot. example t.inv more modern, more numerically stable, version of old tinv. whenever have choice between using 2 named statistical functions, use 1 dot.