Stats lab 1

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
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 peoples BMI scores using the definitional formula (text page 38.) Calculate the Standard Deviation of everyones 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 sections mean fall? SEM= SD/ n, SD=3.33, n=107 =3.33107 =3.33/10.34408 = .3219 My sections mean falls within 1 SE of the overall mean. 23.21+.3219=23.53, 23.21-.3219=22.89. My sections 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

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 Right Arrow Icon
Ask a homework question - tutors are online