Customer No.	Expenditure $	Local?
1	65	0
2	125	1
3	155	1
4	340	1
5	355	1
6	285	1
7	185	1
8	230	1
9	340	0

10	130	1
11	90	0
12	130	1
13	370	1
14	190	0
15	210	1
16	390	0
17	335	0
18	45	1
19	365	1
20	150	0

21	365	1
22	285	0
23	80	1
24	385	0
25	395	1
26	235	0
27	135	1
28	370	1
29	245	0
30	115	1
31	140	1

32	220	1
33	60	0
34	240	1
35	335	0
36	240	0
37	235	1
38	85	1
39	155	1
40	385	0
41	190	1
42	165	0

43	210	0
44	375	1
45	160	0
46	390	1
47	365	1
48	330	1
49	170	1
50	300	0
51	185	0
52	120	1

53	215	0
54	295	1
55	350	1
56	125	0
57	165	1
58	300	1
59	295	1
60	150	0
61	170	0
62	130	0

63	150	1
64	260	0
65	200	0
66	315	0
67	170	1
68	285	0
69	350	1
70	285	1
71	195	1
72	130	0
73	210	1
74	595	0
75	155	0
76	130	1
77	295	1
78	215	1
79	320	0
80	140	0
81	395	0
82	275	0
83	185	1
84	350	1
85	260	0
86	220	1
87	160	1
88	225	1
89	165	0
90	290	1
91	220	0
92	205	0
93	300	1
94	130	0
95	165	0
96	150	1
97	235	1
98	245	1
99	115	1
100	170	1

232.05

99.30591192

You run the local CostCo store, and are interested in how much people spend per visit to the store, on average, and whether they are "local" or come from some distance. The store has conducted a survey tocheck on total expenditure (at the door on the way out) and to ask about the customer's postal code, whichtells whether the customer is local. The results from a sample of 100 customers are stored in the spreadsheetCostCo.xlsx (Link below and copy/paste below). a) What is your estimate of the size of the average expenditure per visit (including a 95% confidence interval to indicate how accurate this is)? b) What is your estimate of the proportion of customers who are local (again, include a 95% confidence interval to indicate how close your estimate is likely to be to the true value)? c) The CostCo head office has said that each store should strive for an average expenditure per visit of at least $250. Does your store meet this criterion based on your sample evidence? Set up the head office statement as a hypothesis test, and draw a conclusion based on the data. Use a level of significance for the test, ? = .05.

Sample Data looks like this: