![]() Include a separate column for each answer.ĭon't leave blank rows or columns in the data.ĭon’t mix numeric and character values (e.g. Don't enter data as "A,C,D" or "BDF" if there are three possible answers to a question. Enter systolic blood pressure as one variable, and diastolic blood pressure as another variable. ![]() Don’t enter data such as "120/80" for blood pressure. If you have several spreadsheets containing data on the same individuals, include their identifier(s) on each sheet. Sometimes you may have more than one identifier, such as Household ID and Subject ID place these in separate columns. Include a unique identifying number for each case. To prevent "ghost" rows and columns, copy only the raw data onto a new worksheet, and save from there. Delete extraneous data in your Excel file, like row or column totals, graphs, comments, annotations, etc. Only include the raw, un-summarized data. ,-.īe sure that each variable name is unique (no duplicate variable names)īe sure variable names are on the first row only! Variable names may only have letters, numbers, or underscores in themĭo not use following characters in variable names. Variable names can be no more than 8 characters long Place the variable names in the first row. Preparing Data for a Statistics Package: From Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |