请问给你一组数据后怎样用EXCEL判断这组数据是否符合正态分布?我手头没有EVIEWS和SPSS软件
听人说用P值可以算出,可是这个P值是怎么算出来的呢?用EXCEL怎么算?不胜感激
数据如下:
8,548.00
8,598.00
8,624.00
8,576.00
8,594.00
8,748.00
8,750.00
8,662.00
8,540.00
8,590.00
8,600.00
8,580.00
8,566.00
8,544.00
8,598.00
8,582.00
8,502.00
8,548.00
8,430.00
8,280.00
8,190.00
8,486.00
8,092.00
7,984.00
8,028.00
8,030.00
8,288.00
8,490.00
7,990.00
8,198.00
8,290.00
8,000.00
8,298.00
8,048.00
8,540.00
8,880.00
8,524.00
8,156.00
8,110.00
8,150.00
8,218.00
8,042.00
8,060.00
8,082.00
8,056.00
7,740.00
8,200.00
8,180.00
8,100.00
8,094.00