Wednesday, October 26, 2011

T-tests Assignment

I have really struggled with this assignment.  Technical issues have been a big part of it.  I was able to do the age and discussion posts tests at work on Excel 2007.  This was after I copied the Google doc. at home and sent it to my email address at school.  The browser on my computer at school does not support the Google Chrome or Google Docs.he worksheet that our class received.  When I copied the spreadsheet and pasted it into Excel at work I selected the entire worksheet and sorted the age column.  I then added the data analysis toolkit to Excel.  I did this by selecting tools in Excel and then selecting add-ins.  I selected the data analysis toolkit and hit OK.  When I finished this I selected data analysis in tools and scrolled down to T-test 2 sample assuming equal variances.  I selected number of discussion blogs for ages 22 to 30 and then the number of discussion of blogs for ages 32-57.  I clicked OK and the statistics replaced the spreadsheet in a box that I widened the columns of to reveal all of the data. This was my result
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.

This assignment fits into the NETS-T standard 2.  This assignment definitely was a digital age learning experience and required completing assessments.

No comments:

Post a Comment