Excel如何做加权平均数公式需要在最后一行得出每个平均数,如图所示,全水需要得出 (16.5*6+15.98*2+16.74*1+16.54*15)/6+2+1+15,后面几项以此类推,请教该怎么列公式呢
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/29 09:05:03
![Excel如何做加权平均数公式需要在最后一行得出每个平均数,如图所示,全水需要得出 (16.5*6+15.98*2+16.74*1+16.54*15)/6+2+1+15,后面几项以此类推,请教该怎么列公式呢](/uploads/image/z/1977639-15-9.jpg?t=Excel%E5%A6%82%E4%BD%95%E5%81%9A%E5%8A%A0%E6%9D%83%E5%B9%B3%E5%9D%87%E6%95%B0%E5%85%AC%E5%BC%8F%E9%9C%80%E8%A6%81%E5%9C%A8%E6%9C%80%E5%90%8E%E4%B8%80%E8%A1%8C%E5%BE%97%E5%87%BA%E6%AF%8F%E4%B8%AA%E5%B9%B3%E5%9D%87%E6%95%B0%2C%E5%A6%82%E5%9B%BE%E6%89%80%E7%A4%BA%2C%E5%85%A8%E6%B0%B4%E9%9C%80%E8%A6%81%E5%BE%97%E5%87%BA+%EF%BC%8816.5%2A6%2B15.98%2A2%2B16.74%2A1%2B16.54%2A15%EF%BC%89%2F6%2B2%2B1%2B15%2C%E5%90%8E%E9%9D%A2%E5%87%A0%E9%A1%B9%E4%BB%A5%E6%AD%A4%E7%B1%BB%E6%8E%A8%2C%E8%AF%B7%E6%95%99%E8%AF%A5%E6%80%8E%E4%B9%88%E5%88%97%E5%85%AC%E5%BC%8F%E5%91%A2)
xݒQOAǿJ@"voviI9RthH[5>4Dm @))T>>\*,4f2hsoϾ(^+19Ö/bڛі i2{+.vDL{?zM5.d'<8H^3WӶAt#y뮓CyVθXY|5 WqԴp_v{P~=v.#m6!fCtI[w~Ef\3lq)