环境空气质量评价中利用Excel进行百分位数的计算及百分位数矩形图的绘制

The Calculation of Percentile and the Drawing of Percentile Rectangle Chart in Environmental Air Quality Assessment by Using Excel

通过百分位数矩形图的绘制,可以直观了解某项指标在某一时间段中的污染物分布特征,并可以对污染变化趋势进行比较、分析。本文介绍了如何在Excel中制作百分位数矩形图模板,只需输入原始数据即可自动生成百分位数矩形图,实现数据与图表的自动链接,确保图形的准确。制成的模板可以反复使用,并且可以根据不同的情况灵活变换,可以提高工作效率,具有实用价值。

By drawing the percentile rectangle,we can intuitively understand a pollution distribution feature of a certain indicator in a specific time period,and we can compare and analyze the changing trends of pollution status.This paper introduces how to make the creation of percentile rectangular templates in Excel,just need to enter the original data to automatically generate a percentile histogram,realize the automatic link between data and charts,and ensure the accuracy of the graph.The made template can be used repeatedly,and can be flexibly transformed according to different situations,which can improve work efficiency and have practical value.