coursehero.com Find Course Hero Q Search Study Resources Get Instant Tutoring Help Earn by Contributing Question: the probability distribution using the data which shows how many cartons of the wine cooler were bought per customer in a month. Calculate the mean and the standard deviation of your probability distribution. Calculate the probability that exactly 3 six packs will be bought in a month. Calculate the probability that between 4 and 8 six packs will be bought in a month. Calculate the probability that at least 5 six packs will be bought in a month. Calculate the probability that no more than 5 six packs will be bought in a month. Excel File Edit View Insert Format Tools Data Window Help Blank data set.xlsx L> Mon 5:51 PM Rob Nuckles Q = fx 100% HISTOGRAM A Home Layout Tables Charts SmartArt Formulas Edit Font Fill Arial 11 A A- Data Alignment abc Review Number Format Cells Themes Wrap Text General Normal F X Clear B I U Merge %, G.0 .00 .00 Conditional Bad .0 Paste Formatting Aa Insert Delete Format Themes Aa L10 A B C D E F G H I K L M N O P Q 1 2 RESULTS OF CONCEPT RATING FOR NEW WINE COOLER Rating of the appeal of the phrase as it relates Total Gender IDEAL TEMPERATURE Age 52 3 to the new wine cooler Sample Male Female 4 Extremely appealing (5) 151 68 83 21-24 48 25-34 35-49 46 63 40 5 Somewhat appealing (4) 91 51 40 36 32 6 Neither appealing nor not appealing (3) 36 21 15 9 16 7 Somewhat unappealing (2) 13 7 6 4 6 8 Not at all appealing (1) 9 3 6 4 3 23132 50 42 11 52 50 39 44 9 49 10 39 11 23456766OH2345678 1112222 12 13 # of six packs purchased QUANTITY PURCHASED PER PERSON IN ONE MONTH # people who purchased this amount 47 46 43 14 0 7 52 15 1 6 49 16 2 6 47 17 3 13 49 18 4 14 52 19 5 12 50 20 6 10 21 7 5 47 49 22 8 5 38 9 5 24 10 2 57 49 25 49 26 57 27 45 28 |+