skip to Main Content

Stop worrying about assignment deadlines, let us help with this paper!

Smart students don’t copy paste information from all over the web hoping to get a good grade! Watch the video below to learn what they do:

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.
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?

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.
Use the following headings and subheadings to organize your paper:

Defining and explaining concepts

Central tendency
Standard deviation
Difference between two group means

Computation results


Overall sample

Standard deviation

Overall sample

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

Discussion of results
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.



Once you place a custom order, our experts will start working on your paper in as little as 5 minutes. What’s more, we’ve never missed a single deadline! You never have to waste your precious time copying and pasting information from all over the web in order to write a paper ever again!


As a student, you can’t afford to spend a whole lot of money to get your paper written by a pro. With us, you don’t have to! We offer custom papers from as little as $13.99 per page! Additionally, if you have an exceptionally large order, we offer 20% discount.


Researching, sourcing, and writing each of our academic papers is done by a team of professional tutors according to your exact specifications. This long process provides you with absolute assurance that the work which you purchase from us has not been plagiarized.


We take your privacy very seriously. In this spirit, we retain absolutely no personal information regarding you once your project has been completed. Moreover, no customer payment information is available on our end since we use Paypal as our third-party payment processor.

Back To Top