Use the built-in Excel function for your test type
For a t-test, use `=T.TEST(array1,array2,tails,type)`
For a z-test, use `=Z.TEST(array, x, [sigma])`
For a chi-square test, use `=CHISQ.TEST(actual_range, expected_range)`
For an F-test, use `=F.TEST(array1,array2)`
For a one-tailed p-value from a t statistic, use `=T.DIST.RT(t, df)`
For a two-tailed p-value from a t statistic, use `=T.DIST.2T(ABS(t), df)`
For a right-tailed p-value from a z score, use `=1-NORM.S.DIST(z,TRUE)`
For a two-tailed p-value from a z score, use `=2*(1-NORM.S.DIST(ABS(z),TRUE))`
For a p-value from a chi-square statistic, use `=CHISQ.DIST.RT(chi_square, df)`
For a p-value from an F statistic, use `=F.DIST.RT(F, df1, df2)`
Use Data Analysis ToolPak for hypothesis tests if needed
Enable ToolPak through `File` > `Options` > `Add-ins` > `Analysis ToolPak`
Run the test and read the p-value from the output
Use `=PERCENTILE` or `=NORM.DIST` only if converting from a distribution-based threshold
Confirm whether the test is one-tailed or two-tailed before calculating p-value