The application of making Back-to-Back Stem and Leaf Graph using Excel in statistic

Author

Hongbing, Zhu ; Yu, Wei ; Lijuan, He

Author_Institution

Comput. Teaching Sect., Capital Inst. of Phys. Educ., Beijing, China

fYear

2012

fDate

3-5 June 2012

Firstpage

769

Lastpage

772

Abstract

Stem and Leaf Graph is a new kind of graphic method which is quite popular in showing the distribution of the data using data itself in statistic nowadays. Although there is Stem and Leaf Graph in SPSS that can handle single samples, Back-to-Back Stem and Leaf Graph remains a blank, as well as in Excel. This paper provides a thought of generating Back-to-Back Stem and Leaf Graph automatically with the existing functions in Excel, which has used in shooting statistical analysis and proof the correctness in any condition of rational. It can not only provide a new choice for users of Stem and Leaf Graph, but also fill in the blank for Sports Statistics using Excel as a calculation tool.

Keywords

graph theory; spreadsheet programs; statistical analysis; Excel calculation tool; back-to-back stem; graphic method; leaf graph; sports statistics; statistical analysis; stem graph; Computers; Education; Games; Graphics; Helium; Robots; Standards; Back-to-Back Stem and Leaf Graph; Excel; data; function; graphic method;

fLanguage

English

Publisher

ieee

Conference_Titel

Robotics and Applications (ISRA), 2012 IEEE Symposium on

Conference_Location

Kuala Lumpur

Print_ISBN

978-1-4673-2205-8

Type

conf

DOI

10.1109/ISRA.2012.6219304

Filename

6219304