Ways to perform a statistical test

Question

Discuss the below in detail:

Q: A market research consultant hired by the Pepsi-Cola Co is interested in determining whether there is a difference between the portions of female and male consumers who favor Pepsi Cola over Coke Classic in a particular urban location. A random sample of 250 consumers from the market under investigation is provided in the file PepsiCoke.xls

a. Separate the 250 random samples by gender, perform a statistical test to determine if there is a difference at the alpha = .10 level.

b. Marketing managers at the Pepsi-Cola company have asked their market research consultant to explore further the potential differences in the portions of women and men who prefer drinking Pepsi to coke Classic. Specifically, Pepsi managers would like to know whether the potential difference between the portions of female and male consumers who favor Pepsi varies by age of the consumer. As such, assess whether this difference varies across the four given age categories. Employ a 10% significance level.

Randomly Selected Consumer Preferences Regarding Coke Classic vs. Pepsi-Cola
Consumer	Gender	Age	Preference
1	F	Over 60	Coke
2	F	Between 40 and 60	Coke
3	M	Between 40 and 60	Coke
4	F	Over 60	Pepsi
5	M	Between 20 and 40	Coke
6	F	Between 20 and 40	Pepsi
7	F	Between 20 and 40	Coke
8	F	Between 40 and 60	Pepsi
9	F	Between 20 and 40	Pepsi
10	F	Between 40 and 60	Pepsi
11	F	Over 60	Pepsi
12	F	Between 20 and 40	Coke
13	F	Over 60	Pepsi
14	F	Between 40 and 60	Pepsi
15	F	Between 40 and 60	Pepsi
16	F	Between 20 and 40	Coke
17	F	Between 20 and 40	Pepsi
18	F	Between 40 and 60	Pepsi
19	F	Over 60	Coke
20	F	Between 20 and 40	Coke
21	M	Over 60	Coke
22	F	Between 40 and 60	Pepsi
23	F	Between 40 and 60	Pepsi
24	F	Between 40 and 60	Coke
25	F	Between 20 and 40	Coke
26	M	Between 20 and 40	Coke
27	M	Between 20 and 40	Coke
28	F	Over 60	Pepsi
29	F	Between 20 and 40	Pepsi
30	F	Between 40 and 60	Pepsi
31	F	Between 20 and 40	Coke
32	F	Between 20 and 40	Coke
33	F	Between 20 and 40	Pepsi
34	F	Between 40 and 60	Pepsi
35	F	Between 20 and 40	Pepsi
36	F	Between 40 and 60	Coke
37	F	Between 40 and 60	Coke
38	M	Between 20 and 40	Coke
39	F	Between 20 and 40	Pepsi
40	F	Between 40 and 60	Pepsi
41	M	Less than 20	Coke
42	M	Less than 20	Coke
43	F	Between 40 and 60	Coke
44	F	Over 60	Pepsi
45	M	Less than 20	Pepsi
46	F	Between 20 and 40	Pepsi
47	M	Between 20 and 40	Coke
48	F	Over 60	Coke
49	F	Between 20 and 40	Pepsi
50	F	Between 20 and 40	Coke
51	F	Between 40 and 60	Coke
52	F	Between 20 and 40	Coke
53	F	Over 60	Pepsi
54	F	Between 40 and 60	Pepsi
55	F	Between 20 and 40	Pepsi
56	F	Over 60	Pepsi
57	F	Between 40 and 60	Pepsi
58	M	Between 40 and 60	Coke
59	F	Between 20 and 40	Pepsi
60	M	Over 60	Coke
61	F	Between 20 and 40	Coke
62	M	Between 20 and 40	Pepsi
63	F	Over 60	Pepsi
64	M	Between 40 and 60	Coke
65	M	Between 40 and 60	Coke
66	F	Between 20 and 40	Pepsi
67	F	Between 40 and 60	Coke
68	M	Over 60	Pepsi
69	F	Between 20 and 40	Coke
70	M	Between 20 and 40	Pepsi
71	F	Over 60	Pepsi
72	M	Over 60	Pepsi
73	F	Between 40 and 60	Pepsi
74	F	Between 20 and 40	Coke
75	F	Between 40 and 60	Coke
76	M	Between 40 and 60	Pepsi
77	F	Between 40 and 60	Coke
78	M	Between 20 and 40	Coke
79	F	Between 40 and 60	Coke
80	F	Between 20 and 40	Pepsi
81	M	Over 60	Coke
82	M	Between 40 and 60	Pepsi
83	F	Between 40 and 60	Coke
84	F	Between 20 and 40	Coke
85	M	Less than 20	Coke
86	F	Between 40 and 60	Coke
87	M	Between 40 and 60	Coke
88	M	Between 20 and 40	Coke
89	F	Between 40 and 60	Coke
90	M	Between 40 and 60	Pepsi
91	M	Between 40 and 60	Pepsi
92	M	Between 20 and 40	Coke
93	F	Between 20 and 40	Pepsi
94	F	Over 60	Pepsi
95	F	Between 20 and 40	Pepsi
96	F	Between 20 and 40	Coke
97	F	Between 20 and 40	Pepsi
98	F	Over 60	Pepsi
99	F	Between 20 and 40	Pepsi
100	F	Between 20 and 40	Pepsi
101	F	Less than 20	Pepsi
102	F	Over 60	Pepsi
103	F	Less than 20	Pepsi
104	F	Between 20 and 40	Coke
105	M	Less than 20	Coke
106	F	Between 20 and 40	Coke
107	F	Between 20 and 40	Coke
108	M	Less than 20	Coke
109	M	Between 20 and 40	Pepsi
110	F	Between 40 and 60	Pepsi
111	F	Between 40 and 60	Coke
112	F	Between 20 and 40	Coke
113	M	Less than 20	Coke
114	M	Between 40 and 60	Coke
115	F	Between 20 and 40	Pepsi
116	M	Over 60	Pepsi
117	M	Over 60	Coke
118	F	Between 20 and 40	Pepsi
119	F	Between 20 and 40	Pepsi
120	F	Between 20 and 40	Pepsi
121	F	Over 60	Pepsi
122	F	Between 20 and 40	Coke
123	F	Between 40 and 60	Pepsi
124	F	Between 40 and 60	Coke
125	F	Between 20 and 40	Coke
126	F	Between 20 and 40	Pepsi
127	M	Between 40 and 60	Pepsi
128	M	Between 20 and 40	Coke
129	F	Between 40 and 60	Coke
130	F	Between 20 and 40	Pepsi
131	F	Over 60	Coke
132	M	Over 60	Pepsi
133	M	Between 20 and 40	Coke
134	F	Between 20 and 40	Pepsi
135	F	Between 40 and 60	Coke
136	F	Over 60	Pepsi
137	F	Over 60	Pepsi
138	F	Between 20 and 40	Pepsi
139	F	Between 20 and 40	Pepsi
140	F	Between 40 and 60	Coke
141	F	Between 20 and 40	Coke
142	M	Over 60	Coke
143	F	Between 40 and 60	Pepsi
144	F	Between 20 and 40	Pepsi
145	F	Less than 20	Pepsi
146	F	Between 20 and 40	Pepsi
147	M	Between 20 and 40	Pepsi
148	F	Between 20 and 40	Coke
149	M	Over 60	Pepsi
150	M	Over 60	Coke
151	F	Between 20 and 40	Pepsi
152	F	Between 40 and 60	Pepsi
153	F	Between 20 and 40	Coke
154	F	Between 20 and 40	Pepsi
155	F	Between 40 and 60	Pepsi
156	M	Between 20 and 40	Coke
157	F	Between 40 and 60	Coke
158	F	Between 20 and 40	Coke
159	F	Over 60	Coke
160	F	Between 20 and 40	Coke
161	F	Over 60	Coke
162	F	Between 20 and 40	Pepsi
163	F	Between 20 and 40	Pepsi
164	F	Between 20 and 40	Pepsi
165	F	Between 20 and 40	Pepsi
166	F	Between 20 and 40	Pepsi
167	F	Between 40 and 60	Pepsi
168	M	Between 20 and 40	Coke
169	M	Less than 20	Coke
170	F	Between 40 and 60	Coke
171	F	Over 60	Coke
172	M	Over 60	Coke
173	F	Between 20 and 40	Pepsi
174	M	Less than 20	Pepsi
175	F	Less than 20	Coke
176	M	Between 20 and 40	Coke
177	F	Between 20 and 40	Pepsi
178	F	Between 20 and 40	Coke
179	F	Between 20 and 40	Coke
180	F	Between 20 and 40	Coke
181	M	Less than 20	Coke
182	F	Between 20 and 40	Coke
183	F	Over 60	Pepsi
184	M	Between 20 and 40	Coke
185	F	Less than 20	Coke
186	F	Between 20 and 40	Coke
187	F	Between 40 and 60	Coke
188	M	Between 40 and 60	Pepsi
189	M	Between 40 and 60	Pepsi
190	F	Between 20 and 40	Coke
191	F	Less than 20	Pepsi
192	F	Less than 20	Coke
193	F	Over 60	Coke
194	F	Between 20 and 40	Coke
195	M	Between 40 and 60	Pepsi
196	F	Between 40 and 60	Coke
197	M	Over 60	Coke
198	F	Between 40 and 60	Coke
199	F	Over 60	Pepsi
200	F	Between 20 and 40	Coke
201	F	Between 40 and 60	Coke
202	M	Between 40 and 60	Coke
203	F	Over 60	Pepsi
204	F	Less than 20	Coke
205	F	Between 40 and 60	Pepsi
206	F	Between 20 and 40	Coke
207	F	Between 20 and 40	Coke
208	F	Between 20 and 40	Coke
209	M	Between 20 and 40	Pepsi
210	F	Over 60	Coke
211	F	Between 40 and 60	Coke
212	F	Between 20 and 40	Pepsi
213	F	Less than 20	Coke
214	F	Between 20 and 40	Coke
215	M	Over 60	Coke
216	F	Between 20 and 40	Pepsi
217	F	Between 40 and 60	Coke
218	M	Between 40 and 60	Coke
219	F	Between 20 and 40	Coke
220	F	Less than 20	Coke
221	F	Between 20 and 40	Coke
222	F	Between 40 and 60	Coke
223	M	Between 40 and 60	Pepsi
224	F	Over 60	Coke
225	F	Between 20 and 40	Pepsi
226	M	Between 40 and 60	Pepsi
227	F	Over 60	Pepsi
228	M	Less than 20	Coke
229	F	Over 60	Pepsi
230	F	Between 20 and 40	Coke
231	F	Between 20 and 40	Pepsi
232	F	Over 60	Coke
233	F	Over 60	Coke
234	M	Between 40 and 60	Pepsi
235	F	Between 20 and 40	Coke
236	F	Between 40 and 60	Coke
237	F	Between 20 and 40	Coke
238	F	Between 40 and 60	Coke
239	F	Between 40 and 60	Coke
240	F	Between 40 and 60	Pepsi
241	F	Between 40 and 60	Coke
242	F	Between 20 and 40	Coke
243	F	Between 20 and 40	Pepsi
244	F	Over 60	Coke
245	F	Between 40 and 60	Pepsi
246	M	Between 40 and 60	Pepsi
247	F	Between 20 and 40	Pepsi
248	F	Between 40 and 60	Coke
249	M	Between 20 and 40	Pepsi
250	M	Over 60	Pepsi