Aiming to better understand the differences between salaries of graduates, this University has collected data from a sample 186 members of our alumni. The data include salary of Marketing, HR and Accounting graduates based on years of experience upon graduation from the School of Business. The data reflects:

QUESTION : Perform a statistical test using a 5% significance level to determine whether there is sufficient statistical evidence to infer that there are differences in graduate salary between the 3 streams, differences in years of experience between the three categories, or interaction between graduate salary and experience. (30%)?

Also,

State your chosen method of analysis and Discussion: briefly discus the findings of the study, what do they mean?

- ( im guessing you would use ANOVA: 2 Factor w/o Replication but not sure how to use the data analysis tool in excel to provide an answer)

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