Age and Discussion Posts.
I purchased Excel 2010 Home and Student Edition yesterday trying to continue on with testing more columns in the spreadsheet. I installed the program into my computer and imported the Google document into Excel. I followed the same steps as above with adding the data analysis toolkit. Then I selected the entire worksheet and sorted ages. I am trying to figure out how to get the screen that I got with the T-test outcomes like the one in Excel 2007. So far, I have only been able to get the equal variance and cannot find the new worksheet ply screen. I also cannot copy and paste the t-test pop-up in Excel 10. I saved my results of the screen on Jing and am including the links:
Fake quiz and age
Millinial and Age
Teaching and Discussion Posts
This is the homework that Dr. Pierce assigned. We were to follow the process of sorting the independent variable. Then select T-test and select the cells for array 1 and then select the cells for array 2. I have Excel 10 and I put "1" in tails and "2" in type and the result appears. I used this process to complete my homework. On the browser tests I had to change how the data was sorted for Internet Explorer and Firefox so that the other browsers would appear together in order to complete the T-test.
AGE | Gender | Teaching | |
Score | 0.244535528 | 0.284534544 | 0.064918329 |
D.Posts | 0.003893* | 0.444181273 | 0.064722595 |
MelScore | 0.035912082 | 0.3765718 | 0.014593073 |
Chrome | Firefox | IE | Safari | |
Score | 0.112 | 0.133 | 0.027* | 0.031* |
D.Posts | 0.258 | 0.213 | 0.193 | 0.126 |
MelScore | 0.448 | 0.409 | 0.140 | 0.069 |
I represented my scores in the browser test in thousandths because the example was like this. We were to put an asterisk by any data that was significant. Dr. Pierce gave an example with age and discussion posts and score and Internet Explorer. I put an asterisk by score and Safari because the result of .03 was less than p=.05.
No comments:
Post a Comment