How to Do P Value in Excel?

Enter your data in Excel

Click the Data tab

Click Data Analysis

Select the appropriate test

Click OK

Enter the input range

Set the output range

Click OK

Read the p-value from the results

Use `=T.TEST(array1,array2,tails,type)` for a t-test p-value

Use `=CHISQ.TEST(actual_range,expected_range)` for a chi-square p-value

Use `=F.TEST(array1,array2)` for an F-test p-value

Use `=CORREL(array1,array2)` with the correct test setup if needed

Use `=Z.TEST(array, x, sigma)` for a z-test p-value

Suggested for You

Trending Today