avgWeighted
Calculates the weighted arithmetic mean.
Syntax
avgWeighted(x, weight)
Parameters
x
— Values. Integer or floating-point.weight
— Weights of the values. Integer or floating-point.
Type of x
and weight
must be the same.
Returned value
- Weighted mean.
NaN
. If all the weights are equal to 0.
Type: Float64.
Example
Query:
SELECT avgWeighted(x, w)
FROM values('x Int8, w Int8', (4, 1), (1, 0), (10, 2))
Result:
┌─avgWeighted(x, weight)─┐
│ 8 │
└────────────────────────┘
当前内容版权归 ClickHouse 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ClickHouse .