$($a$)$Considering only offices without a wait tracking system, what is the z$-$score for the tenth patient in the sample $($wait time $=38)?$Recall that the z$-$score can be interpreted as the number of standard deviations a data value is away from the sample mean. It is calculated as follows where zi is the z$-$score for the data value xi$,$ x is the sample mean, and s is the sample standard deviation.zi $=$ xi xsWe can also use the Excel function STANDARDIZE to calculate z$-$scores but we must first compute the sample mean and sample standard deviation. Copy and paste the following data into an Excel spreadsheet.Patient NumberWithout TrackingWith Tracking$12332266123161541919532116453871388241491511103816$In cell B$12,$ find the mean for the wait time at a physician's office without a tracking system using the formula $=$AVERAGE$($B$2$:B$11).$ In cell B$13,$ find the sample standard deviation for the wait time at a physician's office without a tracking system using the formula $=$STDEV.S$($B$2$:B$11).$ Enter these values below, rounding to three decimal places.ABC$1$Patient NumberWithout TrackingWith Tracking$2123323266124316155419196532117645388713898241410915111110381612$Mean$29\mathrm{.}1$ Correct: Your answer is correct. seenKey $29\mathrm{.}113$Standard Deviation$16\mathrm{.}656$ Correct: Your answer is correct. seenKey $16\mathrm{.}65614$Step $2$Now that the mean and standard deviation have been found, the STANDARDIZE function can be used to find the z$-$score for the tenth patient. Refer to your Excel spreadsheet. The STANDARDIZE function has the format STANDARDIZE$($data value to find the z$-$score of$,$ sample mean of data, sample standard deviation of data$).$The amount of time the tenth patient had to wait in an office without a tracking system is located in cell B$11$ Correct: Your answer is correct. seenKey B$11.$ The sample mean and standard deviation of the data was computed in cells B$12$ and B$13,$ respectively. Thus in cell D$11,$ the formula to use to find the z$-$score for the tenth patient is $=$STANDARDIZE$($B$11,$ $B$$12,$ $B$$13$ Correct: Your answer is correct. seenKey B$11,$ $B$$12,$ $B$$13).$ Enter this value below, rounding to two decimal places.ABCD$1$Patient NumberWithout TrackingWith Trackingz$-$score without tracking$212332326612431615541919653211764538871389824141091511111038160\mathrm{.}53$ Correct: Your answer is correct. seenKey $0\mathrm{.}5312$Mean$29\mathrm{.}113$Standard Deviation$16\mathrm{.}65614$Step $3($b$)$Considering only offices with a wait tracking system, what is the z$-$score for the sixth patient in the sample $($wait time $=38)?$ How does this z$-$score compare with the z$-$score you calculated for part $($a$)?$We will again use the STANDARDIZE function in Excel to determine this z$-$score. As before, first calculate the sample mean and sample standard deviation of the data. Since these formulas were already determined for the data in column B$,$ each can be copied and pasted to cells C$12$ and C$13,$ respectively. Doing so gives the following mean and standard deviation, rounded to three decimal places.ABCD$1$Patient NumberWithout TrackingWith Trackingz$-$score without tracking$212332326612431615541919653211764538871389824141091511111038160\mathrm{.}5312$Mean$29\mathrm{.}1$ Correct: Your answer is correct$\mathrm{.}13$Standard Deviation$16\mathrm{.}656$ Incorrect: Your answer is incorrect$\mathrm{.}14$