Data analysis

HSTA Lifestyles Project

Analyzing Data

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’ (ex: 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…?

Ex: Is the heart rate for females the same or different for males?
Ex: Is the lo-fat intake of participants in WV the same or different from Mali?
Ex: Do females tend to take vitamins more than males?
Ex: Is the heart rate for females the same or different for males?
Ex: Are the bmi’s for females the same or different for males?
Ex: 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. *******

back to Lifestyles Project

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.

back to Lifestyles Project

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’ (ex: your club name). ‘Save as’ your Excel file and give it a new name that you will remember.

1st Set Examples:	How similar or different one measurement is from another…?
	Ex: Is the heart rate for females the same or different for males? Ex: Is the lo-fat intake of participants in WV the same or different from Mali? Ex: Do females tend to take vitamins more than males? Ex: Is the heart rate for females the same or different for males? Ex: Are the bmi’s for females the same or different for males? Ex: 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. *****