Stats lab 1

# Stats lab 1 - BMI score for 1-5 24.09 23.04 24.19 23.19...

This preview shows pages 1–2. Sign up to view the full content.

Brittany Haynes Kin 3502 Section 5 11/17/10 Stats Lab 1 1. Create a frequency distribution table of the BMI scores (use the whole number eg. 23.2 and 23.8 would both be in the 23 line). Do this by creating a table like the one on page 37 of your text, with a column for the score (X), the frequency for each score (f), and the cumulative frequency (cf). [HINT: Sort the data by using the sort feature under the “data” tab to organize the scores] See Excel Sheet 2. Group BMI scores by intervals of 3 and create a graph that represents the distribution of scores. (Example in text) See Excel Sheet 3. Determine the modes and the medians of the BMI and 1 RM bench press scores. See Excel Sheet 4. Calculate the mean of the first 5 people’s (id #s 1-5) BMI scores by hand (plug the numbers into the formula; show your work). Calculate the means of everyone’s BMI and 1 RM bench press scores using EXCEL (To two decimal places). Calculate the mean for the BMI for your section using EXCEL. Mean= (∑X)/n

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: BMI score for 1-5 24.09, 23.04, 24.19, 23.19, 25.65 = (24.09+23.04+ 24.19+ 23.19+ 25.65)/5 = (120.16)/5 = 24.032 See Excel Sheet 5. Calculate the Standard Deviation (SD) of the first 5 people’s BMI scores using the definitional formula (text page 38.) Calculate the Standard Deviation of everyone’s BMI and 1 RM bench press using EXCEL. Calculate the SD for the BMI for your section using EXCEL. SD =√ [∑ (x- mean) 2 ]/ (n-1) ∑X =120.16, ∑(X-mean)=0, ∑(X-mean) 2 =4.339 = √ 4.339/(5-1) = √ 1.08475 = 1.0415 See Excel Sheet 6. Calculate the Standard Error of the Mean for the BMI scores for the whole class. Within how many SEs of the mean does your section’s mean fall? SEM= SD/ √n, SD=3.33, n=107 =3.33√107 =3.33/10.34408 = .3219 My section’s mean falls within 1 SE of the overall mean. 23.21+.3219=23.53, 23.21-.3219=22.89. My section’s mean is 23.44 and falls in the range of 22.89 to 23.53. Brittany Haynes Kin 3502 Section 5 11/17/10...
View Full Document

{[ snackBarMessage ]}

### Page1 / 2

Stats lab 1 - BMI score for 1-5 24.09 23.04 24.19 23.19...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online