It is necessary to have a basic knowledge of the use of Excel to be able to create new columns. Be careful, it is useless and not recommended to transform numerical variables (e. g. age) to create categories (<20; 20-55; >55 for instance) because this leads to a loss of information....
Essential concepts Excel is organized as a table, containing rows, columns and their intersection: the cells. The rows are numbered, the columns are identified by a letter (for example the 3rd column is cell C). A cell is referred to by its column letter followed by its row number (E1 is...
That's it, you have a study to carry out? Great! We have prepared a list of 10 rules to follow in order to make your data analyzable by a biostatistics software. Which data entry software to choose? AFirst of all, it is necessary to define on which file format you will input...
In statistical modeling, it is often necessary to group the numerical variables to create classes in order to meet the conditions of the model. If we have no a priori idea about the appropriate grouping, it is preferable to base ourselves on the splines representing the link between the...
It is sometimes surprising not to be able to carry out a multivariate analysis because the number of subjects is too small while the file contains several hundred observations (patients, subjects). Linear regressions For linear regressions, i. e. multivariate analyses for which the outcome variable is numerical, it is necessary to have...