Weighted Average Calculator
Weighted Average is evaluated from Value 1, Weight 1 and Value 2. The calculation reports Weighted Average, Total Weight and Simple Average.
Results
About the Weighted Average Calculator
The calculator uses a multi formula configuration. Each reported value is read as a direct evaluation of the stored rules with the declared field formats and units.
Formula basis:
Weighted Average = (v1 x w1 + v2 x w2 +... + vn x wn) / (w1 + w2 +... + wn)
Interpret the outputs in the order shown by the result fields. Optional inputs affect only the outputs that depend on those variables.
Formula & How It Works
The calculation applies the following relations exactly as recorded in the metadata: Weighted Average = (v1 x w1 + v2 x w2 +... + vn x wn) / (w1 + w2 +... + wn) Each output field is produced by substituting the supplied inputs into the relevant relation and then applying the declared rounding or text format.
Worked Examples
Example 1: College GPA — Semester Grades
Inputs
With Value 1 = 3.7, Weight 1 = 4, Value 2 = 3.3 and Weight 2 = 3 as the stated inputs, the result is Weighted Average = 3.5083, Total Weight = 12 and Simple Average = 3.425. Each value corresponds to the declared output fields.
Example 2: Investment Portfolio Return
Inputs
With Value 1 = 12.5, Weight 1 = 50,000, Value 2 = 7.2 and Weight 2 = 30,000 as the stated inputs, the result is Weighted Average = 7.79, Total Weight = 100,000 and Simple Average = 5.5333. Each value corresponds to the declared output fields.
Example 3: Weighted Exam Score
Inputs
With Value 1 = 88, Weight 1 = 20, Value 2 = 75 and Weight 2 = 20 as the stated inputs, the result is Weighted Average = 83.6, Total Weight = 100 and Simple Average = 84. Each value corresponds to the declared output fields.
Example 4: Weighted Average Cost of Inventory
Inputs
With Value 1 = 10.5, Weight 1 = 200, Value 2 = 11.25 and Weight 2 = 300 as the stated inputs, the result is Weighted Average = 10.9154, Total Weight = 650 and Simple Average = 10.85. Each value corresponds to the declared output fields.
Common Use Cases
- Calculate GPA from course grades and credit hours
- Compute weighted average cost of inventory
- Find weighted average interest rate on multiple loans
- Determine average test score with different point values