Hi all,
I was looking for help on what seemed to be a relatively easy issue at first, however I just want to see if there are any other options available.
So, I'm currently need to come up with a weight average number for a set of shipment transit data, by country received.
Here is the data:
Destination Shipments Total Transit Days Days per shipment to Destination A/P
BRAZIL 171 2,636.14 5.86
CANADA 387 1,873.94 2.49
CHILE 24 159.85 6.13
GUAM 53 222.23 3.02
MEXICO 73 738.13 7.01
AUSTRALIA 278 1,966.42 3.80
CHINA 879 16,325.63 4.57
HONG KONG 277 1,642.65 3.33
JAPAN 260 1,563.31 3.25
KOREA 162 1,092.34 3.91
MACAU 182 1,232.85 3.40
MALAYSIA 69 456.71 3.32
SINGAPORE 116 651.95 3.34
TAIWAN, R.O.C. 123 688.81 3.74
THAILAND 34 560.55 2.62
AUSTRIA 23 102.10 3.61
BELGIUM 20 130.45 1.70
CZECH REPUBLIC 60 399.86 2.10
FRANCE 121 1,345.26 2.24
GERMANY 126 897.85 2.34
IRELAND 44 354.99 2.09
ITALY 97 512.31 3.76
NETHERLANDS 50 157.42 2.04
RUSSIAN FEDERATION 13 91.61 3.38
SPAIN 45 134.00 2.20
SWITZERLAND 57 268.55 3.51
UNITED ARAB EMIRATES 90 598.94 2.34
UNITED KINGDOM 105 884.88 2.26
I initially used a SUMPRODUCT formula, with the main array being days per shipment, and the 'weight' being the shipment totals themselves.
Unfortunately however, the result I'm getting is the exact same as a regular average (the sum of the transit days divided by the shipment total).
Any suggestions would be greatly appreciated, thank you all in advance.
Greg
I was looking for help on what seemed to be a relatively easy issue at first, however I just want to see if there are any other options available.
So, I'm currently need to come up with a weight average number for a set of shipment transit data, by country received.
Here is the data:
Destination Shipments Total Transit Days Days per shipment to Destination A/P
BRAZIL 171 2,636.14 5.86
CANADA 387 1,873.94 2.49
CHILE 24 159.85 6.13
GUAM 53 222.23 3.02
MEXICO 73 738.13 7.01
AUSTRALIA 278 1,966.42 3.80
CHINA 879 16,325.63 4.57
HONG KONG 277 1,642.65 3.33
JAPAN 260 1,563.31 3.25
KOREA 162 1,092.34 3.91
MACAU 182 1,232.85 3.40
MALAYSIA 69 456.71 3.32
SINGAPORE 116 651.95 3.34
TAIWAN, R.O.C. 123 688.81 3.74
THAILAND 34 560.55 2.62
AUSTRIA 23 102.10 3.61
BELGIUM 20 130.45 1.70
CZECH REPUBLIC 60 399.86 2.10
FRANCE 121 1,345.26 2.24
GERMANY 126 897.85 2.34
IRELAND 44 354.99 2.09
ITALY 97 512.31 3.76
NETHERLANDS 50 157.42 2.04
RUSSIAN FEDERATION 13 91.61 3.38
SPAIN 45 134.00 2.20
SWITZERLAND 57 268.55 3.51
UNITED ARAB EMIRATES 90 598.94 2.34
UNITED KINGDOM 105 884.88 2.26
I initially used a SUMPRODUCT formula, with the main array being days per shipment, and the 'weight' being the shipment totals themselves.
Unfortunately however, the result I'm getting is the exact same as a regular average (the sum of the transit days divided by the shipment total).
Any suggestions would be greatly appreciated, thank you all in advance.
Greg