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

Question

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.

Explanation / Answer

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.

Mean = 15 Standard Deviation = 3.4 X                       z Score Question 1 18 0.88235294 Question 2 20 1.47058824 Question 3 17 0.58823529

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.