The smarter way
to do assignments.

Please note that this is just a preview of a school assignment posted on our website by one of our clients. If you need assistance with this question too, please click on the Order button at the bottom of the page to get started.

Assignment 2: RA 1: t-Tests
Working with Data in Microsoft Excel
Once again, reading about t-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 t-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.
NameTest 1Test 2Test 3Lyle889289Jorge788278Kim348762Frances768232Tomeca668864

Enter the above data into Microsoft Excel.
Using Microsoft Excel, compute the mean for each test, each student, and the sample overall.
Using Microsoft Excel, compute the standard deviation for each test, each student, and the sample overall.
Using Microsoft Excel, create a correlation table for Test 1, Test 2, and Test 3. Interpret the results.
Conduct a t-test to see if there is a significant difference in scores between Test 1 and Test 2. Interpret the results.
Include a printout of your Microsoft Excel computations with your paper submission.
Explain the concepts of central tendency, variance, standard deviation, correlation, and the difference between the means of two groups.

Your final product should include the Microsoft Excel computations and a 3- to 5-page Microsoft Word document, utilizing a minimum of three scholarly sources. Make sure you employ proper grammar and spelling and apply current APA standards for writing style to your work.

Defining and explaining concepts

Central tendency
Variance
Standard deviation
Correlation
Difference between two group means

Computation results

Mean

Tests
Students
Overall sample

Standard deviation

Tests
Students
Overall sample

Correlation for the three tests
t-test between Test 1 and Test 2

Discussion of results
References
Appendix (Microsoft Excel printout)

Submission Details:

By the due date assigned, save your paper as M3_A2_Lastname_Firstname.doc and Microsoft Excel computations as M3_A2_Lastname_Firstname.xls and submit these to the Submissions Area.

GET HELP WITH THIS ASSIGNMENT TODAY

Clicking on this button will take you to our custom assignment page. Here you can fill out all the additional details for this particular paper (grading rubric, academic style, number of sources etc), after which your paper will get assigned to a course-specific writer. If you have any issues/concerns, please don’t hesitate to contact our live support team or email us right away.