我有一组数据,想要知道如何用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.7
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/28 07:36:13
![我有一组数据,想要知道如何用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.7](/uploads/image/z/3502737-9-7.jpg?t=%E6%88%91%E6%9C%89%E4%B8%80%E7%BB%84%E6%95%B0%E6%8D%AE%2C%E6%83%B3%E8%A6%81%E7%9F%A5%E9%81%93%E5%A6%82%E4%BD%95%E7%94%A8excel%E5%88%86%E6%9E%90%E8%BF%99%E4%BA%9B%E6%95%B0%E6%8D%AE%E4%B8%BB%E8%A6%81%E9%9B%86%E4%B8%AD%E5%9C%A8%E5%93%AA%E4%B8%AA%E5%8C%BA%E9%97%B4%EF%BC%9B%EF%BC%88%E6%88%96%E8%80%85%E8%AF%B4%E7%94%BB%E5%87%BA%E8%BF%99%E7%BB%84%E6%95%B0%E6%8D%AE%E7%9A%84%E6%AD%A3%E6%80%81%E5%88%86%E5%B8%83%E5%9B%BE%EF%BC%8910.90%25+8.00%25+6.64%25+5.57%25+5.54%25+8.35%25+10.19%25+5.01%25+8.58%25+7.15%25+6.41%25+5.87%256.54%25+5.96%25+8.31%25+4.85%25+5.66%25+7.7)
我有一组数据,想要知道如何用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.7
我有一组数据,想要知道如何用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%
我有一组数据,想要知道如何用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.7
可以利用数据处理工具中的直方图直接做,只是自己要将接收区间选择好,首先先将数据排序,然后选择区间点(等距),比如最小值为6.5,最大值为10.9,可设接收点为6.4,6.8,7.2,.直到大与10.9的一个数,以该数组为接收数组,使用直方图工具即可得出频率表(即落在每个区间的数据个数),根据此表可以画出分布图,也可利用此表,将其转换为正态分布(利用正态分布函数),具体函数及参数用法可在EXCEI帮助文件中查询