问题描述:
我有一组数据,想要知道如何用excel分析这些数据主要集中在哪个区间;(或者说画出这组数据的正态分布图)
10.90% 8.00% 6.64% 5.57% 5.54% 8.35% 10.19% 5.01% 8.58% 7.15% 6.41% 5.87%
6.54% 5.96% 8.31% 4.85% 5.66% 7.75% 9.05% 6.13% 6.83% 6.03% 6.74% 5.60%
8.11% 7.42% 8.08% 8.92% 7.80% 8.46% 8.75% 9.54% 7.58% 4.81% 4.43% 5.80%
6.42% 9.38% 10.59% 4.83% 10.38% 9.11% 8.64% 6.43% 9.97% 10.17% 4.67% 6.03%
4.91% 13.10% 5.41% 5.42% 6.18% 6.03% 7.10% 6.67% 6.59% 5.39% 6.16% 7.13%
7.34% 9.39% 5.47% 7.05% 5.90% 8.12% 7.65% 7.53% 6.84% 3.98% 3.74% 5.27%
9.95% 9.76% 5.75% 7.58% 7.05% 6.82% 7.36% 6.67% 5.91% 4.43% 10.49% 4.20%
10.90% 8.00% 6.64% 5.57% 5.54% 8.35% 10.19% 5.01% 8.58% 7.15% 6.41% 5.87%
6.54% 5.96% 8.31% 4.85% 5.66% 7.75% 9.05% 6.13% 6.83% 6.03% 6.74% 5.60%
8.11% 7.42% 8.08% 8.92% 7.80% 8.46% 8.75% 9.54% 7.58% 4.81% 4.43% 5.80%
6.42% 9.38% 10.59% 4.83% 10.38% 9.11% 8.64% 6.43% 9.97% 10.17% 4.67% 6.03%
4.91% 13.10% 5.41% 5.42% 6.18% 6.03% 7.10% 6.67% 6.59% 5.39% 6.16% 7.13%
7.34% 9.39% 5.47% 7.05% 5.90% 8.12% 7.65% 7.53% 6.84% 3.98% 3.74% 5.27%
9.95% 9.76% 5.75% 7.58% 7.05% 6.82% 7.36% 6.67% 5.91% 4.43% 10.49% 4.20%
问题解答:
我来补答展开全文阅读