当前位置:网站首页>Excel draws statistical graphs
Excel draws statistical graphs
2022-08-10 09:36:00 【Wolves_YY】
本文借鉴了数学建模清风老师的课件与思路,可以点击查看链接查看清风老师视频讲解:清风数学建模:https://www.bilibili.com/video/BV1DW411s7wi
前言
一、饼图
1.1 Regular Pie Chart
要求:untitled,Monochrome for coloring(方便打印,有区分度,Available in black and white),Label the data and zoom in appropriately,Put the legend to the right and zoom in appropriately,边框为无线条.
分析:The highest sales in the fourth quarter,Lowest in the third quarter.
1.2 类别太多
Category too much in the histogram.
1.3 too few categories
Don't draw when there are too few categories,direct text description,Unless it can be drawn as a picture of World of Warcraft or the problem of raising dragons,But the national competition doesn't like fancy pictures either..
1.4 Category is not complete
Pie chart looks like a complete set,But the data is not a complete set,There are other brands that don't show.The data above is the complete set,Can be used to draw pie charts.
1.5 Sort first then draw pie chart
Pie chart before sorting.
After sorting the pie chart,Is it more layered?.
1.6 复合饼图
See the video for details25:40.
分析:The best seller is Huawei,The second good is a apple,The other four categories account for the overall8%,The top two selling brands accounted for the total50%.
1.7 Pie Chart Summary
二、柱状图
2.1 Histogram with only one column of data
2.2 Histogram with multiple columns of data
2.3 Three types of bar chart
At this time, ordinary histograms are generally not used.,Use a Stacked Column Chart or a Percent Stacked Column Chart.
图形意义:Compare the sales volume of different brands in each quarter.
2.4 Column chart switching between rows and columns
图形意义: Compare the sales volume of various brands in different quarters.
The meaning of analysis after switching ranks is different.
2.5 柱状图总结
三、条形图(bar chart sideways)
3.1 regular bar chart
3.2 TopsisDrawing of final score bar graph
3.3 双向条形图
详见视频21:40.
3.4 Histogram visualization of regression results
For the specific visualization process, please refer to the video32:0.
3.5 Bar Chart Summary
四、直方图
4.1 频数分布直方图
See the video for changing the number of columns5:20.
4.2 The effect of group distance on the histogram
4.3 频率分布直方图
Plot frequency histogram see video12:00.
4.4 直方图总结
五、折线图(时间序列变量)
5.1 Comparison of line and column charts
5.2 Very long time series diagram(折线图)
5.3 Two-axis line chart
See the video for drawing a two-coordinate line chart15:20.
5.4 Line chart at the top of a column chart
See the video for drawing a line chart at the top of a column chart21:00.
5.5 Line chart summary
六、散点图(描述相关性)
See the video for scatterplots with logos4:30.
七、箱线图(Comparing two qualitative variables)
7.1 Comparison of histogram and boxplot
The histogram can't tell the difference,The boxplot can be a good way to show the difference between the two.
7.2 Boxplots for multiple categories
7.2 Boxplot summary
八、其他
饼图、柱状图、Line chart is sorted first and then plotted,unless it is time series data.
边栏推荐
- Mongo的简单操作-数据库用户的查询、创建与删除
- 【软考 系统架构设计师】案例分析⑥ Web应用系统架构设计
- 「技术选型」工作流引擎哪家强?首席架构帮你挑
- Chapter 3 Search and Graph Theory (3)
- [System Design] S3 Object Storage
- ARM Architecture 3: Addressing and Exception Handling of ARM Instructions
- 【数据架构】分布式数据网格作为集中式数据单体的解决方案
- 关于判断单峰数组的几种方法
- CAD to WPF: Tips on converting CAD drawing files to WPF vector code files (xaml files)
- 解决ASP.NET Core在Task中使用IServiceProvider的问题
猜你喜欢
随机推荐
乐观锁与悲观锁
不想再干会计了,蝶变向新,勇往直前,最后成功通过转行测试实现月薪翻倍~
[OAuth2] Nineteen, OpenID Connect dynamic client registration
Flink部署 完整使用 (第三章)
CAD转WPF: 关于CAD图纸文件转换为WPF矢量代码文件(xaml文件)的技巧
ARM体系结构2:处理器内核和汇编指令集
【Enterprise Architecture】Agile and Enterprise Architecture: Strategic Alliance
ARM Architecture 3: Addressing and Exception Handling of ARM Instructions
win下的开发环境变量记录
CTFSHOW七夕杯web
绘制温度曲线图;QChart,
Shell functions and arrays
DataStream API(基础篇) 完整使用 (第五章)
【微服务架构】为故障设计微服务架构
shell之函数和数组
属性动画QPropertyAnimation
【数据库架构】OLTP 和 OLAP:实际比较
CAD to WPF: Tips on converting CAD drawing files to WPF vector code files (xaml files)
navicat导入SQL文件报:[ERR] 2006 - MySQL server has gone away [ERR] -- MySQL dump 10.13 Distrib 5.7.34
ARM Architecture 2: Processor Core and Assembly Instruction Set