Answer each question on a separate Excel Sheet using Data Analysis and Data Analysis Plus or XLSTAT.

Analysis: 1) State your chosen method of analysis; 2) present the test results in tables Note: If the question involves hypothesis testing present the null and alternative hypothesis.

Discussion: For each question briefly discus the findings of the study, what do they mean? how can they aide in decision making?

Estimate with 95% confidence the portion of marketing students that took part in coop (code 1 from the dataset).

Years of experince(for Accounting, HR and Marketing)	Marketing Salary	Human Resources Salary	Accounting Salary	Accounting GPA	Coop for Marketing Students
between 1 and 5	46624	28724	53000	3.95	0
between 1 and 5	47624	31524	57500	2.67	1
between 1 and 5	42024	60124	45600	3	1
between 1 and 5	57024	40424	35400	3.45	0
between 1 and 5	53624	33124	55100	3.93	0
between 1 and 5	56424	38124	44300	2.65	0
between 1 and 5	58024	41924	47500	2.98	0
between 1 and 5	62124	42724	34400	3.43	1
between 1 and 5	47324	62424	47600	3.91	0
between 1 and 5	51424	29924	40200	2.63	0
between 1 and 5	43724	52124	56400	3.95	0
between 1 and 5	49024	58724	57500	2.67	0
between 1 and 5	45224	24624	38500	3	1
between 1 and 5	48924	32424	35500	3.45	0
between 1 and 5	41224	50124	51600	3.93	1
between 1 and 5	48124	60824	56100	2.65	1
between 1 and 5	38824	30324	51200	2.98	1
between 1 and 5	32324	56824	58500	3.43	0
between 1 and 5	54924	28024	42400	3.91	0
between 1 and 5	72324	58424	35700	2.63	1
between 1 and 5	49724	44924	47900	3.97	0
between 1 and 5	33624	39224	44200	2.69	1
between 1 and 5	51424	52924	47400	3.02	0
between 1 and 5	62424	42924	40300	3.47	1
between 1 and 5	53124	38924	53100	3.95	0
between 1 and 5	44724	41924	36600	2.67	0
between 1 and 5	38424	34524	39200	3	1
between 1 and 5	48424	39324	46800	3.45	0
between 1 and 5	54024	38824	58500	3.93	0
between 1 and 5	64824	24724	47300	2.65	1
between 1 and 5	40624	38524	51800	3.97	1
between 1 and 5	51124	38524	37700	2.69	1
between 1 and 5	63724	16024	38900	3.02	0
between 1 and 5	47224	48524	35400	3.47	0
between 1 and 5	36924	38824	45100	3.95	1
between 1 and 5	54824	34524	64500	2.67	0
between 1 and 5	58724	46824	47400	3.96	1
between 1 and 5	51724	63624	54700	2.68	1
between 1 and 5	41924	61024	40800	3.8	0
between 1 and 5	59924	47924	37500	2.72	0
between 1 and 5	58424	24924	37300	3.05	0
between 1 and 5	51924	34624	42800	3.5	1
between 1 and 5	47824	47124	51600	3.98	0
between 1 and 5	39324	53124	55300	2.7	1
between 1 and 5	58124	40924	42300	3.99	0
between 1 and 5	34724	35324	51500	2.71	1
between 1 and 5	52324	56024	38100	3.99	1
between 1 and 5	53424	69024	40500	2.75	0
between 1 and 5	41024	56824	41600	3.08	0
between 1 and 5	46224	48824	56400	3.53	0
between 1 and 5	44824	28424	48500	3.48	0
between 1 and 5	38424	42324	55900	3.43	1
between 1 and 5	52724	51424	40400	3.38	0
between 1 and 5	49424	54024	34500	3.33	0
between 1 and 5	63124	49824	54200	3.28	0
between 1 and 5	42524	50124	60100	3.23	0
between 1 and 5	45024	60124	25400	3.18	1
between 1 and 5	55624	43924	35100	3.13	0
between 1 and 5	56024	41224	36400	3.08	1
between 1 and 5	54924	30424	46600	3.03	0
between 1 and 5	59524	50224	55700	2.98	1
between 1 and 5	51524	54224	38900	2.93	0
less than 1	44424	32424	85100	3.7	1
less than 1	32524	35124	44600	3.84	1
less than 1	49724	52924	40700	3.22	1
less than 1	47124	44124	44800	3.78	0
less than 1	46324	37824	43500	3.26	0
less than 1	36224	41124	46800	3.21	1
less than 1	42724	43824	50700	3.16	0
less than 1	40924	37624	51100	3.11	1
less than 1	41524	36924	44600	3.19	1
less than 1	47624	44824	37500	1.95	0
less than 1	56824	31124	45700	2.28	0
less than 1	48324	55924	48800	2.73	0
less than 1	50424	50724	55800	2.68	1
less than 1	36924	51324	56300	2.63	0
less than 1	53424	36324	40900	2.58	1
less than 1	46424	65124	45000	2.53	0
less than 1	40624	42124	41300	2.48	1
less than 1	52224	57624	46400	2.43	1
less than 1	32824	53024	49200	3.92	0
less than 1	61224	54724	40600	2.64	0
less than 1	47024	43624	47900	3.96	0
less than 1	36324	44124	41700	2.68	0
less than 1	44024	42024	47900	3.01	1
less than 1	40624	51224	68600	3.46	0
less than 1	45124	43524	55100	3.94	0
less than 1	59924	46324	34200	2.66	0
less than 1	45524	46924	52300	3.95	0
less than 1	43924	31924	44000	2.67	1
less than 1	36624	40824	40400	3.99	0
less than 1	44024	39724	39100	2.71	1
less than 1	64724	37824	48500	3.04	1
less than 1	46424	48024	46200	3.49	1
less than 1	49824	44524	43000	3.97	0
less than 1	40524	40824	48300	2.69	0
less than 1	50624	57324	45300	3.98	1
less than 1	56624	57224	50600	2.7	0
less than 1	39924	41624	50000	2.66	1
less than 1	51524	51924	46800	2.99	0
less than 1	30624	44224	44000	3.44	1
less than 1	50724	62424	37000	3.92	0
less than 1	33824	33924	40200	2.64	0
less than 1	52424	38324	55400	3.96	1
less than 1	52324	41724	54000	2.68	0
less than 1	51324	57224	41500	3.01	0
less than 1	51524	52424	51000	3.46	1
less than 1	48824	37824	45500	3.94	1
less than 1	46524	56324	44800	2.66	1
less than 1	57624	42724	51100	2.99	0
less than 1	60124	39224	53300	3.44	0
less than 1	47524	38024	51500	3.92	1
less than 1	37124	35824	43200	2.64	0
less than 1	32624	61824	51900	3.98	1
less than 1	53724	46824	45900	2.7	1
less than 1	46924	34524	38900	3.03	0
less than 1	36324	33924	42900	3.48	0
less than 1	38124	34024	45400	3.96	0
less than 1	69424	46924	51600	2.68	1
less than 1	41124	38824	44600	3.01	0
less than 1	48224	18224	35900	3.46	1
less than 1	60424	43724	49600	3.58	0
less than 1	70524	62524	33400	2.66	1
less than 1	47524	23324	49300	3.98	0
more than 5	44024	62324	49500	3.4	1
more than 5	67024	63124	51600	3.76	1
more than 5	46824	32524	50000	2.96	0
more than 5	66624	52624	50000	2.45	0
more than 5	40624	46624	53700	3.46	1
more than 5	51324	38024	43000	3.59	0
more than 5	44924	47424	47900	2.66	1
more than 5	48324	53924	50400	2.99	0
more than 5	54224	54124	43600	1.86	1
more than 5	56724	24024	43500	2.19	0
more than 5	38924	43824	44500	2.64	0
more than 5	57324	53124	60000	3.12	1
more than 5	51924	56824	50600	1.84	0
more than 5	52324	46524	36600	3.18	0
more than 5	59924	46624	44000	1.9	1
more than 5	50024	23324	40100	2.23	1
more than 5	46724	43224	47700	2.68	1
more than 5	40224	44324	42500	2.66	0
more than 5	43724	55524	51100	3.98	0
more than 5	46124	64824	54300	2.7	1
more than 5	28424	17124	43500	3.03	0
more than 5	36624	56824	37600	3.48	1
more than 5	39224	53224	37200	3.55	1
more than 5	49724	34224	57500	2.68	0
more than 5	39424	42924	35100	3.97	0
more than 5	49124	39324	42300	2.69	0
more than 5	44024	37324	34500	2.65	1
more than 5	45124	55524	43300	2.98	0
more than 5	40524	32424	30400	3.43	1
more than 5	55724	43524	56400	3.91	0
more than 5	46424	41324	45800	2.63	1
more than 5	45324	44824	46500	3.56	1
more than 5	46624	50124	50300	2.67	0
more than 5	44224	37124	50100	3	0
more than 5	44624	51224	44000	3.45	0
more than 5	63124	32824	54000	3.27	0
more than 5	25524	37024	47600	3.22	1
more than 5	62024	41024	46600	3.17	0
more than 5	42624	46224	54100	3.12	0
more than 5	35124	48224	54800	3.2	0
more than 5	47224	49524	49900	1.96	0
more than 5	48924	19124	46500	2.29	1
more than 5	34724	42824	33700	2.74	0
more than 5	45824	40324	47200	2.69	1
more than 5	53624	48724	42600	2.64	1
more than 5	27224	41424	47900	2.59	1
more than 5	55124	38824	58400	2.54	0
more than 5	58124	47124	40400	2.49	0
more than 5	40224	33624	48500	2.44	1
more than 5	48324	61124	60200	3.93	0
more than 5	41924	39824	66600	2.65	1
more than 5	41224	36724	44600	3.56	0
more than 5	44624	64324	34100	2.69	1
more than 5	52324	36324	52400	3.02	0
more than 5	63824	44524	43400	3.47	0
more than 5	69724	55824	38200	3.95	1
more than 5	41624	49824	52000	2.67	0
more than 5	41524	65424	45300	3.56	0
more than 5	55224	64324	39500	2.68	0
more than 5	55624	53624	41500	3.5	1
more than 5	63024	45524	60800	2.72	0
more than 5	55824	48124	33900	3.05	0