Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started