# How to find P-value in Google Sheets (+Template)

Reading Time: 3 minutes

P-value is one of the most important statistics measures for any dataset. It is usually used to determine the correctness of certain hypotheses. And knowing how to find P-value in Google Sheets would be quite useful.

Ever wondered, how can you determine if your data obtained is correlated or not? Are the results obtained worth considering or not?

This is exactly what P-value can help you with. Google Sheets provide you with a very strong tool to find the P-value without actually doing the calculations manually.

By the end of this article, not only will you be able to identify the significance of your results, but also how to find the P-value in Google Sheets.

## What is P-value?

The P-value is a statistical measurement used to determine whether a data is statistically significant or not. It basically measures the probability of obtaining the observed data provided the null hypothesis is true.

The null hypothesis being true refers to basically considering that any difference seen in the observed data and the measured data is completely out of chance and that both the data are the same.

## Why do we use P-value?

You would have already understood by now, the importance of P-value when dealing with data. Post calculating the P-value, you can easily determine how close you are to your results.

Usually, a significant value is determined as a threshold for calculations, i.e., 0.05 is considered a threshold value. The lower the P-value, the more likely it is for your data to be statistically correlated.

## How to find P-value in Google Sheets?

Here is a spreadsheet template for a hands-on experience of the Function.

Let’s say, you have this dataset representing the average salary per month and average expenditure per month.

### Syntax

=T.TEST(array1,array2,tails,type)

Where, Array 1 refers to the first range of data;

Array 2 refers to the second range of data;

Tails refers to 1- one-tailed distribution, 2- two-tailed distribution;

Type refers to an integer value that can be 1 (paired t-test), 2 (2-sample t-test with equal variance), or 3 (2-sample t-test with unequal variance).

### Step 1: Add the Syntax for P-value in Google Sheets

Add the T.TEST Syntax in the cell where you want the P-value to be displayed.

### Step 2: Specify the Syntax Parameters

Add the range 1, 2, tails, and type according to the requirements.

Here, we have selected B3:B9 and A3:A9 as range1,2 respectively, and one-tailed distribution and 3 for a 2-sample t-test with unequal variances

Note: Variance can be calculated using VAR Function in Google Sheets.

Final P-value

We obtained a P-value lower than 0.05 showing that our data is statistically significant and thus can be correlated. This is a very simple and straightforward method to calculate P-value in Google Sheets.

Conclusion

Calculating P-value in Google Sheets is a relatively simple task with the help of the T.TEST Function. All you need to do is enter data, specify the type and tails and you will have your answer in no time.

It saves you from all those tedious calculations that need to be done when done manually.