The attached data table in CSV format contains estimates of the variable x given by different agents  of future value. The agents are coded with an id number and the agents are further divided into four categories 1-4 based on the significance of the assessments given by the agents. What is the weighted average of the evaluations given by the agents, when the ratios of weight coefficients 1:5:7:6 are used for agents from categories 1-4, where the agent from category 2 gets a weight of 5, while an expert from category 4 gets a weight of 6? (Correct response tolerance 0.002)

ID	Kategoria	Arvio muuttujalle x
Id 01	1	9,017271093
Id 02	4	7,865049666
Id 03	4	14,29626822
Id 04	1	6,741998109
Id 05	3	7,077758539
Id 06	2	13,40782342
Id 07	3	12,31890557
Id 08	1	12,3657589
Id 09	3	5,191756735
Id 10	2	5,642470771
Id 11	1	10,99864691
Id 12	4	6,19287374
Id 13	2	5,75225134
Id 14	4	11,94349284
Id 15	1	6,185604531
Id 16	4	11,60144938
Id 17	2	8,979721832
Id 18	2	11,02907846
Id 19	1	8,248481158
Id 20	1	6,918399259
Id 21	3	10,46639443
Id 22	2	7,175057974
Id 23	2	9,341633026
Id 24	1	8,180137529
Id 25	3	6,275580147