Statistics Excel

DATASET.xlsx

Week 3

RESULTS OF CONCEPT RATING FOR NEW WINE COOLER							IDEAL TEMPERATURE
Rating of the appeal of the phrase as it relates to the new wine cooler	Total Sample	Gender		Age			52
		Male	Female	21 - 24	25 -34	35-49	46
Extremely appealing (5)	151	68	83	48	63	40	50
Somewhat appealing (4)	91	51	40	36	32	23	42
Neither appealing nor not appealing (3)	36	21	15	9	16	11	52
Somewhat unappealing (2)	13	7	6	4	6	3	50
Not at all appealing (1)	9	3	6	4	3	2	39
							44
							49
							39
QUANTITY PURCHASED PER PERSON IN ONE MONTH							47
# of six packs purchased	# people who purchased this amount						46
0	7						43
1	6						52
2	6						49
3	13						47
4	14						49
5	12						52
6	10						50
7	5						47
8	5						49
9	5						38
10	2						57
							49
							49
							57
							45
							58
							54
							44