You will compute the z score based on the mean standard devi

You will compute the z score based on the mean, standard deviation, and x provided.

The mean and standard deviation are constant for all three questions.

Each question will use a different X.

You must use the correct Excel 2010 function for 100% credit.

Part 1 - Compute z Scores (8 points)

Mean =	15	Standard Deviation =	3.4

	X	z Score
Question 1	18
Question 2	20
Question 3	17
Part 1 - Questions 1, 2, and 3 You will compute the z score based on the mean, standard deviation, and x provided. The mean and standard deviation are constant for all three questions. Each question will use a different X. You must use the correct Excel 2010 function for 100% credit.

Consider:

Here, I placed the mean at B1, and standard deviation at E1. Hence, I wrote the formula for the first z score

=(B4-$B$1)/$E$1

Then I copied and pasted this in that column. These are the results.