组段下限组段上限 组中值x 实际频数ffx fx 0.75 0.8 =AVERAGE(A3: B3)I =C3*D3=D3*C3^2 0.85 =AVERAGE(A4: B4)2 =C4*D4=D4°C42 0.85 0.9 =AVERAGE(A5: B5)13 =C5*D5D5*C5^2 0.9 0.95 =AVERAGE (A6: B6)15 =C6*D6=D6C6^2 0.95 AVERAGE (A7: B7) 26 7*D AVERAGE(A8: B8)26 =C8*D8=D8*C8^2 1.05 VERAGE (A9: B9)18 =C9*D9=D9*C92 1.15 =AVERAGE(A10: B10 15 =C10*D10=D10*C102 1.15 1.2 =AVERAGE(All: B113 =Cl1Dl1=D11*C11^2 1.2 AvEraGe(A12 B121 =C12*D12=D12*C122 SUMD3: DI=SUM(E3 El=SUM(F3: F 均数=E1313 标准差=SQRT((F13-E13^2/D13)/(正态分布拟合优度检验（续） 组段下限 组段上限 组中值X 实际频数f fx fx 2 0.75 0.8 =AVERAGE(A3:B3) 1 =C3*D3 =D3*C3^2 0.8 0.85 =AVERAGE(A4:B4) 2 =C4*D4 =D4*C4^2 0.85 0.9 =AVERAGE(A5:B5) 13 =C5*D5 =D5*C5^2 0.9 0.95 =AVERAGE(A6:B6) 15 =C6*D6 =D6*C6^2 0.95 1 =AVERAGE(A7:B7) 26 =C7*D7 =D7*C7^2 1 1.05 =AVERAGE(A8:B8) 26 =C8*D8 =D8*C8^2 1.05 1.1 =AVERAGE(A9:B9) 18 =C9*D9 =D9*C9^2 1.1 1.15 =AVERAGE(A10:B10)15 =C10*D10 =D10*C10^2 1.15 1.2 =AVERAGE(A11:B11)3 =C11*D11 =D11*C11^2 1.2 =AVERAGE(A12:B12)1 =C12*D12 =D12*C12^2 合计 =SUM(D3:D12=)SUM(E3:E12=)SUM(F3:F12) 均数 =E13/D13 标准差 =SQRT((F13-E13^2/D13)/(D13-1))