![]() The name of the column was included in our data selection so we tick the option Column labels.įinally, you have to decide if you want to run a t-test or a z-test. The results will be displayed in a new sheet as we keep the default option Sheet. If the data were spanned on several columns for the same sample we could use the other option. ![]() Here we have only one column corresponding to one sample to test. The data format is One sample per column. Press the Range selector and select the column B that contains the “Math average”. Go over to the menu Parametric tests and select the option One-sample t-test and z-test. Setting up a Student's t-test for comparing the mean of a sample to a value We can use a t-test to determine if the difference between the average of the class and the average of all students in the county are similar or different with a risk of 5%. ![]() Descriptive statistics on the class performance can be computed using the function Descriptive Statistics. We don’t have the information about the variance of this statistic so we cannot run a z-test. We want to compare the results of those students with the county average which is 11.5. The data correspond to the mathematic grade average for the first semester of a class of 33 students. Dataset to perform a mean comparison test - either a Student's t-test or a z-test This tutorial shows how to test the difference between an observed mean and a theoretical one, using the one sample t-test and z-tests, in Excel with XLSTAT.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |