## How to enter dataData for the different variables are entered in different columns of the spreadsheet. All data for a single subject or case are entered in one row in the spreadsheet. In the top row of the columns you can enter the names of the variables. A variable name should not include any spaces. If necessary, you can use the underscore character _ to separate words, e.g. GRADE_A. Also the following characters cannot be used in a variable's name:
In addition, the variable name must not start with a number and must be different from reserved words such as TRUE, FALSE, ROW and COLUMN.
To to enter the variable name LENGTH in the top row of column A, you first position the mouse pointer on this cell, and click the left mouse button. The cell pointer is now located in this cell, and you can type the variable's name on the keyboard. Next, you press the key to actually store the name in the computer's memory and move the cell pointer to cell A1. You can now enter the first value 171 for the variable LENGTH in this cell, followed by pressing the key to go to the next cell.
When you want to change or
While you are entering data you must, from time to time, save your data on the disk. When you save the file for the first time then select the command
*you exit the program**switch of the computer**there is a power failure or a system or hardware malfunction.*
The program automatically formats the numbers that you enter according to the number of decimals selected in the Format spreadsheet dialog box. If you want a different number of decimals for a particular column, then select Spreadsheet in the A variable may either be ## Categorical or qualitative variableCategorical or qualitative data may either be entered as numbers or as text Nominal data: a classification without obvious order, e.g. blood group, male/female. Ordinal data: ordered categorical data, e.g. endometriosis stage, varicocele grade. A variable that can only have 2 values is also called a dichotomous variable, for example pregnant/not pregnant, male/female. In MedCalc, it is often useful to code categorical data with numerical values: 0 and 1, or 1 2 3 4, etc. ## Numerical or quantitative variableA numerical variable consists of numbers, for example 0, 25 or 3.258, or expressions that can be interpreted as a number, e.g. LOG(25) or SQRT(VAR1) where VAR1 is a variable's name containing numerical data. Numerical data may either be Continuous data: numbers that can theoretically assume any value between two given values; usually Discrete data: data that are not continuous (and may have a limited number of values), usually You can easily convert a numerical variable into a categorical variable using the spreadsheet function CATEGORISE or IF (If-then-else function). ## Next## See also |