How to use Excel to calculate p values
Budget: £10 – £20 GBP
I got the following advice from a website. It proved to be wrong. Can you give me the correct advice?
I have the following numbers from a paired comparison trial. They are the differences between treatments. What is the p value that the average differs from zero
The values are 114 116 4 8 -20 29 -9 149
Scott Michael l C Programmer
My name is Scott and I would be assisting you today
07/07/2023 10:54
Scott Michael CScott Michael C Programmer
You can use Excel to calculate the p-value for your paired comparison trial. Excel has a built-in function called "T.TEST" that can be used for this purpose.
Here are the steps to calculate the p-value using Excel:
Open a new Excel spreadsheet.
Enter your data in a column. In this case, enter the differences between treatments: 114, 116, 4, 8, -20, 29, -9, and 149. Let's assume the data starts from cell A1.
In an empty cell, enter the following formula: "=T.TEST(A1:A8,0,2,1)". This formula calculates the two-tailed p-value for a paired t-test.
A1:A8 represents the range of your data.
The second argument, 0, indicates that the hypothesized mean difference is zero.
The third argument, 2, indicates that it is a paired t-test.
The fourth argument, 1, indicates that the test assumes equal variances.
Press Enter to calculate the formula.
Excel will display the p-value corresponding to the paired t-test. If the p-value is less than your chosen significance level (usually 0.05), it suggests that the average difference is significantly different from zero.
I have the following numbers from a paired comparison trial. They are the differences between treatments. What is the p value that the average differs from zero
The values are 114 116 4 8 -20 29 -9 149
Scott Michael l C Programmer
My name is Scott and I would be assisting you today
07/07/2023 10:54
Scott Michael CScott Michael C Programmer
You can use Excel to calculate the p-value for your paired comparison trial. Excel has a built-in function called "T.TEST" that can be used for this purpose.
Here are the steps to calculate the p-value using Excel:
Open a new Excel spreadsheet.
Enter your data in a column. In this case, enter the differences between treatments: 114, 116, 4, 8, -20, 29, -9, and 149. Let's assume the data starts from cell A1.
In an empty cell, enter the following formula: "=T.TEST(A1:A8,0,2,1)". This formula calculates the two-tailed p-value for a paired t-test.
A1:A8 represents the range of your data.
The second argument, 0, indicates that the hypothesized mean difference is zero.
The third argument, 2, indicates that it is a paired t-test.
The fourth argument, 1, indicates that the test assumes equal variances.
Press Enter to calculate the formula.
Excel will display the p-value corresponding to the paired t-test. If the p-value is less than your chosen significance level (usually 0.05), it suggests that the average difference is significantly different from zero.