Find the p-value with the T-TEST function
If you only need the p-values, you need not follow the process above.
Instead, you can instantly find the p-values for any given data set by using the TEST function. 😄
1. Write the TEST function as follows:
The first argument (array_1) refers to the range that contains the first variable (actual scores).
2. Create a reference to the second variable (expected scores) as array_2.
=T.TEST (B1:B8, C1:C8,
3. Set the tails argument as 1.
=T.TEST (B1:B8, C1:C8, 1
It refers to the number of distribution tails. We have set it to 1 because we are finding a one-tailed p-value.
4. The t-test type argument can be set to three modes.
1 = paired.
2 = two-sample equal variance (homoscedastic)
3 = two-sample unequal variance (heteroscedastic)
We are setting it to ‘1’.
=T.TEST (B1:B8, C1:C8, 1, 1)
All done! Hit enter to have the one-tailed p-value for this data set generated.
Can you generate a two-tailed P value in Excel using the T.Test function? Yes, see below.
1. Write the following formula:
=T.TEST (B1:B8, C1:C8, 2, 1)
Set the tails argument to ‘2’ instead of ‘1’.
Everything else remains the same. Go ahead and hit ‘Enter’.
And there you go! Computing p-value using the simple formula of T.Test is more like a child’s play.
Did you notice how both methods yield the same result?
Both the one-tailed and two-tailed p-values stand tallied.
Which method to use? 🤔That depends upon your needs.
If you are only in need of the P-value, save time by using the T.Test function.
However, to fetch other details in respect of your dataset (Mean, Variables, etc.) too, better go with the T-Test tool in the Analysis ToolPak.