Question

How to calculate p value google sheets using t value?

Answer 1

To conduct a t-test comparing the average averages of two sets of data using google sheet.

First, enter the two sets of data you are about to test in separate columns of the google sheet.

Then, in the cell in which you want to output the p-value of the t-test.

Start by entering "=", then type "ttest", followed by a comma, then enter the range of values of the two datasets separated by a comma, then enter a comma, enter the type of test you want to conduct (either a one-tailed or a two-tailed test), then enter the type which is usually type 3, close off your blacket and press enter.