Answer Happy

Scientific Investigation- Part 4 Statistical Analysis: Inferential Statistics For statistical analysis, you can use excel spread sheets, google sheets as directed or copy and paste the data into a calculator to get your results. https://www.socscistatistics.com/tests/ 1.Application of t test a) Before performing your t-test, make a frequency histogram showing both male and female heights (use different colors) on the same histogram. (Go to the Si data and look at the first tab (the MW data) in the spreadsheet for an idea of what this should look like). Be sure you modify the axes so that the range and intervals are appropriate. Include labels, a legend (key), and a title. For instructions as to how to make this histogram, go here: How to make histograms b) Now that you can visualize your two populations, compare their means. What is the mean height for males? x male height = What is the mean height for females? female height = c) Now perform a t-test to see if there is a significant difference in their mean heights. Choose a cell and type in = Test(range of first data set, range of second data set. 2. 3) (ex from MW lab data: TTEST (2:07, 02:012, 2:3) Where the 2 is used to indicate a 2-tailed test, and the 3 indicates unequal variance. Google sheets will give you the p-value, which is the probability your calculated t-value occurred by chance alone (not because the populations are really different). If this value is greater than 0.05, your t-test is significant, and indicates there is a statistically significant difference between the means of the two populations (which in our example means that the two populations differ in height). p = Excel gives much more than just the p-value. It produces a table that includes the stat, tant and the p-value. Take a look at the MW lab data where I have added in t-test tables from Excel. I added tables using t-tests for both unequal variance and equal variance so that you can see the differences. (Note that both p-values are not the exact number as the one produced by Google sheets, but the number of decimal places for sheets matches the unequal variance in Excel . It is normal to have variations like this because different programs use slightly different variations and corrections. That is why I ask you to use Sheets for this exercise- so that we are all using the same program and our answers should all be the same.) 1