Question: 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 Correct: Your answer is correct. . 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 Correct: Your answer is correct. ). Enter this value below, rounding to two decimal places. A B C D E 1 Patient Number Without Tracking With Tracking z-score without tracking z-score with tracking 2 1 23 32 3 2 68 12 4 3 18 15 5 4 19 19 6 5 30 13 7 6 43 38 Incorrect: Your answer is incorrect. 8 7 13 10 9 8 24 14 10 9 15 11 11 10 38 14 0.53 12 Mean 29.1 17.8 13 Standard Deviation 16.776 9.496 14
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
