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

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.