68 is the example result. Read it using the units and relationship stated below.
Weighted Average uses value 1, weight 1, value 2.
Preserving the meaning of a conversion or working record
For weighted average, the relationship is Result = (([Value 1] × ([Weight 1] ÷ 100) + [Value 2] × ([Weight 2] ÷ 100)) ÷ (([Weight 1] + [Weight 2]) ÷ 100)). The amount depends on the supplied value 1, weight 1, rather than a live market price or a value imported from another record. A conversion is useful when the source value and unit remain traceable. Dates, elapsed time, percentages and ratios each have their own convention. Rounding can change a schedule or quantity when the output is copied into another system.
What the model includes
Result = (([Value 1] × ([Weight 1] ÷ 100) + [Value 2] × ([Weight 2] ÷ 100)) ÷ (([Weight 1] + [Weight 2]) ÷ 100)) Use the format shown beside the input and keep both the original and converted value. A ratio is not automatically a percentage; a calendar-day difference is not automatically a working-day count. Record the convention before comparing results. Check the result against the task being performed. An arithmetic answer does not select a business policy, a service-level agreement or a calendar rule that the page has not implemented.
Example with the supplied inputs
Value 1: 80; Weight 1: 40; Value 2: 60; Weight 2: 60. Result: 68. The values are illustrative.
Compare one changed input
Value 1 changes from 80 to 88. The result becomes 71.2. All other inputs remain fixed.
Calculation rule
Result = (([Value 1] × ([Weight 1] ÷ 100) + [Value 2] × ([Weight 2] ÷ 100)) ÷ (([Weight 1] + [Weight 2]) ÷ 100))
Inputs and output
| Input | Example value | Entry convention |
|---|---|---|
| Value 1 | 80 | Use the source quantity represented by value 1. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Weight 1 | 40 | Measure weight 1 in the displayed unit. Convert the source measurement before entry if it uses another system; a changed label does not perform a unit conversion. |
| Value 2 | 60 | Use the source quantity represented by value 2. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Weight 2 | 60 | Measure weight 2 in the displayed unit. Convert the source measurement before entry if it uses another system; a changed label does not perform a unit conversion. |
Output: 68 is the example result. Read it using the units and relationship stated below. Use the formula to distinguish a cash amount, count, percentage or ratio.
How to use the page
Collect the inputs
Gather Value 1, Weight 1, Value 2. Use one period and the units shown in the form.
Run the calculation
Enter the values and select the action. The calculation rule above explains how the inputs produce the result.
Compare a scenario
Change Value 1 on its own, keeping the other inputs fixed. Read both results before changing another assumption.
Worked example
With the example inputs listed above, the result is 68.
Change Value 1 from 80 to 88 while keeping every other value fixed. The result becomes 71.2. This comparison isolates that input; it does not forecast how other variables will respond.
Check the stated formula, units and limits before using the result in a decision.
Keep the displayed formula, input units and model scope with the result. Corrections or questions can be sent through the request section on this page.
Content updated: October 11, 2026