正态分布拟合优度检验(续) 卡方分量(f-7)2/T 卡方统计量13 (SUM (D3: D5)-SUM(H3: H5))2/SUM (H3: H5) 自由度= COUNT(3122 (H6-D6)2/H6 检验水准a0.05 =(H7-D7)2/H7 P值= CHIDIST(K4K5) =(H8-D8)2/H8 临界值= CHIINV(K6K5 =(H10-D10)2/H10 SUMD11 D12)-SUM(HIl: HI2)2/SUM(HIl: H12) =SUM(3112)正态分布拟合优度检验（续） 卡方分量(f -T )2 /T =(SUM(D3:D5)-SUM(H3:H5))^2/SUM(H3:H5) 卡方统计量 =I13 自由度 =COUNT(I3:I12)-2 =(H6-D6)^2/H6 检验水准α 0.05 =(H7-D7)^2/H7 P值 =CHIDIST(K4,K5) =(H8-D8)^2/H8 临界值 =CHIINV(K6,K5) =(H9-D9)^2/H9 =(H10-D10)^2/H10 =(SUM(D11:D12)-SUM(H11:H12))^2/SUM(H11:H12) =SUM(I3:I12)