Excel Magic Trick

Download Excel Start File: people.highlin...
Download Excel Finished File: people.highlin...
Full Page With All File Links: people.highline...
See how to use the New Excel 2007 Conditional Formatting for a Vertical Histogram based on a frequency distribution.

[@excelisfun]

Dear DelegendGuy ,
There is no automatic way. Calculating the number of bins is the "art" side of statistics. It takes practice.
I have three videos that show the whole process from raw data to frequency tables to Histograms. From my Statistics class here they are (the 1st one shows how to calculate bins):
Stats 20: P1 Quantitative Freq. Dist. w Formulas
Stats 21: P2 Quantitative Freq. Dist. w Formulas
Stats 22: Histogram & Ogive Charts & % Cumulative Frequency
--excelisfun

[@excelisfun]

Dear DelegendGuy ,
EXCELlent!! I'll keep making the videos if you keep watching and rating!
--excelisfun

[@nikeforo2612]

Dear DelegendGuy,
if you mean a way to calculate the increments within frequency distribution, a number of formulas does exist; they only provide a suggested nos of increments, depending on some features of your dataset.
Take a look to my Excel Template for Robust statistics: you can find a video in my channel and you can also find the download location. If you find the Template of some interest, feel free to write me so I can include you in my mailing list in case of new improved version.