statel statistical software excel

StatEL : Serial tests

 
Interest of this functionality is to allow you to practice several analyses of the same kind (i.e. several times the same test) on several data sets, as long as they are organized in columns like in image of the first dialog box.

statel serial test excel

Furthermore, in order to have clear diplay of results, pedagogical explanations will be missing of the results sheet. Thus, you are supposed to know specificities of the test you plan to realize.

1 - Launch of serial tests :

According to choice of the test you want to practice, data selection differs a little bit.

1.1 - Analysis without groups assignment :

This kind of selection concerns test of mean comparaison to a theoretical value, analysis of extreme values, normality analysis and descriptive statistics. A dialog box allows you to select every studies you want to analyse :

statel serial test excel


In case of mean comparaison to a theoretical value, you have also to specify vaue of the theoretical mean to which you want to compare means of the different studies you want to analyze.


1.2 - Analysis with groups assignment :

A first dialog box allows you to select column of groups names :

statel serial test excel

Then, a second dialog box appears to display the different groups that StatEL detected in your selection :

statel serial test excel


You can validate or cancel and resume previous selection by clicking on "Cancel" button.

Next step is the same than for previous paragraph and allows you to select every studies you want to analyse.



2 - Results of serial tests :

Resultats appear on a new sheet of your Excel workbook.

statel serial test excel

When conditions of use are not respected for a data set, a red "No" appears in the corresponding column. On the other hand, if conditions of use are respected and results of test allows to reject H0 hypothesis, a red "Yes" appears in the corresponding column, as well as p-value.

 

Société ad Science - 55, Boulevard Pereire, 75017 PARIS - France