Below are the movie theater ratings in the sample we used for a two-sided test. Recall that because Excel does not have a function dedicated to one-sample tests, we must convert each one-sample test into a two-sample test. Adding a column of constant values essentially provides a second "sample" for Excel to use. Each value in our second "sample" is the same constant, the historical average rating. Here this step has already been completed. Step 1 In cell E2, enter the function =T.TEST(A2:A197,B2:B197,1,3) to calculate the p-value of the sample mean