how to do two sided t test with Excel

Sure, here are the steps to perform a two-sided t-test in Excel:

1. Open Excel and input your data. You should have two sets of data, each in its own column. For example, you might have data set 1 in column A and data set 2 in column B.

2. Click on an empty cell where you want the t-test results to appear.

3. Click on the "Formulas" tab at the top of the screen, then click on "More Functions" and select "Statistical".

4. Scroll down and select "T.TEST". A dialog box will appear.

5. In the dialog box, for "Array1", select your first data set. For "Array2", select your second data set.

6. For "Tails", select "2" because you are doing a two-tailed t-test.

7. For "Type", select "2" for two-sample equal variance (homoscedastic) or "3" for two-sample unequal variance (heteroscedastic), depending on your data.

8. Click "OK". The result that appears in the cell you selected in step 2 is the p-value for the t-test. If this value is less than your significance level (commonly 0.05), you would reject the null hypothesis.

Remember, the null hypothesis for a two-sided t-test is that the means of the two data sets are equal. So, if you reject the null hypothesis, you are saying that there is a significant difference between the means of the two data sets.