HSTA Students say: "Now that I filled out survey forms with participant’s data, how do I draw conclusions???"
Its’ easy! Just follow the steps:
Enter your data in Excel: You need the completed survey forms and Lifestyles Excel file.
| 1. |
Open the Lifestyles Data Excel file (e-mail Jenny for this) |
| 2. |
Examine the worksheets at the bottom of the excel file. |
| 3. |
Click on the worksheet named 'blank'. |
| 4. |
Enter all your data from the survey forms into the appropriate columns (headings at top).
Click here for
Instructions for entering Blood Pressure, or Yes/No/Not sure, other |
| Please note: |
Never use a person’s real name. |
| 5. |
You can copy/paste your data into the total Lifestyles excel file OR copy/paste some of the total Lifestyles data into your worksheet to make comparisons. |
| 6. |
Add columns or change column names to a name you like.
Rename this ‘blank’ worksheet with a new name by ‘right clicking’ (e.g., your club name).
‘Save as’ your Excel file and give it a new name that you will remember. |
Eyeball your data: What questions might you have about relationships in your data?
| 1st Set Examples: |
How similar or different one measurement is from another…? |
|
Example: Is the heart rate for females the same or different for males?
Example: Is the lo-fat intake of participants in WV the same or different from Mali?
Example: Do females tend to take vitamins more than males?
Example: Is the heart rate for females the same or different for males?
Example: Are the bmi’s for females the same or different for males?
Example: Is the pre/top/bp number different between Mali males and WV males? |
| If you ask these types of questions, click on TTEST. |
| 2nd Set Examples: |
If one measurement increases or decreases, does it affect another measurement…? |
|
Ex: Does a person’s heart rate go up as their bmi goes up?
Ex: If a person has a high bmi, does this mean they are likely to have high blood pressure?
Ex: If a person has a low bmi, does this mean they are likely to have a lower heart rate?
Ex: If a person has a low pre/top/bp number (initial systolic), is their heart rate likely low?
Ex: For persons who report lo sugar diets, are they likely to also have low bmi?
|
| If you ask these types of questions, click on CORRELATIONS. |
|