Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Now that the mean and standard deviation have been found, the STANDARDIZE function can be used to find the z-score for the sixth patient. Refer

image text in transcribed
Now that the mean and standard deviation have been found, the STANDARDIZE function can be used to find the z-score for the sixth patient. Refer to your Excel spreadsheet. The STANDARDIZE function has the format STANDARDIZE(value to find the z-score of, sample mean of data, sample standard deviation of data). The amount of time the sixth patient had to wait in an office with a tracking system is located in cell |C7 V| . The sample mean and standard deviation of the data was computed in cells C12 and C13, respectively. Thus in cell E7, the formula to use to find the z-score for the sixth patient is =STANDARDIZE(| C7, $C$12, $C$13 \\/1 ). Enter this value below, rounding to two decimal places. Patient Number | Without Tracking | With Tracking | z-score without tracking | z-score with tracking 1 23 32 2 68 12 3 18 15 4 19 19 5 30 13 6 43 38 [ x 7 13 10 8 24 14 9 15 1 10 38 14 0.53 Mean 20.1 17.8 Standard Deviation | 16.776 9.496 'Submit || Skip (you cannot come back) |

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intro Stats

Authors: Richard D. De Veaux, Paul F. Velleman, David E. Bock

3rd edition

321533283, 321533289, 9780321463708, 9780321503848, 9780321503800, 9780321499431, 9780321499417, 978-0321500458

More Books

Students also viewed these Mathematics questions

Question

They provide space for marginal glosses.

Answered: 1 week ago