下载本文档
版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
1、本文格式为word版,下载可任意编辑excel正态分布曲线图 excel2021生成正态分布曲线图的方法 在学习工作中总会有一些用到正态分布曲线图的地方,今日,我就教大家在excel2021中制作正态分布曲线图的方法。 excel2021生成正态分布曲线图的步骤如下: 猎取正态分布概念密度。 正态分布概率密度正态分布函数"normdist'猎取。 在这里是以分组边界值为"x'来计算: mean=average(a:a)(数据算术平均) standard_dev=stdev(a:a)(数据的标准方差) cumulative=0(概率密度函数) 向下填充。 在直
2、方图中增加正态分布曲线图。 1、在直方图内右键选择数据添加 2、系列名称:选中h1单元格。 3、系列值:选中h2:h21。 4、确定、确定。 修整图形。 1、在图表区柱形较下方选中正态分布曲线数据,(正态分布密度值和频率数值相比太小了,实在看不清,多试几次,选中后如图,同时正态分布曲线那数数据处于选中状态)。 2、右键设置数据列格式系列绘制在次坐标轴; 关闭,如图。 更改系列图表类型。 1、选中正态分布柱形图右键更改系列图表类型。 2、选中"拆线图'。 3、确定。 平滑正态分布图。 选中正态分布曲线右键设置数据列格式线型勾选"平滑线'关闭。 大功告成! 本例
3、中原始数据: 51.7,50.6,57.9,56.9,56.7,56.7,55.3,56.1,53.7,54.5,56.9,51.9,52.1,55.1,54.9,54.7,55.3,55.3,54.5,54.9,54.5,55.3,54.9,54.3,53.7,53.5,53.7,53.1,54.5,53.1,53.9,53.5,53.3,53.9,53.5,53.5,52.5,53.3,53.5,53.3,53.7,53.1,54.5,53.9,56.7,54.5,54.3,55.1,54.1,54.5,53.9,53.1,53.3,55.3,55.7,56.1,54.7,53.1,53.
4、3,52.7,53.1,52.9,53.1,54.3,53.1,52.7,53.1,53.3,53.1,53.3,53.1,53.3,55.1,54.7,54.9,54.3,53.9,53.7,53.9,53.5,54.5,54.3,55.5,55.7,55.5,54.9,55.3,55.5,53.7,54.1,53.9,55.7,55.9,53.7,53.5,53.1,52.3,52.7,52.9,53.3,53.9,52.7,53.5,53.1,52.7,51.9,52.5,53.9,54.5,55.7,55.3,54.9,53.1,52.9,54.1,53.3,54.7,53.9,54.
5、3,54.1,53.7,53.3,52.7,52.9,52.5,53.9,53.5,54.1,54.1,54.7,54.9,54.9,54.1,53.3,52.9,53.7,53.9,54.3,54.1,54.5,54.7,54.9,52.1,52.9,53.5,52.7,53.1,53.1,53.5,52.9,52.9,53.1,53.3,52.7,53.5,53.9,54.9,55.1,54.3,55.1,54.3,54.3,53.9,54.5,54.5,54.3,55.3,54.5,54.9,53.5,52.1,55.3,55.7,55.7,55.5,54.5,57.7,54.7,53.
6、7,53.1,53.7,55.9,56.1,53.9,53.7,53.3,53.9,53.9,54.5,54.7,56.1,55.7,53.1,53.7,53.5,53.9,53.9,53.5,53.3,53.1,52.5,55.9,55.7,54.1,54.3,54.1,54.1,54.5,54.5,55.1,53.1,53.3,54.1,54.3,53.9,54.1,54.7,54.7,53.7,53.1,53.3,52.7,53.5,52.9,53.7,56.5,56.1,55.7,55.5,56.9,57.7,56.5,55.7,54.1,54.7,55.7,55.5,53.1,52.7,53.1,53.3,53.5,54.3,54.1,54.5,54.7,55.7,55.5,54.1,54.3,54.7,53.1,53.3,53.1,52.7,53.1,53.7,53.1,54.7,54.5,55.1,54.7,54.5,56.1,55.7,53.3,52.5,53.7,54.1,53.3,52.1,52.3,53.1,53.3,53.5,53.3,53.1,52.7,53.1,55.7,55.1,
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 观光农业项目可行性研究报告
- 无菌灌装激素安瓿瓶改造项目可行性研究报告
- 年产变压器铁芯5000吨建设项目可行性研究报告
- 核苷酸提取生产线扩建及配套工程建设项目可行性研究报告
- 江苏省宿迁市市级名校2024届中考生物押题试卷含解析
- 江苏省兴化市安丰初中2024届毕业升学考试模拟卷数学卷含解析
- 2023-2024年个体诊所聘用合同样本范本
- 2024年螺杆式压缩机项目策划方案报告
- 小学三年级数学两位数乘两位数笔算能力自测模拟题带答案
- 2024年灯带项目创业投资方案
- 报价单模板及范文(通用十二篇)
- 《政治学原理#》广东开放大学2022年10月题库
- 培智生活数学优秀教案7篇
- 《加油站“百日安全无事故”专项行动方案》1900字
- 焊接过程记录
- 2020锅炉年度自检报告
- 广州供电实训基地综合施工组织专题方案
- 跨境电商物流海外仓
- JJG 892-2022 验光仪检定规程-(高清最新版)
- 管桩截桩与填芯施工方案【范本模板】
- 社区工作者考试试题库题库(300道)
评论
0/150
提交评论