Zevoos
05-08-2023, 11:20 AM
taking into account the % of total population each reference represents.
Like for example I got these 3 G25 scaled references
German_East,0.0115,0.0136375,0.0162,0.015475,0.012 3875,0.0057875,0.0026875,0.00305,0.001075,-0.0027,-0.0032125,-0.0011875,-2.5e-05,0.005975,0.0009625,-0.0023625,-0.0060625,0.0009375,0.004225,-6e-04,5e-04,-9e-04,0.0014375,0.0013375,-0.0002625
German_Erlangen,0.0112955,0.0135134,0.0148925,0.01 17881,0.0125403,0.0054134,0.001797,0.0023582,0.002 0045,-6.12e-05,-0.0019209,0.0008075,-0.002491,0.0013746,0.0032642,0.0013701,-0.0014045,0.0014209,0.0024746,0.0004776,-0.0002522,0.0011,0.0014851,0.0055627,1.5e-06
German_Hamburg,0.0112706,0.0131941,0.0168294,0.015 0235,0.0130176,0.0073059,0.0032176,0.0039471,0.001 4471,-0.0019529,-0.0023882,5.88e-05,-0.0016882,0.0005471,0.0069529,0.0024647,-0.0034941,0.0020176,0.0031765,0.0005471,0.0013941, 0.0012588,0.0022059,0.0061,-0.0008647
and I want to make an average for Germany where German_East weights 20%, German_Erlangen 45% and German_Hamburg 35%. I totally made up these numbers but you get the point.
Like for example I got these 3 G25 scaled references
German_East,0.0115,0.0136375,0.0162,0.015475,0.012 3875,0.0057875,0.0026875,0.00305,0.001075,-0.0027,-0.0032125,-0.0011875,-2.5e-05,0.005975,0.0009625,-0.0023625,-0.0060625,0.0009375,0.004225,-6e-04,5e-04,-9e-04,0.0014375,0.0013375,-0.0002625
German_Erlangen,0.0112955,0.0135134,0.0148925,0.01 17881,0.0125403,0.0054134,0.001797,0.0023582,0.002 0045,-6.12e-05,-0.0019209,0.0008075,-0.002491,0.0013746,0.0032642,0.0013701,-0.0014045,0.0014209,0.0024746,0.0004776,-0.0002522,0.0011,0.0014851,0.0055627,1.5e-06
German_Hamburg,0.0112706,0.0131941,0.0168294,0.015 0235,0.0130176,0.0073059,0.0032176,0.0039471,0.001 4471,-0.0019529,-0.0023882,5.88e-05,-0.0016882,0.0005471,0.0069529,0.0024647,-0.0034941,0.0020176,0.0031765,0.0005471,0.0013941, 0.0012588,0.0022059,0.0061,-0.0008647
and I want to make an average for Germany where German_East weights 20%, German_Erlangen 45% and German_Hamburg 35%. I totally made up these numbers but you get the point.