Use Sophia to knock out your gen-ed requirements quickly and affordably. Learn more
×

How to Find a P-Value from a T-Test Statistic

Author: Sophia

what's covered
In this tutorial, you will learn how to find a p-value from a t-test statistic using the calculator, the t-table table, and Excel. Our discussion breaks down as follows:

Table of Contents

1. Right-Tailed Test

The average ACT score in Illinois is a 20.9. There's one high school in particular that believes its students scored significantly better than the state average. Because the school believes that its students performed better, this is an upper tail test.

table attributes columnalign left end attributes row cell H subscript 0 colon space mu equals 20.9 end cell row cell H subscript A colon space mu greater than 20.9 end cell end table

In order to test this hypothesis, the school took a random sample of 15 students' scores and got an average of 22.5, with a standard deviation of 2.3.

Let's first ask ourselves which type of data we are dealing with. In this case, we're dealing with quantitative data, and we do not know the population standard deviation. We just know the sample standard deviation, so we're going to do a t-test.

The first step is to calculate the t-statistic:

table attributes columnalign left end attributes row cell x with bar on top equals s a m p l e space m e a n equals 22.5 end cell row cell s equals s a m p l e space d e v i a t i o n equals 2.3 end cell row cell n equals s a m p l e space s i z e equals 15 end cell row cell mu equals p o p u l a t i o n space m e a n equals 20.9 end cell row blank row cell t equals fraction numerator x with bar on top minus mu over denominator begin display style fraction numerator s over denominator square root of n end fraction end style end fraction equals fraction numerator 22.5 minus 20.9 over denominator begin display style fraction numerator 2.3 over denominator square root of 15 end fraction end style end fraction equals fraction numerator 1.6 over denominator begin display style fraction numerator 2.3 over denominator square root of 15 end fraction end style end fraction equals fraction numerator 1.6 over denominator begin display style fraction numerator 2.3 over denominator 3.873 end fraction end style end fraction equals fraction numerator 1.6 over denominator begin display style 0.594 end style end fraction equals 2.694 end cell row blank end table

This gives us a t-score of 2.694. This score is plotted on the t-distribution below.

File:9948-right-tailed.png

1a. Graphing Calculator

In order to convert that into a p-value, the first method is on a graphing calculator. On your calculator, go ahead and hit 2nd DIST. We're interested in this sixth function, tcdf, which stands for "t cumulative density function."

File:5288-pvtt2.png

When we're entering in the values for a "tcdf," it is always going to be the lower boundary of the shaded region, the upper boundary of the shaded region, then the degrees of freedom. Remember, the shape of this distribution changes with the sample size. In this case, the lower boundary of our shaded region is 2.694. The upper boundary is the top portion of our distribution, which is positive infinity. In order to indicate positive infinity to our calculator, we just enter a positive 99. Our degrees of freedom will be 14 because the degrees of freedom is sample size minus one, or 15 minus 1.

File:5289-pvtt3.png

For this particular problem, we have a p-value of 0.0087, or 0.87%.

1b. T-Table

We can also use the t-table. Now, tables sometimes can only get us an estimated p-value. They can't get us an exact p-value, like the calculator or Excel. But sometimes it's all we have, and it's definitely sufficient. In this case, remember we had a t-test statistic of 2.694. All of the values inside our t-table are a bunch of t-scores. On the left hand column, these are the degrees of freedom, and the top row contains all of our corresponding p-values.

What we're going to do is look for the corresponding degrees of freedom for our hypothesis test. In this case we had 14 degrees of freedom. In that same row, we're going to look for the closest thing possible to the t-score of 2.694.

t-Distribution Critical Values
Tail Probability, p
One-tail 0.25 0.20 0.15 0.10 0.05 0.025 0.02 0.01 0.005 0.0025 0.001 0.0005
Two-tail 0.50 0.40 0.30 0.20 0.10 0.05 0.04 0.02 0.01 0.005 0.002 0.001
df
1 1.000 1.376 1.963 3.078 6.314 12.71 15.89 31.82 63.66 127.3 318.3 636.6
2 0.816 1.080 1.386 1.886 2.920 4.303 4.849 6.965 9.925 14.09 22.33 31.60
3 0.765 0.978 1.250 1.638 2.353 3.182 3.482 4.541 5.841 7.453 10.21 12.92
4 0.741 0.941 1.190 1.533 2.132 2.776 2.999 3.747 4.604 5.598 7.173 8.610
5 0.727 0.920 1.156 1.476 2.015 2.571 2.757 3.365 4.032 4.773 5.893 6.869
6 0.718 0.906 1.134 1.440 1.943 2.447 2.612 3.143 3.707 4.317 5.208 5.959
7 0.711 0.896 1.119 1.415 1.895 2.365 2.517 2.998 3.499 4.029 4.785 5.408
8 0.706 0.889 1.108 1.397 1.860 2.306 2.449 2.896 3.355 3.833 4.501 5.041
9 0.703 0.883 1.100 1.383 1.833 2.262 2.398 2.821 3.250 3.690 4.297 4.781
10 0.700 0.879 1.093 1.372 1.812 2.228 2.359 2.764 3.169 3.581 4.144 4.587
11 0.697 0.876 1.088 1.363 1.796 2.201 2.328 2.718 3.106 3.497 4.025 4.437
12 0.695 0.873 1.083 1.356 1.782 2.179 2.303 2.681 3.055 3.428 3.930 4.318
13 0.694 0.870 1.079 1.350 1.771 2.160 2.282 2.650 3.012 3.372 3.852 4.221
14 0.692 0.868 1.076 1.345 1.761 2.145 2.264 2.624 2.977 3.326 3.787 4.140
15 0.691 0.866 1.074 1.341 1.753 2.131 2.249 2.602 2.947 3.286 3.733 4.073


Now, 2.694 falls somewhere in between these two values, 2.624 and 2.977. These t-scores correspond to the two p-values, 0.01 and 0.005, or 1% and 0.5%. Since it falls somewhere in the middle, we are actually just going to take the average of these two p-values.

fraction numerator 0.01 plus 0.005 over denominator 2 end fraction equals fraction numerator 0.015 over denominator 2 end fraction equals 0.0075

To do this, take 1% plus 0.5%; divide that by 2, and we get an estimated p-value of 0.0075, or 0.75% when using the t-table. It is not exactly the same as the value we found using the calculator; however, it is very close.

big idea
The t-table only shows positive values, however, you can still use this same method for a left-tailed test; you would just look for the positive of your t-statistic.

1c. Excel

To convert our t-test statistic into a p-value using Excel, go under the Formulas tab. We are going to insert a formula that falls under the Statistical column. We are looking for t-distribution dot rt, or T.DIST.RT, because we're performing a right-tail test.

Notice how there is no T.DIST.LT. If we're performing a left-tail test, we would just use the T.DIST. But since we're performing an upper-tail test, we are going to use T.DIST.RT. The first thing we are going to put in is the t-score, which was a positive 2.694, then 14 degrees of freedom. Hit Enter.

File:5291-pvtt5.png File:5292-pvtt6.png

Notice how we get the same p-value of 0.0087, or 0.87%, as when we used our calculator.


2. Two-Tailed Test

The quality assurance of a soda company wants to make sure that its machines are working in filling its 12-ounce cans of soda. Because it would be a problem if the machines were significantly over-filling and under-filling the cans of soda, the company needs to perform a two-sided test.

table attributes columnalign left end attributes row cell H subscript 0 colon space mu equals 12 end cell row cell H subscript A colon space mu not equal to 12 end cell end table

The company took a random sample of 10 cans of its soda off the production line and got an average of 11.8 ounces with a standard deviation of 1.2 ounces.

We're looking at quantitative data, which is ounces of soda, and we also do not know the population standard deviation. Therefore, we're going to perform a t-test.

The first step is to calculate the t-statistic:

table attributes columnalign left end attributes row cell x with bar on top equals s a m p l e space m e a n equals 11.8 end cell row cell s equals s a m p l e space d e v i a t i o n equals 1.2 end cell row cell n equals s a m p l e space s i z e equals 10 end cell row cell mu equals p o p u l a t i o n space m e a n equals 12 end cell row blank row cell t equals fraction numerator x with bar on top minus mu over denominator begin display style fraction numerator s over denominator square root of n end fraction end style end fraction equals fraction numerator 11.8 minus 12 over denominator begin display style fraction numerator 1.2 over denominator square root of 10 end fraction end style end fraction equals fraction numerator negative 0.2 over denominator begin display style fraction numerator 1.2 over denominator square root of 10 end fraction end style end fraction equals fraction numerator negative 0.2 over denominator begin display style fraction numerator 1.2 over denominator 3.162 end fraction end style end fraction equals fraction numerator negative 0.2 over denominator begin display style 0.3795 end style end fraction equals negative 0.527 end cell row blank end table

The t-test statistic is negative 0.527. This score is plotted on the t-distribution below.

File:5293-pvtt7.png

2a. Graphing Calculator

Using a graphing calculator to go from the t-score to a p-value, we're going to look again at "tcdf." So go to 2nd, DIST, and we are going to scroll down to "tcdf," which stands for "t cumulative density function." We're going to put in the lower boundary of the shaded region, the upper boundary of the shaded region, then the degrees of freedom.

File:5294-pvtt8.png

The lower boundary of the shaded region for this problem is negative infinity. In order for the calculator to recognize negative infinity, we put in a negative 99. The upper boundary of the shaded region is the t-score, which is a negative 0.527. We have nine degrees of freedom, because our sample size was 10. We get a corresponding p-value of 0.3055, or 30.55%.

However, this is not our final answer. This was a two-sided test, and this is only the p-value that's associated with the left-tail, or the left-shaded region. We also have to get the corresponding upper-tail as well, which would fall at a positive 0.527.

File:5295-pvtt9.png

Luckily, because these two areas are equal, all we have to do is take this p-value that we got on the calculator, and multiply it by two. The p-value for this problem is 0.3055 times 2, or 61.1%.

2b. T-Table

Now, let's find the p-value using the t-table. To get the p-value from the t-test statistic of a negative 0.527, remember, we're going to look at the corresponding degrees of freedom, which in this case was a nine, and we're going to find the closest t-score we can to what we calculated. The closest value to 0.527 is this 0.703.

t-Distribution Critical Values
Tail Probability, p
One-tail 0.25 0.20 0.15 0.10 0.05 0.025 0.02 0.01 0.005 0.0025 0.001 0.0005
Two-tail 0.50 0.40 0.30 0.20 0.10 0.05 0.04 0.02 0.01 0.005 0.002 0.001
df
1 1.000 1.376 1.963 3.078 6.314 12.71 15.89 31.82 63.66 127.3 318.3 636.6
2 0.816 1.080 1.386 1.886 2.920 4.303 4.849 6.965 9.925 14.09 22.33 31.60
3 0.765 0.978 1.250 1.638 2.353 3.182 3.482 4.541 5.841 7.453 10.21 12.92
4 0.741 0.941 1.190 1.533 2.132 2.776 2.999 3.747 4.604 5.598 7.173 8.610
5 0.727 0.920 1.156 1.476 2.015 2.571 2.757 3.365 4.032 4.773 5.893 6.869
6 0.718 0.906 1.134 1.440 1.943 2.447 2.612 3.143 3.707 4.317 5.208 5.959
7 0.711 0.896 1.119 1.415 1.895 2.365 2.517 2.998 3.499 4.029 4.785 5.408
8 0.706 0.889 1.108 1.397 1.860 2.306 2.449 2.896 3.355 3.833 4.501 5.041
9 0.703 0.883 1.100 1.383 1.833 2.262 2.398 2.821 3.250 3.690 4.297 4.781
10 0.700 0.879 1.093 1.372 1.812 2.228 2.359 2.764 3.169 3.581 4.144 4.587


There's nothing that we can estimate. We can't take an estimate between two values, because our t-score falls below the very first value. Because we're doing a two-sided test, we can just look at the row for two-tailed and get a p-value of 0.5, or 50%. We could have also looked at the one-tailed row and doubled the value of 0.25 to get the same answer.

2c. Excel

To convert our t-score into a p-value using Excel, we're going to go under the Formulas tab and insert a formula again under the Statistical column. But because this is a two-sided test, we want t-distribution dot 2t, or T.DIST.2T, for two tails. Even though the t-square that we calculated was negative 0.527, in Excel you always put in the positive tail. We're going to go ahead and put in the positive 0.527 with our degrees of freedom of 9.

File:5297-pvtt11.png File:5298-pvtt12.png

Notice how we get the same p-value value of 61.1% that we did when using our calculator.

summary
Today we learned how to find a p-value from a t-test statistic using the calculator, the t-table table, and Excel. We did this for two types of test: a right-tailed test and a two-tailed test.

Good luck!

Source: THIS TUTORIAL WAS AUTHORED BY RACHEL ORR-DEPNER FOR SOPHIA LEARNING. PLEASE SEE OUR TERMS OF USE.

Practice Problems

/

T-Table

/
Terms to Know
P-value

The probability that the test statistic is that value or more extreme in the direction of the alternative hypothesis

Test Statistic

A measurement, in standardized units, of how far a sample statistic is from the assumed parameter if the null hypothesis is true