Download Files:
people.highline.edu/mgirvin/Y...
See how to to create an array formula for a Stem and Leaf Chart for decimal numbers. See the functions: IF, COLUMNS, SUMPRODUCT, INDEX, INT, RIGHT, SMALL, ROW, TEXT. Also see: Excel Statistics 28: Stem & Leaf Chart w REPT & COUNTIF functions & Excel Magic Trick 376: Stem & Leaf Chart for Big Numbers
2 май 2010