Question

ID	Insurance	Location	Wait Time	Age	GHSS	Cost
113	Government	Moore	25	78	56	$13,000
114	Government	Moore	44	91	90	$5,000
115	Government	Moore	15	63	66	$13,000
176	Government	Moore	55	85	79	$1,245
177	Government	Moore	60	87	49	$678
178	Government	Moore	45	89	73	$450
180	Government	Moore	33	79	86	$12,000
182	Government	Moore	34	80	57	$900
193	Government	Moore	34	90	99	$8,700
197	Government	Moore	55	89	96	$5,750
197	Government	Moore	56	90	79	$10,000
121	Insurance	Moore	25	52	15	$4,500
124	Insurance	Moore	22	57	61	$1,200
130	Insurance	Moore	55	60	25	$1,200
132	Insurance	Moore	54	59	16	$1,200
160	Insurance	Moore	2	47	14	$1,200
161	Insurance	Moore	56	62	27	$1,200
163	Insurance	Moore	61	66	34	$1,400
166	Insurance	Moore	12	49	77	$4,400
197	Insured	Moore	37	89	99	$12,000
197	Insured	Moore	44	94	86	$55
107	Uninsured	Moore	25	13	99	$7,800
108	Uninsured	Moore	10	60	26	$1,365
110	Uninsured	Moore	45	16	13	$478
126	Uninsured	Moore	60	11	12	$12,000
128	Uninsured	Moore	22	47	16	$4,600
138	Uninsured	Moore	15	74	79	$4,900
149	Uninsured	Moore	14	90	88	$4,500
158	Uninsured	Moore	56	71	45	$1,300
101	Government	Pelican	18	59	89	$8,800
102	Government	Pelican	20	5	1	$680
104	Government	Pelican	43	47	12	$4,977
105	Government	Pelican	15	74	88	$8,890
117	Government	Pelican	39	46	36	$4,950
146	Government	Pelican	14	67	88	$6,600
147	Government	Pelican	13	88	99	$9,450
154	Government	Pelican	44	48	24	$1,200
168	Government	Pelican	13	91	73	$8,700
171	Government	Pelican	14	98	74	$15,000
172	Government	Pelican	55	67	69	$678
173	Government	Pelican	13	66	23	$2,300
174	Government	Pelican	20	7	15	$6,785
175	Government	Pelican	24	74	37	$1,300
181	Government	Pelican	29	24	13	$7,100
184	Government	Pelican	24	51	57	$5,500
185	Government	Pelican	26	19	26	$1,200
187	Government	Pelican	3	78	69	$7,400
188	Government	Pelican	4	76	36	$134
189	Government	Pelican	46	55	23	$1,300
190	Government	Pelican	36	44	16	$1,200
196	Government	Pelican	24	18	19	$1,645
197	Government	Pelican	23	12	18	$195
197	Government	Pelican	47	48	22	$1,430
197	Government	Pelican	14	55	88	$12,800
197	Government	Pelican	13	77	79	$12,000
197	Government	Pelican	25	78	99	$1,800
197	Government	Pelican	19	89	44	$3,000
111	Insurance	Pelican	12	99	73	$900
118	Insurance	Pelican	13	91	94	$10,000
119	Insurance	Pelican	34	17	16	$1,200
123	Insurance	Pelican	56	44	36	$1,630
127	Insurance	Pelican	14	94	74	$550
129	Insurance	Pelican	55	43	46	$4,500
131	Insurance	Pelican	45	30	79	$1,500
134	Insurance	Pelican	36	19	22	$950
135	Insurance	Pelican	31	16	14	$9,000
136	Insurance	Pelican	45	34	99	$4,500
137	Insurance	Pelican	25	9	1	$6,000
140	Insurance	Pelican	20	7	11	$9,000
143	Insurance	Pelican	26	14	66	$650
144	Insurance	Pelican	44	24	36	$1,300
151	Insurance	Pelican	14	64	89	$5,600
152	Insurance	Pelican	15	6	77	$14,000
155	Insurance	Pelican	20	7	24	$850
159	Insurance	Pelican	44	27	48	$15,000
162	Insurance	Pelican	14	88	90	$2,000
167	Insurance	Pelican	13	93	93	$8,999
169	Insurance	Pelican	20	8	36	$960
197	Insured	Pelican	10	65	10	$1,200
197	Insured	Pelican	21	69	79	$4,458
197	Insured	Pelican	27	73	66	$4,600
197	Insured	Pelican	28	74	78	$7,748
197	Insured	Pelican	36	76	19	$1,200
197	Insured	Pelican	25	77	48	$1,400
197	Insured	Pelican	44	78	79	$9,900
197	Insured	Pelican	76	81	89	$4,500
197	Insured	Pelican	38	82	79	$5,000
100	Uninsured	Pelican	45	27	26	$1,500
109	Uninsured	Pelican	89	6	77	$12,000
125	Uninsured	Pelican	56	30	99	$12,000
142	Uninsured	Pelican	61	45	49	$4,680
150	Uninsured	Pelican	23	18	25	$879
165	Uninsured	Pelican	11	5	2	$899
183	Uninsured	Pelican	9	58	63	$1,345
197	Uninsured	Pelican	19	45	86	$4,465

Comparison of Average Wait Times between two locations (Moore and Pelican)

Purpose

Importance

Variables

Sample Size

Hypothesis

Methodology

Findings

Interpretations/Implications

Answer 1

Using excel we find the following statistics

Next, we do the hypothesis testing, as shown below

(Note : Assumption - The variance of the two samples is not equal)