Calculate the percentage of wine coolers served at the ideal temperature, between 49 and 55 degrees? Do
Fantastic news! We've Found the answer you've been seeking!
Question:
Do NOT include the % symbol with your response. Answer format: ##.
Hint:
Find Z for 49 and for 55 by using the STANDARDIZE formula with the mean and standard deviation values.
Find P(z) by using the NORM formula and the Z value.
Find the percentage by subtracting the two P(z) values.
Z | 1.3400 | =STANDARDIZE(55,MEAN,STANDARD DEVIATION) |
P(z) | 0.9099 | =NORM.S.DIST(Z VALUE,TRUE) |
0.5649 | 0.9099 | Difference between 49 and 55 degrees is 34% |
Mean | 48.17 | =AVERAGE(Wk3DATA!$B$30:$B$59) |
Standard Deviation | 5.10 | =STDEV(Wk3DATA!$B$30:$B$59) |
Z | 0.1634 | =STANDARDIZE(49,MEAN,STANDARD DEVIATION) |
P(z) | 0.5649 | =NORM.S.DIST(Z VALUE,TRUE) |
Related Book For
Fundamentals of Analytical Chemistry
ISBN: 978-0495558286
9th edition
Authors: Douglas A. Skoog,Donald M. West, F. James Holler, Stanley R. Crouch
Posted Date: