How long the customer spent in the mall

Question

Discuss the below:

Given the following case scenario:

One hundred customers at the Mall of Elbonia (MoE) were given a brief interview as they concluded their shopping trips. Examine the resulting data in the Mall of Elbonia Interview Results file. For each customer (by row), the spreadsheet attached contains data on:

The customer's gender.

How long the customer spent in the mall.

How much he or she spent on food and clothing purchases.

The customer's rating of the mall's friendliness and attractiveness.

A. MoE's concessions manager believes the average amount that mall customers spend on food during a visit has increased over the historical average of $18.75, due to the opening of some new upscale restaurants in the mall. Use the data in the file to test his hypothesis.

- What is the null hypothesis?

- Would you reject it at alpha = .05?

B. In the past, management at the Mall of Elbonia has found that their clientele was about 55% women and 45% men. However, the new director of marketing believes that the ratio might be moving away from that traditional figure to one that is not so skewed towards women.

Do the data in the sample represented in the Excel file support his contention at the .05 level of significance?

Mall of Elbonia Interview Results
Customer	Gender	Clothing	Food	Time in Mall	Friendliness	Attractiveness
1	1	$65	$16	51	8	9
2	0	$139	$17	40	5	8
3	0	$186	$22	231	3	1
4	1	$125	$24	131	5	8
5	1	$193	$17	20	3	3
6	0	$186	$20	204	2	1
7	1	$60	$18	61	4	3
8	1	$231	$18	64	1	5
9	1	$83	$20	84	5	7
10	0	$157	$20	161	5	5
11	1	$185	$26	148	7	6
12	1	$125	$18	67	10	9
13	1	$174	$17	231	6	4
14	0	$125	$26	165	1	5
15	0	$110	$18	59	9	5
16	0	$164	$18	16	2	3
17	0	$192	$15	174	3	1
18	1	$165	$28	41	7	1
19	0	$123	$18	337	5	4
20	1	$189	$19	63	9	10
21	1	$115	$16	57	8	9
22	0	$116	$27	242	7	8
23	0	$188	$13	12	8	6
24	1	$146	$24	116	9	7
25	1	$184	$24	46	9	7
26	0	$121	$19	146	7	8
27	0	$169	$15	152	4	4
28	1	$95	$16	61	1	1
29	1	$135	$24	71	1	9
30	1	$157	$26	226	9	10
31	0	$163	$12	48	7	10
32	1	$134	$19	289	10	9
33	0	$179	$24	81	6	5
34	0	$144	$21	170	3	5
35	0	$180	$20	53	10	5
36	1	$92	$15	161	9	9
37	1	$154	$19	34	7	8
38	0	$180	$26	111	5	7
39	1	$168	$13	53	6	5
40	1	$117	$25	125	1	1
41	1	$193	$17	101	10	8
42	1	$96	$24	130	9	8
43	1	$118	$13	108	4	1
44	1	$214	$28	109	6	9
45	1	$169	$18	141	2	1
46	1	$113	$16	185	7	9
47	1	$199	$26	95	10	9
48	0	$64	$13	136	5	2
49	0	$177	$23	45	8	4
50	1	$149	$24	102	6	5
51	1	$130	$15	81	9	7
52	0	$186	$24	205	5	8
53	0	$180	$17	26	1	4
54	0	$93	$24	237	1	3
55	1	$114	$15	229	9	8
56	0	$195	$20	39	9	10
57	0	$185	$21	125	5	3
58	1	$81	$15	318	5	9
59	1	$223	$29	64	1	3
60	1	$164	$16	124	2	3
61	0	$119	$17	127	8	7
62	1	$165	$20	89	7	8
63	1	$146	$19	98	3	7
64	1	$87	$24	145	6	8
65	1	$158	$20	124	8	10
66	0	$187	$26	118	7	6
67	0	$113	$12	161	8	2
68	0	$159	$27	42	3	1
69	0	$174	$18	39	2	2
70	0	$169	$21	210	6	1
71	1	$140	$17	242	2	6
72	0	$126	$23	170	1	9
73	0	$177	$18	76	9	8
74	1	$124	$21	149	8	9
75	1	$181	$17	161	7	7
76	1	$124	$26	24	7	8
77	0	$145	$13	77	6	8
78	0	$186	$21	239	3	1
79	1	$118	$24	87	9	4
80	1	$141	$19	20	2	2
81	1	$154	$16	90	1	9
82	0	$161	$20	52	5	4
83	0	$92	$26	97	2	7
84	0	$183	$20	42	10	8
85	0	$215	$15	222	8	9
86	1	$104	$19	167	2	1
87	1	$178	$21	36	8	7
88	1	$155	$18	87	8	7
89	0	$104	$19	213	6	7
90	0	$171	$26	74	10	8
91	0	$172	$17	235	8	1
92	0	$88	$19	56	1	3
93	1	$208	$22	67	9	9
94	0	$98	$19	215	1	1
95	0	$174	$21	46	1	1
96	0	$149	$22	333	10	7
97	0	$140	$23	39	5	1
98	1	$170	$13	39	4	5
99	0	$177	$27	57	1	3
100	0	$79	$17	235	6	8