Computing z Scores for a Set of Student Scores

After you have built your own Excel spreadsheet based on watching the video tutorial "Computing The Standard (z) Scores of A Set of Student Scores: Excel Video Tutorial (8:11)," edit your spreadsheet to enter the following scores for all of the students:

Student	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 2. 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 questions based on these new scores.