To find the P value using Excel, you can use the T.TEST function. The T.TEST function calculates the probability of a given test statistic, such as the T-value, assuming that the null hypothesis is true. The function takes several arguments, including the range of values for the sample data, the hypothesized mean of the population, the type of test (two-tailed or one-tailed), and the significance level.
Here is an example of how to use the T.TEST function in Excel:
Enter your sample data into a column in Excel.
In an empty cell, enter the formula =T.TEST(data range, hypothesized mean, type of test, significance level).
Replace "data range" with the range of cells containing your sample data, "hypothesized mean" with the mean of the population, "type of test" with 1 for a one-tailed test or 2 for a two-tailed test, and "significance level" with the level of significance.
Press enter, the P-value will be returned.
For example, if your sample data is in cells A1:A10, the hypothesized mean is 0, the type of test is two-tailed, and the significance level is 0.05, the formula would be =T.TEST(A1:A10, 0, 2, 0.05)
The P-value returned will be the probability that the sample data came from a population with a mean equal to the hypothesized mean, assuming that the null hypothesis is true.