Use the built-in function `=T.TEST(array1,array2,tails,type)` for a t-test p-value
Use `=Z.TEST(array, x, [sigma])` for a z-test p-value
Use `=CHISQ.TEST(actual_range, expected_range)` for a chi-square test p-value
Use `=F.TEST(array1,array2)` for an F-test p-value
Use `=CORREL(array1,array2)` with a separate test if needed for correlation significance
Use `=T.DIST.2T(ABS(t_stat), degrees_freedom)` for a two-tailed t-test p-value
Use `=T.DIST.RT(t_stat, degrees_freedom)` for a right-tailed t-test p-value
Use `=NORM.S.DIST(z_stat, TRUE)` for a left-tailed z-test p-value
Use `=1-NORM.S.DIST(z_stat, TRUE)` for a right-tailed z-test p-value
Use `Data` > `Data Analysis` > `t-Test` or other test tools if the Analysis ToolPak is enabled
Enable Analysis ToolPak through `File` > `Options` > `Add-ins` > `Manage: Excel Add-ins` > `Go` > check `Analysis ToolPak`
Use the p-value output directly from the Data Analysis tool results table
Use `=CHISQ.DIST.RT(chi_square_stat, degrees_freedom)` for a chi-square p-value
Use `=F.DIST.RT(f_stat, df1, df2)` for an F-test p-value