A company provides maintenance service for washing machines in Victoria. The collected data are presented in the Excel file

1) Assume the manager asked you to analyse the data and provide him some insights and recommendations. The report should not exceed 2 pages.

2) The managers believe the quality of the parts that are supplied from a supplier is declining over the past few months and that is causing more frequent required service. Perform a predictive analysis to investigate if there is a such relationship.

3) What other data you recommend to the manger to be added into this dataset in future for better analysis and what kind of analysis you think will be useful based on them.

Repair time (hours)	Months since last service	Date of service (in terms of days ago, for example 10 means the service has completed 10 days ago)	Type of repair	Repairperson
12.1	7.0	147	Mechanical	James
4.8	9.0	74	Electrical	James
12.9	1.0	185	Mechanical	James
11.6	6.0	95	Electrical	James
6	5.0	101	Mechanical	James
8.2	5.0	58	Electrical	James
14.7	10.0	151	Electrical	James
8.3	8.0	110	Electrical	James
11.2	4.0	189	Mechanical	James
0.5	10.0	132	Electrical	James
12.6	6.0	34	Electrical	John
9.6	10.0	110	Electrical	John
14	7.0	178	Electrical	John
7.6	6.0	189	Electrical	John
10.1	3.0	81	Electrical	John
10	6.0	51	Electrical	John
11.2	4.0	132	Mechanical	John
9.3	8.0	69	Mechanical	John
9.1	8.0	97	Mechanical	John
4.6	3.0	76	Mechanical	John
10.2	4.0	82	Mechanical	John
10.5	10.0	24	Mechanical	John
8.5	4.0	46	Mechanical	John
10.8	4.0	140	Mechanical	John
8.9	5.0	7	Mechanical	John
7.8	8.0	84	Mechanical	John
8.9	8.0	71	Mechanical	John
8.3	7.0	56	Electrical	John
7.4	1.0	39	Electrical	John
10.1	1.0	140	Electrical	John
8.4	3.0	89	Electrical	John
15.2	9.0	57	Electrical	John
13.7	10.0	81	Electrical	John
10	9.0	76	Electrical	John
4.1	4.0	109	Electrical	John
4.5	7.0	37	Electrical	John
8.5	4.0	140	Electrical	John
3.7	6.0	161	Electrical	John
11.8	10.0	136	Mechanical	John
10	7.0	156	Mechanical	John
5.2	8.0	164	Mechanical	John
6.4	2.0	64	Mechanical	John
8.5	4.0	44	Mechanical	John
7.9	2.0	142	Mechanical	John
7.4	7.0	11	Mechanical	John
11.3	8.0	117	Mechanical	John
15.1	10.0	190	Mechanical	John
9.9	9.0	33	Mechanical	John
8.2	9.0	180	Mechanical	John
4.8	6.0	86	Mechanical	John
7.1	6.0	161	Mechanical	Bob
15.7	6.0	62	Mechanical	Bob
9.6	4.0	176	Mechanical	Bob
21.9	5.0	9	Mechanical	Bob
15	7.0	15	Electrical	Bob
20.4	1.0	125	Electrical	Bob
9.1	2.0	63	Electrical	Bob
19.7	3.0	38	Electrical	Bob
21.2	4.0	17	Electrical	Bob
20.6	9.0	99	Electrical	Bob
7.3	10.0	126	Electrical	Bob
12.9	2.0	70	Electrical	Bob
15.9	8.0	155	Electrical	Bob
11.9	2.0	156	Electrical	Bob
15.2	9.0	184	Electrical	Bob
16.4	2.0	21	Electrical	Bob
4.5	2.0	147	Electrical	Bob
19.2	1.0	107	Electrical	Bob
15.9	2.0	58	Electrical	Bob
18.6	7.0	111	Electrical	Bob
7.5	9.0	185	Mechanical	Bob
14.8	6.0	169	Electrical	Bob
21.5	1.0	44	Electrical	Bob
9.2	4.0	17	Mechanical	Bob
13.4	3.0	58	Electrical	Bob
11.9	5.0	76	Electrical	Bob
18.2	6.0	37	Electrical	Bob
5.1	4.0	139	Electrical	Bob
8.3	6.0	101	Electrical	Bob
12	2.0	156	Mechanical	Bob
9.1	5.0	68	Mechanical	Bob
12.8	9.0	137	Mechanical	Bob
10.5	3.0	96	Mechanical	Bob
20.2	4.0	28	Mechanical	Bob
11.4	6.0	149	Mechanical	Bob
13.7	1.0	58	Mechanical	Bob
10	9.0	163	Mechanical	Bob
15	4.0	46	Mechanical	Bob
18.4	9.0	112	Mechanical	Bob
12.4	5.0	128	Mechanical	Bob