```xml <result> <column_name>avg_rating</column_name> <family>additive</family> <subtype>intensive_additive</subtype> <confidence>0.95</confidence> <requires_user_confirmation>false</requires_user_confirmation> <sum_meaningful>false</sum_meaningful> <signed>false</signed> <reducers> <primary_reducer>mean</primary_reducer> <valid_reducers>mean, min, max, median, distribution</valid_reducers> <excluded_reducers>sum (summing average ratings across entities is meaningless), product (not a ratio)</excluded_reducers> <average_semantics>arithmetic_mean</average_semantics> </reducers> <inner_outer_measure> <inner_measure_reducer>min</inner_measure_reducer> <outer_measure_reducer>max</outer_measure_reducer> </inner_outer_measure> <multiplicative_partner_derivable>false</multiplicative_partner_derivable> <reasoning> DIMENSION table with no sequence axis strongly priors against multiplicative. The column name "avg_rating" indicates an already-averaged intensive level (a rating score), not an extensive quantity. The center of mass (mean=2.89, median=3.06) is far from 1.0 and bounded in a typical rating scale range [0, ~4.5], consistent with an absolute level. Summing average ratings across entities is meaningless; the natural rollup is to re-average them (mean). This is a textbook intensive_additive measure. </reasoning> <table_type_conflict>false</table_type_conflict> </result> ```