Wednesday, July 17, 2013

Excel 2

I just figured out (MOST OF) the Excel 1 assignment and am now trying to complete the Excel 2 assignment!  Hopefully I will have more to post by tonight!
This assignment did not seem as difficult to figure out as the first.  However, I could not do this in Excel so I had to use the Student's T-Test site that was provided.  I imputed information from two different groups.  The first group was for the males and the second was for the females.  I put the numerical values into the site and calculated for both the One Tailed T-test and the Two Tailed T-test.  I also looked at the link provided that gave detailed information about the differences in the test.  But after reading this site I have to admit that I am still not one hundred percent sure what it all means.  I do know that the I will not reject the null because the P value is less then 5 percent for both tests.  This means that even though there is a difference between male and female scores it is more likely to be do to chance or measurement error then gender.  Below is a Jing capture of my T-Test scores:








One research topic I could have my students test is "Does weight effect how fast an object falls to the ground."  For this the independent variable would be the weight of the objects being dropped and the dependent variable would be the distance in which the object is dropped from.  I could have them drop a quarter and a baseball and have someone time to see how fast they drop.  One error that they may find is the person timing may start or stop differently.

1 comment:

  1. Correct answer = reject the null hypothesis (no difference). P value is less than 0.05
    There is a significant difference
    Pvalue is in scientific notation because it is so friggin small E-7 means spaces to the right of the decimal.
    There are scientific notation calculators on the web.
    There is a difference and it is probably (95%) not related to measurement error.

    ReplyDelete