Calculate the percentage of wine coolers served at the ideal temperature, between 49 and 55 degrees?

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)

 

RESULTS OF CONCEPT RATING FOR NEW WINE COOLER Rating of the appeal of the phrase as it relates to the Total new wine cooler Sample Gender Male Female Extremely appealing (5) 151 68 83 Somewhat appealing (4) 91 51 40 Neither appealing nor not appealing (3) 36 21 15 Somewhat unappealing (2) 13 7 6 Not at all appealing (1) 9 3 6 QUANTITY PURCHASED PER PERSON IN 4 WEEKS # of 6-packs #people who purchased x purchased 0 7 15 1 6 16 2 6 0 2 3 13 4 14 5 12 6 10 7 5 8 5 9 5 10 2 DRINKING TEMPERATURE Sample # Temperature 1 2 3 4 H 5 6 H 7 H 8 a 9 10 11 12 13 14 15 M F 20 16 17 = 18 cat 19 20 21 22 23 24 24 25 20 26 20 27 28 29 30 52 46 50 42 52 94 50 26 39 44 49 39 47 46 43 52 49 47 49 52 50 47 49 38 57 49 49 57 45 58 54 44 Age 21-24 25-34 48 36 9 4 4 63 32 16 6 3 35-49 40 23 11 3 2