Provide your analytical analysis for at least 2 criteria's (of all that you have learnt till )using the excel data sheet attached .

 Work on the Excel spread sheet and attach the snap shot of your analysis.

 

PRODUCTION FLOOR DEPARTMENT
Employee ID	Age	Job Title	Compenstation Annually	Benefits Compensation Annually	Years of Service	Vacation (days)	Satisfaction Survey (1-5)	Interpersonal Conflict	Role Ambiguity	Turnover Intentions	Burnout	Performance Score (1-10)
E001	56	Supervisor	64235	5364	20	25	2	3.3	3.5	4.2	2.4	8.95
E002	42	Trade Opeartor	60284	3896	5	10	4	3.8	3.6	1.7	1.5	2.27
E003	69	Labourer	46344	2689	1	10	5	3.3	3.4	4.4	4.0	2.82
E004	36	Labourer	49632	3687	10	15	3	4.0	4.5	2.6	3.8	8.17
E005	36	Labourer	40023	4563	8	15	3	3.7	4.8	1.2	3.8	1.00
E006	58	Supervisor	51001	5101	16	20	2	4.0	3.5	3.3	3.5	8.12
E007	26	Labourer	32000	3695	3	10	4	3.2	3.9	3.7	3.7	4.96
E008	24	Trade Opeartor	49756	2699	2	10	5	2.3	3.5	4.1	1.6	4.36
E009	40	Labourer	36535	4268	12	15	1	2.8	4.1	2.8	2.5	1.00
E010	46	Supervisor	60376	4268	12	15	2	4.8	5.0	5.0	3.6	7.18
E011	31	Labourer	38542	3965	8	12	3	2.0	2.9	1.4	2.8	5.63
E012	28	Labourer	36561	3001	3	10	5	4.3	3.4	3.2	2.9	5.30
E013	33	Trade Opeartor	44452	2963	2	10	4	3.3	4.3	4.4	3.1	3.32
E014	57	Trade Opeartor	56760	5236	17	20	1	4.0	3.7	4.2	3.0	6.20
E015	63	Trade Opeartor	55632	5368	18	20	2	4.0	5.0	3.8	2.6	8.53
E016	58	Labourer	40083	4369	14	12	3	2.7	3.3	4.9	2.1	2.38
E017	40	Labourer	32000	3896	5	10	4	3.8	3.6	4.9	2.5	1.00
E018	49	Trade Opeartor	54337	4268	12	15	2	3.3	4.3	1.7	2.9	3.83
E019	39	Trade Opeartor	52365	4368	13	15	2	3.0	3.9	2.9	3.4	9.24
E020	47	Labourer	49855	4120	9	12	3	4.0	4.0	2.4	3.2	5.25
E021	42	Labourer	46275	4120	9	12	3	3.7	3.2	2.8	2.6	2.13
E022	36	Labourer	47313	3896	5	10	4	4.2	4.4	2.2	4.2	3.85
E023	29	Trade Opeartor	50220	3001	3	10	5	4.8	3.5	4.5	4.0	6.46
E024	26	Manager	59122	2963	2	10	4	3.0	3.4	4.9	3.3	6.68
E025	46	Supervisor	58481	4268	12	15	1	3.8	4.0	4.6	3.1	5.00
E026	57	Trade Opeartor	49856	5101	16	20	2	2.7	3.3	3.4	1.7	3.08
E027	62	Trade Opeartor	47194	3968	6	10	4	3.5	3.0	1.7	2.5	7.15
E028	52	Labourer	39055	3758	4	10	4	3.0	3.8	1.1	1.0	7.18
E029	57	Labourer	50236	4210	10	15	3	3.0	3.4	4.3	2.5	5.06
E030	23	Supervisor	48977	2689	1	10	5	2.7	2.9	1.2	2.1	3.39
E031	27	Trade Opeartor	41785	3001	3	10	4	2.5	3.0	3.1	2.1	8.42
E032	38	Trade Opeartor	50593	4120	9	12	3	3.5	3.5	3.4	2.2	7.77
E033	46	Supervisor	63214	5368	18	20	1	3.2	3.4	3.0	3.1	2.58
E034	49	Supervisor	61268	5101	16	20	2	3.0	3.2	3.2	4.6	4.55
E035	50	Trade Opeartor	48563	3968	6	12	5	3.2	2.5	2.8	2.8	4.50
E036	53	Trade Opeartor	54433	3687	10	15	3	5.0	5.0	4.3	3.4	4.34
E037	48	Labourer	48264	3756	11	15	3	3.3	3.5	2.0	2.1	7.20
E038	33	Labourer	39394	3001	3	10	4	4.7	4.1	3.1	3.8	8.23
E039	65	Supervisor	59699	5368	18	20	2	2.0	1.9	1.4	1.0	4.05
E040	44	Supervisor	56384	5101	16	20	2	2.8	2.6	2.1	2.5	2.77
E041	52	Manager	63598	5426	19	20	1	3.7	3.9	1.7	4.0	8.10
E042	22	Labourer	46344	2689	1	10	5	3.8	4.7	2.8	3.3	6.11
E043	38	Labourer	49632	3687	10	15	3	2.3	3.1	4.5	1.0	3.17
E044	34	Labourer	40023	4563	8	15	3	2.8	3.9	4.0	3.2	7.85
E045	54	Supervisor	51001	5101	16	20	2	3.2	3.4	1.7	3.5	7.61
E046	30	Labourer	32000	3695	3	10	4	3.5	4.4	4.6	3.1	5.88
E047	30	Trade Opeartor	49756	2699	2	10	5	2.7	3.7	3.4	2.2	6.13
E048	26	Labourer	36535	4268	12	15	1	3.2	3.6	1.4	1.0	7.86
E049	52	Supervisor	60376	4268	12	15	2	2.2	1.7	3.6	2.2	6.32
E050	37	Labourer	38542	3965	8	12	3	4.5	3.9	2.5	4.2	4.25
E051	25	Labourer	36561	3001	3	10	5	3.2	2.9	3.0	2.4	4.68
E052	35	Trade Opeartor	44452	2963	2	10	4	3.5	4.1	4.1	3.2	2.62
E053	58	Trade Opeartor	56760	5236	17	20	1	3.8	4.6	4.5	3.7	7.34
E054	61	Trade Opeartor	55632	5368	18	20	2	3.2	3.7	2.4	1.0	5.00
E055	42	Labourer	40083	4369	14	12	3	3.0	3.2	1.9	4.5	3.08
E056	32	Labourer	32000	3896	5	10	4	3.7	4.0	3.1	2.0	7.15
E057	41	Trade Opeartor	54337	4268	12	15	2	4.0	3.4	2.4	4.2	7.18
E058	41	Trade Opeartor	52365	4368	13	15	2	4.5	3.3	1.6	2.8	5.06
E059	35	Labourer	49855	4120	9	12	3	4.0	3.2	3.6	3.5	3.39
E060	39	Labourer	46275	4120	9	12	3	3.2	4.5	4.7	4.5	8.42
E061	30	Labourer	47313	3896	5	10	4	2.5	3.5	3.7	2.4	7.77
E062	29	Trade Opeartor	50220	3001	3	10	5	3.0	3.1	3.6	3.3	2.58
E063	25	Manager	59122	2963	2	10	4	2.8	3.9	2.9	3.1	4.55
E064	50	Supervisor	58481	4268	12	15	1	5.0	5.0	3.3	5.0	4.50
E065	59	Trade Opeartor	49856	5101	16	20	2	2.3	3.2	2.8	1.8	4.34
E066	46	Trade Opeartor	47194	3968	6	10	4	3.8	2.4	1.4	2.8	7.20
E067	31	Labourer	39055	3758	4	10	4	2.7	3.9	1.1	1.6	8.23
E068	36	Labourer	50236	4210	10	15	3	3.0	2.7	1.9	2.4	4.05
E069	37	Supervisor	48977	2689	1	10	5	2.3	2.6	1.4	3.0	2.77
E070	29	Trade Opeartor	41785	3001	3	10	4	3.5	4.7	2.3	3.7	8.10
E071	45	Trade Opeartor	50593	4120	9	12	3	3.8	4.1	2.3	2.8	6.11
E072	64	Supervisor	63214	5368	18	20	1	4.0	4.1	3.2	4.4	3.17
E073	59	Supervisor	61268	5101	16	20	2	4.0	3.1	1.8	2.1	7.85
E074	42	Trade Opeartor	48563	3968	6	12	5	3.5	4.0	4.5	3.0	7.61
E075	53	Trade Opeartor	54433	3687	10	15	3	3.3

ee Data Company Data * All values in millions of CAD dollars ($) 2019 2020 2021 Compensation Expenses (Base & Variable Pay): 41.3 50.2 43.9 Pay-for-Performance Expenses: 6.9 11.4 10.6 Benefits Expenses: 16.8 18.4 20.1 Total Operating Expenses: 56.5 72.7 70.3 Total Revenue: 103.3 189.7 190.9 Employees 260.0 301.0 271.0 Departures/Turnover 12.0 36.0 54.0