Title :
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
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;
Conference_Titel :
Robotics and Applications (ISRA), 2012 IEEE Symposium on
Conference_Location :
Kuala Lumpur
Print_ISBN :
978-1-4673-2205-8
DOI :
10.1109/ISRA.2012.6219304
