χ2检验(卡方检验)一组数据是否符合正态分布-Excel计算模板

χ2检验(卡方检验)一组数据是否符合正态分布,,,,,,,,,

卡方检验就是统计样本的实际观测值与理论推断值之间的偏离程度，实际观测值与理论推断值之间的偏离程度就决定卡方值的大小，如果卡方值越大，二者偏差程度越大；反之，二者偏差越小；若两个值完全相等时，卡方值就为0，表明与理论值完全符合。,,,,,,,,,

序号,数据,相关参数,,,,,,,

1,-1.482,数据个数：,200,,,,,,

2,0.324,组数：,20,,,,,,

3,-2.239,步长值,0.266,,,,,,

4,-0.974,min=,-2.981,,,,,,

5,-0.577,max=,2.336,,,,,,

6,0.987,mean=,-0.047,,,,,,

7,-1.020,mean应尽量小，前2位小数为0（经验）,,,,,,,

8,-0.514,,,,,,,,

9,0.843,"每一组理论频数应>5,否则，相邻组合并，导致组别发生变化，自由度也发生变化，编码变量Vi也发生变化",,,,,,,

10,-0.134,,,,,,,,

11,1.222,,,,,,,,

12,-2.212,,,,,,,,

13,1.241,,,,,,,,

14,-1.282,红色区域录入数据即可,,,,,,,

15,0.247,,,,,,,,

16,-2.771,,,,,,,,

17,0.018,正态分布的χ2检验,,,,,,,

18,0.344,组距,观测数Oi,编码变量Vi,组界v,u=（v-`v）/sv,标准正态分布累积分布,理论频数Ti,对χ2的贡献

19,-2.008,-2.981,/,/,/,/,/,/,/

20,0.745,-2.518,5,0,/,/,/,1.71,6.3647

21,-0.575,-2.252,0,1,0.5,-2.386,0.0085,1.63,1.6289

22,0.096,-1.987,5,2,1.5,-2.128,0.0167,2.81,1.7072

23,-0.157,-1.721,3,3,2.5,-1.870,0.0307,4.54,0.5207

24,-0.431,-1.455,6,4,3.5,-1.613,0.0534,6.86,0.1074

25,-0.983,-1.189,7,5,4.5,-1.355,0.0877,9.70,0.7539

26,0.056,-0.923,12,6,5.5,-1.097,0.1362,12.86,0.0570

27,-0.464,-0.657,13,7,6.5,-0.840,0.2005,15.94,0.5429

28,-0.397,-0.391,19,8,7.5,-0.582,0.2802,18.51,0.0132

29,-0.127,-0.126,18,9,8.5,-0.325,0.3727,20.11,0.2216

30,0.374,0.140,32,10,9.5,-0.067,0.4733,20.46,6.5099

31,0.063,0.406,15,11,10.5,0.191,0.5756,19.48,1.0320

32,1.432,0.672,14,12,11.5,0.448,0.6730,17.37,0.6539

33,0.249,0.938,16,13,12.5,0.706,0.7599,14.50,0.1559

34,0.643,1.204,9,14,13.5,0.963,0.8323,11.33,0.4776

35,1.350,1.470,16,15,14.5,1.221,0.8890,8.28,7.1893

36,0.577,1.735,0,16,15.5,1.479,0.9304,5.67,5.6710

37,1.780,2.336,10,17,16.5,1.736,0.9587,8.25,0.3711

38,1.299,2.336,0,0,0,0.000,0.0000,0.00,0.0000

39,1.275,2.336,0,0,0,0.000,0.0000,0.00,0.0000

40,0.062,样本数=,200,和=,1952,平方和=,22050,,

41,0.024,sv=,3.882,`v=,9.76,df=,13,χ2=,33.978

42,-0.995,"χ2(0.05,13)=",,22.362,χ2＞临界值，则数据不符合正态分布,,,,

43,1.867,,,,,,,,

44,1.393,可在此区域增加或删除行，以调整数据量,,,,,,,

45,0.462,,,,,,,,

46,-0.783,,,,,,,,

47,0.663,,,,,,,,

48,0.909,,,,,,,,

49,-0.032,,,,,,,,

50,1.105,,,,,,,,

51,-1.476,,,,,,,,

52,1.101,,,,,,,,

53,-0.994,,,,,,,,

54,-0.295,,,,,,,,

55,1.130,,,,,,,,

56,1.935,,,,,,,,

57,0.099,,,,,,,,

58,0.322,,,,,,,,

59,-0.546,,,,,,,,

60,0.488,,,,,,,,

61,-0.547,,,,,,,,

62,0.288,,,,,,,,

63,1.795,,,,,,,,

64,-0.222,,,,,,,,

65,-0.760,,,,,,,,

66,0.164,,,,,,,,

67,1.146,,,,,,,,

68,-1.088,,,,,,,,

69,-1.534,,,,,,,,

70,-0.535,,,,,,,,

71,-0.860,,,,,,,,

72,-2.518,,,,,,,,

73,-0.413,,,,,,,,

74,0.052,,,,,,,,

75,-0.366,,,,,,,,

76,-0.075,,,,,,,,

77,-0.030,,,,,,,,

78,1.814,,,,,,,,

79,0.024,,,,,,,,

80,-0.245,,,,,,,,

81,-0.204,,,,,,,,

82,0.810,,,,,,,,

83,0.859,,,,,,,,

84,-1.378,,,,,,,,

85,1.268,,,,,,,,

86,-0.091,,,,,,,,

87,-0.036,,,,,,,,

88,0.914,,,,,,,,

89,-0.444,,,,,,,,

90,-0.207,,,,,,,,

91,-0.255,,,,,,,,

92,0.462,,,,,,,,

93,0.663,,,,,,,,

94,-0.067,,,,,,,,

95,-0.591,,,,,,,,

96,0.007,,,,,,,,

97,-0.312,,,,,,,,

98,1.180,,,,,,,,

99,0.344,,,,,,,,

100,-0.005,,,,,,,,

101,-1.612,,,,,,,,

102,-0.646,,,,,,,,

103,-0.294,,,,,,,,

104,0.048,,,,,,,,

105,1.305,,,,,,,,

106,-1.206,,,,,,,,

107,1.951,,,,,,,,

108,-1.510,,,,,,,,

109,0.738,,,,,,,,

110,-2.589,,,,,,,,

111,0.135,,,,,,,,

112,-0.838,,,,,,,,

113,1.123,,,,,,,,

114,0.706,,,,,,,,

115,0.125,,,,,,,,

116,-0.035,,,,,,,,

117,0.470,,,,,,,,

118,-0.687,,,,,,,,

119,-0.608,,,,,,,,

120,-0.280,,,,,,,,

121,1.781,,,,,,,,

122,0.100,,,,,,,,

123,-0.699,,,,,,,,

124,-0.834,,,,,,,,

125,0.458,,,,,,,,

126,-2.007,,,,,,,,

127,-2.215,,,,,,,,

128,-0.024,,,,,,,,

129,-0.040,,,,,,,,

130,-0.962,,,,,,,,

131,-1.258,,,,,,,,

132,-0.600,,,,,,,,

133,-1.905,,,,,,,,

134,-0.929,,,,,,,,

135,-0.179,,,,,,,,

136,-2.981,,,,,,,,

137,0.816,,,,,,,,

138,0.747,,,,,,,,

139,-0.324,,,,,,,,

140,-1.884,,,,,,,,

141,0.405,,,,,,,,

142,0.121,,,,,,,,

143,0.265,,,,,,,,

144,1.320,,,,,,,,

145,0.243,,,,,,,,

146,0.872,,,,,,,,

147,-0.904,,,,,,,,

148,0.506,,,,,,,,

149,1.802,,,,,,,,

150,-1.220,,,,,,,,

151,0.302,,,,,,,,

152,1.093,,,,,,,,

153,-0.489,,,,,,,,

154,1.398,,,,,,,,

155,0.006,,,,,,,,

156,-1.175,,,,,,,,

157,-0.427,,,,,,,,

158,0.947,,,,,,,,

159,-1.170,,,,,,,,

160,0.894,,,,,,,,

161,1.281,,,,,,,,

162,0.502,,,,,,,,

163,0.105,,,,,,,,

164,0.059,,,,,,,,

165,-0.659,,,,,,,,

166,-0.746,,,,,,,,

167,0.708,,,,,,,,

168,1.282,,,,,,,,

169,-0.854,,,,,,,,

170,-0.115,,,,,,,,

171,-0.139,,,,,,,,

172,-2.911,,,,,,,,

173,0.112,,,,,,,,

174,-0.535,,,,,,,,

175,1.232,,,,,,,,

176,2.336,,,,,,,,

177,-1.936,,,,,,,,

178,-0.929,,,,,,,,

179,-0.801,,,,,,,,

180,0.015,,,,,,,,

181,-0.681,,,,,,,,

182,-1.039,,,,,,,,

183,0.752,,,,,,,,

184,1.305,,,,,,,,

185,-0.630,,,,,,,,

186,-0.011,,,,,,,,

187,0.333,,,,,,,,