正态分布概率Px 理论频数T -NORMDIST(B3, $B$15, $E$15, 1) =G3*$DS13 -NORMDIST(B4, $B$15, $E$15, 1)-NORMDIST(B3, $B$15, $E=G4*SDS13 -NORMDIST(B5, $B$15, $E$15, 1)-NORMDIST(B4, $B$15, SE=G5*SD$13 -NORMDIST(B6, $B$15, $E$15, 1)-NORMDIST(B5, $B$15, E=G6*SD$13 -NORMDIST(B7, SB15, $E$15, 1)-NORMDIST(B6, $B$15, SE=G7*$$13 -NORMDIST(B8, $B$15 SE$15, 1 )-NORMDIST(B7, $B$15, SE=G8*SDS13 -NORMDIST(B9, SB$15, SE$15, 1)-NORMDIST(B8, B$15,SE =G9*SD$13 -NORMDIST(B10, $$15, SES15, 1)-NORMDIST(B9 $BS15 $=G10*SD$13 -NORMDIST(B11 SB$15, $ES15, 1)-NORMDIST(B10, $B$15.=G1l*SD$13 1-NORMDIST(B11, SB$15SES15, 1) =G12*$D$13 =SUM(G3: G12) =SUM(H3: H12) D13-1)正态分布拟合优度检验（续） 正态分布概率PX 理论频数T =NORMDIST(B3,$B$15,$E$15,1) =G3*$D$13 =NORMDIST(B4,$B$15,$E$15,1)-NORMDIST(B3,$B$15,$E=$1G54,*1)$D$13 =NORMDIST(B5,$B$15,$E$15,1)-NORMDIST(B4,$B$15,$E=$1G55,*1)$D$13 =NORMDIST(B6,$B$15,$E$15,1)-NORMDIST(B5,$B$15,$E=$1G56,*1)$D$13 =NORMDIST(B7,$B$15,$E$15,1)-NORMDIST(B6,$B$15,$E=$1G57,*1)$D$13 =NORMDIST(B8,$B$15,$E$15,1)-NORMDIST(B7,$B$15,$E=$1G58,*1)$D$13 =NORMDIST(B9,$B$15,$E$15,1)-NORMDIST(B8,$B$15,$E=$1G59,*1)$D$13 =NORMDIST(B10,$B$15,$E$15,1)-NORMDIST(B9,$B$15,$E=$G1150,1*)$D$13 =NORMDIST(B11,$B$15,$E$15,1)-NORMDIST(B10,$B$15,$=EG$1115*,1$)D$13 =1-NORMDIST(B11,$B$15,$E$15,1) =G12*$D$13 =SUM(G3:G12) =SUM(H3:H12) =SQRT((F13-E13^2/D13)/(D13-1))