The test statistic was found to be t = 2.227 and there are 35 degrees of freedom. The Excel function T.DIST will be used to calculate the p-value for this test. This function has the format T.DIST(test statistic, degrees of freedom, cumulative). The input for cumulative will either be TRUE or FALSE. TRUE will be used when a cumulative distribution is needed. Note that the cumulative distribution refers to the area under the curve to the left of the test statistic. FALSE will be used when a probability density function is needed.
Note that > is used in the alternative hypothesis, indicating an upper-tail, also referred to as a right-tailed test. Since the T.DIST function gives the area to the left of the test statistic, we will subtract this value from 1 to obtain area under the curve to the right of the test statistic. The Excel formula that can be used to find the necessary p-value is ---Select--- =1 − T.DIST(2.227, 35, TRUE) =T.DIST(35, 2.227, TRUE) − 1 =1 − T.DIST(35, 2.227, TRUE) =T.DIST(2.227, 35, TRUE) − 1 .
Thus, the p-value, rounded to four decimal places, is