PvalOut: TRUE (default) if you want to display the p-value, FALSE if you want to display the t statistic. Paired: TRUE if the two samples are pairedĮqualVar: TRUE if the two variances are assumed to be equal HypDiff: hypothesized difference between the two samples Tail: 0 for a two-sided test, -1 for a lower one sided test, 1 for an upper one-sided test The arguments of the XLSTAT_TTest function are: The p-value is 0.36 which means that the null hypothesis that the samples have identical mean cannot be rejected with a significance level of 0.05. When you click OK, the result is displayed. If you set that option to false, you obtain the value of the Student t statistic. 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 p-value. The other ones are optional.Īs the data is paired, we enter TRUE for the corresponding option. Only the first two fields must be filled in. Do not select the sample label, or it will generate an error. Then select the XLSTAT_TTest function (or you can type it), then click OK, and select the two ranges where the data are. We will now show you how to use XLSTAT spreadsheet functions for a Student t test, and a Wilcoxon signed test, to compare two paired samples.įirst select the cell where you want to insert the function and obtain its result. Then you can select the function you want to use. Excel 2007 and later: Click the Formulas tab, then choose Insert Function at the very left, then choose XLSTAT in the Category list Excel 2003: Insert / Function, then choose XLSTAT in the Category list These functions are not documented in the help, but you can access the list of XLSTAT functions, once XLSTAT is started in Excel, by going to: This is possible using the XLSTAT spreadsheet functions. However, for various reasons, you might want to obtain results quicker and without the full XLSTAT report. XLSTAT is best known for its user friendly interface.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |