当前位置:网站首页>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.
边栏推荐
- Controller层代码这么写,简洁又优雅!
- 13 【script setup 总结】
- 设计分享|基于单片机的从左到右流水灯
- J9 digital science: Web 3.0 is about data ownership or decentralized?
- 数据库注入提权总结(一)
- 【微服务架构】为故障设计微服务架构
- 【Software Exam System Architect】System Reliability Analysis and Design ① System Reliability Analysis
- 多线程知识点总结之温故而知新
- 傅立叶级数与傅里叶变换
- 【数据架构】分布式数据网格作为集中式数据单体的解决方案
猜你喜欢
【微服务架构】为故障设计微服务架构
腾讯发布四足机器人 Max 二代版本,梅花桩上完成跳跃、空翻
傅立叶级数与傅里叶变换
How to break the DeepFake face-changing scam?turn him over
DeepFake换脸诈骗怎么破?让他侧个身
PTA Exercise 2.2 Rotate an Array Left
FPGA时钟篇(一) 7系列的时钟结构
iwemeta metaverse: Ali's first COO: how to build a sales force
MUDA:对齐特定域的分布和分类器以实现来自多源域的跨域分类
Defending risks with technology and escorting cloud native | Tongchuang Yongyi X Boyun held a joint product launch conference
随机推荐
并发的基本概念,操作,容器
DeepFake换脸诈骗怎么破?让他侧个身
多线程知识点总结之温故而知新
PostgreSQL 2022 发展现状:13 个非 psql 工具
2 模块一:科研思维培养
【 WeChat applet 】 read page navigation
属性动画QPropertyAnimation
The first offline workshop in 2022!Data application experience day for application developers is coming | TiDB Workshop Day
Chapter 3 Search and Graph Theory (3)
DataStream API(基础篇) 完整使用 (第五章)
CAD to WPF: Tips on converting CAD drawing files to WPF vector code files (xaml files)
npm i安装报错
【数据库架构】OLTP 和 OLAP:实际比较
How to use [jmeter regular expression extractor] to solve the problem of returning the value as a parameter
[Metaverse Omi Says] Listen to how Rabbit Fan Rabbit creates a new era of trendy play from virtual to reality
Static关键字及应用,继承的概念
【API架构】使用 JSON API 的好处
关于编程本质那些事
将博客搬至CSDN
刷题工具h