help:data_structure
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
help:data_structure [2015/03/29 01:06] admin |
help:data_structure [2015/03/29 01:54] (current) admin [Getting your Data Structure Right for SOFA] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| [[http://www.sofastatistics.com/userguide.php | Contents]] | [[http://www.sofastatistics.com/userguide.php | Contents]] | ||
| - | ====== Getting your Data Structure Right for SOFA ====== | + | ====== Getting your data structure right for SOFA ====== |
| ===== Data Format ===== | ===== Data Format ===== | ||
| Line 81: | Line 81: | ||
| ==== Restructuring your data ==== | ==== Restructuring your data ==== | ||
| - | The most common problem is when your data has the data for different groups in different variables. | + | The most common problem is when your data has the data for different groups in different variables. The easiest way to handle this might be to change the data in a spreadsheet and import it in the restructured form. |
| - | + | ||
| - | E.g. score data for three years: | + | |
| - | + | ||
| - | 2014 Female | + | |
| - | 186 167 | + | |
| - | 179 170 | + | |
| - | ... | + | |
| - | + | ||
| - | The easiest way to handle this might be to change the data in a spreadsheet and import it in the restructured form. | + | |
| - | + | ||
| - | - Insert group by column\\ {{:help:insert_group_by_column.jpg|}} | + | |
| - | - Transfer first variable (Male) by renaming it to the measure (Height) and populating the group by column (Gender) for that variable\\ {{:help:first_var_into_group_by_col.jpg|}} | + | |
| - | - Transfer second variable by pasting height values below and completing the Gender column with the variable (Female)\\ {{:help:second_var_into_group_by_col.jpg|}} | + | |
| - | - Delete the variable not needed (Female in this case) | + | |
| - | + | ||
| - | NB You could have used 1 for Male and 2 for Female if you preferred and added value labels to Gender once the data was imported into SOFA Statistics. See [[help:variable_details | Setting variable details e.g. labels]] | + | |
| - | + | ||
| - | The same process can be used if there are multiple groups e.g. countries instead of genders. | + | |
| ===== Numbers stored in a text variable ===== | ===== Numbers stored in a text variable ===== | ||
help/data_structure.1427605598.txt.gz · Last modified: 2015/03/29 01:06 by admin
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
