|
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 the Microsoft Excel computations.
- 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 conducted on the data provided for this assignment and an interpretation of the results of the computations. What do you know about this data set? What is something that you do not yet know about this data?
Final product should include the Microsoft Excel computations and a 5-page Microsoft Word document, utilizing a minimum of four scholarly sources. Make sure to employ proper grammar and spelling and apply current APA standards for writing style.