Two sample ttest using XLSTAT spreadsheet functions
On top of userfriendly dialog boxes, XLSTAT offers the possibility to instantly launch a wide range of analyses using simple functions within an Excel spreadsheet. This allows you to benefit from XLSTAT algorithms while linking Excel cells and performing simple or complex Excel operations. Please consult our tutorial to see how to use all XLSTAT functions within an Excel sheet.
This tutorial below will show you how to launch twosample ttests using the XLSTAT software spreadsheet functions in Excel.
How to do a 2 sample ttest in excel?
Please follow this procedure below to launch twosample ttests in XLSTAT:

Click on the Insert Function button to access our different functions.

Select XLSTAT in the Or select a category field.

Select the XLSTAT_TTest function to run a Student t test in order to compare two paired samples.

Click on the cell where you want to insert the function and obtain its result. For example, select the A2 cell.

Select the XLSTAT_TTest function and click OK.

Then select the two ranges where the data are. Be careful, do not select the sample label, or it will generate an error. Only the first two fields must be filled in. The other ones are optional.

Enter TRUE in the Paired field as the data are paired.

The last option (you need to scroll down in the dialog box), which is PValOut, is true by default and makes that the result is the pvalue. For information, if you set that option to false, you obtain the value of the Student t statistic.

Click OK to display the result of the ttest calculation in Excel.
The pvalue is 0.36 which means that the null hypothesis that the samples have an identical mean cannot be rejected with a significance level of 0.05.
Which are the arguments to configure for a 2sample ttest in XLSTAT?
The arguments of the XLSTAT_TTest function are:

V1: range for the first sample

V2: range for the second sample

Tail: 0 for a twosided test, 1 for a lower onesided test, 1 for an upper onesided test

HypDiff: the hypothesized difference between the two samples

Paired: TRUE if the two samples are paired

EqualVar: TRUE if the two variances are assumed to be equal

pvalOut: TRUE (default) if you want to display the pvalue, FALSE if you want to display the t statistic.
The Student t test requires that we assume that the variables from which the samples are obtained follow a normal distribution. If this appears does not appear to be likely, one can run a Wilcoxon signed rank test, which is a nonparametric test, meaning there is no need to assume a distribution for the data.
Which are the arguments to configure a Wilcoxon signed rank test in XLSTAT?
The arguments of the XLSTAT_WilcoxonTest function are:

V1: range for the first sample

V2: range for the second sample

Tail: 0 for a twosided test, 1 for a lower onesided test, 1 for an upper onesided test

Correction: TRUE if the correction should be applied with the approximation (default is TRUE)

ExactTest TRUE if you want to run the exact test (default is TRUE)

pvalOut: TRUE (default) if you want to display the pvalue, FALSE if you want to display the V statistic.
With the Wilcoxon signed rank test we obtain a pvalue of 0.43 which leads to the same conclusion that we cannot reject the null hypothesis that the samples are identical for what concerns their location.
When the data are not paired, you can use a two independent sample ttest in excel with the same XLSTAT_TTest function as above if the data follow a normal distribution (Paired = FALSE), or a MannWhitney test if you want to use a nonparametric test.
Was this article useful?
 Yes
 No