Replace the following components of the function with… In an empty cell, enter the following… =TDIST(t, df, tails) This is achieved by using the TDIST function. The last step is to calculate the p-value by using the t-statistic and the df. Replace cell1 in the equation with the cell containing the first data point and replace cell2 with the cell containing the last data point.īelow is a screenshot of what my example looks like. In Excel, click on an empty cell and enter the following… =AVERAGE(cell1:cell2) This can be easily calculated by using the AVERAGE function in Excel. The first thing you should do is to calculate the average value of the sample data. Then, use this information to determine the t-statistic and ultimately the p-value.
#T test data analysis excel how to
Instead, I will show you a step-by-step process on how to achieve this.įirstly, calculate the mean, standard deviation (SD) and standard error of the mean (SEM) in Excel. There is no function in Excel to perform a one-sample T-test. How to perform a one-sample T-test in Excel Alternative hypothesis – There is a significant difference between the heights of the sample, compared with the national average.