Hello,
I'm attempting to calculate a single weighted average number for international transit times, based on the number of shipments going to the international destinations.
Data Sample:
<tbody>
</tbody>
I had posed this question previously and had gotten the suggestion try excel's harmonic mean function based just on the transit days per ship numbers. The result was not favorable for my boss and was told we need to factor in shipment totals regardless.
I had attempted to do the weighted average formula, with the shipments as the 'weight' however that resulted the same as if I had just added up the total transit days and divided them by the shipment total.
Any help would be greatly appreciated, thank you all in advance for your time~!!
-Greg
I'm attempting to calculate a single weighted average number for international transit times, based on the number of shipments going to the international destinations.
Data Sample:
Transit Days Per Ship | Transit Days | Country | Shipment Total |
20.53 | 1683.47 | China | 82 |
7.42 | 452.35 | Macau | 61 |
11.97 | 454.98 | Brazil | 38 |
4.27 | 153.81 | Canada | 35 |
5.32 | 186.09 | HK | 35 |
5.80 | 191.25 | JP | 33 |
6.41 | 173 | Korea | 27 |
<tbody>
</tbody>
I had posed this question previously and had gotten the suggestion try excel's harmonic mean function based just on the transit days per ship numbers. The result was not favorable for my boss and was told we need to factor in shipment totals regardless.
I had attempted to do the weighted average formula, with the shipments as the 'weight' however that resulted the same as if I had just added up the total transit days and divided them by the shipment total.
Any help would be greatly appreciated, thank you all in advance for your time~!!
-Greg