# Looking to get this assignment completed by June 6 at 11:59pm EST but sooner if possible!!!

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.

Name

Test   1

Test   2

Test   3

Lyle

88

92

89

Jorge

78

82

78

Kim

34

87

62

Frances

76

82

32

Tomeca

66

88

64
· 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.
· Defining and explaining concepts
o Central tendency
o Variance
o Standard deviation
o Correlation
o Difference between two group means
· Computation results
o Mean
§ Tests
§ Students
§ Overall sample
o Standard deviation
§ Tests
§ Students
§ Overall sample
o Correlation for the three tests
o t-test between Test 1 and Test 2
· Discussion of results
· References
· Appendix (Microsoft Excel printout)

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our Guarantees

### Money-back Guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism Guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision Policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.