The formula used in MS Excel to calculate p-value is :
=tdist(x,deg_freedom,tails)?
The p-value is expressed in decimals in Excel. Here are the steps to calculate it :
* Find the Data tab
* On the Analysis tab, click on the data analysis icon
* Select Descriptive Statistics and then click OK
* Select the relevant column
* Input the confidence level and other variables
