Question

How do I find the test statistic and p value in excel?

Answer 1

Dear Student,

Below are the answer to your question :

Ways to find the test statistic and p value in excel

Basically, the p-value is used in hypothesis testing to quantify the idea of statistical significance of evidence.

It’s a value that can be expressed in percentage or decimal to support or reject the null hypothesis.

In Excel, the p-value is expressed in decimal.

The t-Test tool in the Analysis ToolPak

To use the t-Test tool in the Analysis ToolPak, you have to load the toolpak first in Excel.

Here’s a summary on how to add the analysis tool:

• Click ‘File’ from the tab list
• Click ‘Options’ on the bottom of the left-hand sidebar
• Click ‘Add-ins’ on the left-hand sidebar of the window
• On the bottom part, make sure that ‘Excel Add-ins’ is selected
• Then, press ‘Go’
• On the next window, check the ‘Analysis ToolPak’
• Click ‘OK’

If you like the answer, Kindly subscribe and up vote

Thank You !!