背靠背茎叶图的快速绘制及动态展示

详细信息    查看全文 | 推荐本文 |

英文篇名：The Fast Drawing of Back-to-Back Stem-and-Leaf Display and Dynamic Display 作者：孙鹿 ; 郭民之 ; 汤泽梅 英文作者：SUN Lu;GUO Min-zhi;TANG Ze-mei;School of Mathematics, Yunnan Normal University; 关键词：单边及双边茎叶图 ; 快速绘制 ; Excel函数组合应用 ; 动态展示 英文关键词：Unilateral and bilaterally stem-and-leaf display;;Fast drawing;;Combination application of excel function;;Dynamic display 中文刊名：JYXD 英文刊名：Education Modernization 机构：云南师范大学数学学院; 出版日期：2018-07-02 出版单位：教育现代化 年：2018 期：v.5 语种：中文; 页：JYXD201827067 页数：4 CN：27 ISSN：11-9354/G4 分类号：206-209

摘要

利用茎叶图对数据进行统计分析,不仅能展现数据的整体分布情况,还可直观的反映所有数据的个体信息。本文简要的介绍了茎叶图的作用与特点,然后着重说明如何应用Excel函数及函数组合来绘制单边茎叶图及双边茎叶图(也称背靠背茎叶图),并进行动态展示,最后利用学生成绩数据进行实际作图演示。要特别说明的是,目前的诸多统计软件都不能绘制双边茎叶图,而本文的研究结果解决了这个问题。
        The statistical analysis of data using stem-and-leaf display can not only show the overall distribution of data, but also directly reflect the individual information of all data. This paper briefly introduces the functions and characteristics of stemand-leaf chart, and then focus on how to use Excel function and combination application of function to draw unilateral stemand-leaf display and bilaterally stem-and-leaf display(also known as back-to-back stem-and-leaf display), and dynamic display, finally using the student achievement data for actual construction demonstration. It is important to note that no current statistical software can draw bilaterally, and the results of this paper have solved this problem.

引文

[1]技术论坛网址:http://club.excelhome.net/thread-998921-2-1.html.
    [2]郭民之等.概率统计实验[M].北京大学出版社,2012.
    [3]王巧伶等.Excel2010函数应用速查手册[M].机械工业出版社,2013.
    [4]Jacky Davis.Excel函数×函数组合应用范例[M].科学出版社,2013.
    [5]宋鸿,陈晓玲.基于茎叶图的数据分析与制图方法[J].统计教育,2008,2:16-17.