EARTHSC 1100 Lecture Notes - Lecture 3: Standard Deviation, Decimal Mark, Microsoft Excel
18 Jan 2018
School
Department
Course
Professor
Document Summary
Student height excel sheet (canvas: modules/material for exam 1/studentheightes1100. xlsx) Scienti cally testable hypothesis: female students in es1100 are taller than male students in es1100. Record height (in cm or inches) and gender of each student in class. He might ask us on an exam what"s the average and what"s the standard deviation? . Tells you (on this chart) that the average female is 65. 9 inches plus 3. 5 inches, or minus 3. 5 inches. Asked 20 girls their heights, average is 65. 9 inches. Asked two guys their heights, they were both 65 inches. Point of this is that though this supports his hypothesis, it is a biased sample. He then did it for real (asked 20 random guys) Average height for the guys is 71. 4 inches. Tells you the statistical signi cance that there is a di erence between the two sets of data. The smaller the p-value, the more likely it is that there"s a di erence.
