Computing a Computing a Correlated-Samples t Test

After you have built your own Excel spreadsheet based on watching the video tutorial "Computing a t Test For a Correlated Samples Design: Excel Video Tutorial (37:01)," edit your spreadsheet to enter the following scores for the Pretest:

Student	Pretest Scores
A	44
B	32
C	33
D	39
E	34
F	20
G	25
H	27
I	6
J	19

Note: These new scores are the same ones used in Evaluation 4. However, be careful to replace only the pretest scores with these new scores. Do not change the scores for the posttest. Also note that a period is used to denote a decimal point (some participants may be accustomed to using a comma instead, but using a comma will result in the answer being scored as incorrect).

Suggestion: Choose to "save as" and give the spreadsheet a new name to show that it is the "quiz" version. The reason is that you will need the original spreadsheet (with the original scores) when you complete the next Excel video tutorial.

Answer the following question based on these new scores.