Once again, reading about\u00a0t-test statistics and descriptive statistics is one thing. Actually using software to compute them requires different skill sets. This assignment is designed to give you the opportunity to practice using Microsoft Excel to compute a\u00a0t-test and to reinforce your learning of computing descriptive statistics from a previous module. A data set has been presented below for you to use to conduct your analyses. The data set represents the scores from five students who were tested on the same material using three different forms of the test.\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tName\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tTest 1\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tTest 2\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tTest 3\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tLyle\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t88\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t92\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t89\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tJorge\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t78\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t82\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t78\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tKim\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t34\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t87\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t62\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFrances\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t76\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t82\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t32\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tTomeca\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t66\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t88\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t64\t\t\t\t\t\t\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Enter the above data into Microsoft Excel.\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Using Microsoft Excel, compute the mean for each test, each student, and the sample overall.\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Using Microsoft Excel, compute the standard deviation for each test, each student, and the sample overall.\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Using Microsoft Excel, create a correlation table for Test 1, Test 2, and Test 3. Interpret the results.\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Conduct a\u00a0t-test to see if there is a significant difference in scores between Test 1 and Test 2. Interpret the results.\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Include a printout of your Microsoft Excel computations with your paper submission.\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Explain the concepts of central tendency, variance, standard deviation, correlation, and the difference between the means of two groups.\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Include a description of the computations you conducted on the data provided for this assignment and your interpretation of the results of your computations. What do you know about this data set? What is something that you do not yet know about this data?<\/p>\n","protected":false},"excerpt":{"rendered":"
Once again, reading about\u00a0t-test statistics and descriptive statistics is one thing. Actually using software to compute them requires different skill sets. This assignment is designed to give you the opportunity to practice using Microsoft Excel to compute a\u00a0t-test and to Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-225074","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/225074","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=225074"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/225074\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=225074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=225074"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=225074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}