How does the formula in cell H6 incorporate absolute references?
The formula uses absolute references ($G$2:$G$5) for the range of weights to ensure that the references remain constant when the formula is copied to other rows.