Choosing Class Intervals (Excel Bins)

Some students are confused on how to sort data into class intervals or "bins" in Excel. This video explains a method to easily choose bins.
(Recorded with screencast-o-matic.com)

[@RitaGarciaPeran]

I finally found a good explanation of what I have been trying to do for the last 2 hours. THANK YOU,

[@stagefatality]

This has been so, so, so helpful for me. Thank you very much.

[@danielz9054]

Very helpful, have an IED test tomorrow and this came In handy to study for

[@nicolenigh]

Thank you so much for this. It was so helpful for my stats homework!

[@zee-xf9gb]

Thanks! Really great video! I have been trying to figure this out for hours and your video helped!

[@timur4486]

it works, but may I mention that I can't see the tabs you are using. but following the names of the tabs you mentioned I managed to get the same result. thank you

[@daytonaphillips8559]

This video just saved my life! I was crying over my stats homework and this helped so much lol

[@DrBTStm]

Thank you very much, Prof. Scott. Very helpful for measuring bubble size in research

[@elizabethrodriguez672]

Thank you so much. You clearly explained step by step the process.

[@mamatrouble8048]

Thanks so much. I like how you break things up.

[@jasperhe1996]

Hi, do you know how to specify the bin as a range, e.g. 0.74 - 0.743, 0.743- 0.746, etc., instead of a number? Thank you

[@rachelebarronholmes9994]

thank you for posting this!

[@asianhkcn]

Thanks so much!! :) This actually helped.

[@AlvinRyellPrada]

This definitely helped me in my home work Thanks :)

[@environmentandgeoinformati5503]

Thanks! It helps me a lot

[@nirmein]

Brilliant 👏 Thank you so much 😊

[@MISHUCHOPRA]

thankyou for this video learned well

[@katherynrobles2125]

Thank you so much. It is really helpful. :)

[@cindyc6703]

Thank you for your explanation. Now I understand. Cool.😃😃😃😃

[@cyberguide_in]

You can add f4 to add dollar sign all at once.

[@strafedon9167]

very helpful! thanks!

[@MrKingoverall]

I LOVE YOU MAN !!

[@Orsino14]

This is good, man

[@timmydotlife]

Very good, thank you.

[@rothergaudiel2549]

Thank you for this video :)

[@tanmoydebnath7992]

Hi Scott, I have a dataset with 16000+ entries. Can I use more than a hundred bins contrary to your suggestion in the video?

[@ScottDellinger]

Yes. I originally made this video for one of the classes I teach, so the advice was tailored specifically for them (14-15 years old). I didn't want them to get lost in the Freedman-Diaconis rule, and figured their statistics teacher in 4 years would cover. If I had known this would become my most popular video watched by adult learners, I would have done things a little differently.

[@estebanlopez1701]

thanks man, I wish a had a million dollars to send you

[@karabosimela1644]

Very helpful 💫

[@kuldeepkumar-ew2cg]

hello sir iam littelbit confused about how do you choose number of bin =7 pleas explain me

[@ScottDellinger]

Seven bins is just what worked for this data. I look at the min and max values and then picked a logical offset (0.003" each) that would give me between 5-20 bins. For this a "rule" does not exist. Think, "If I use this size container does it show my data in a well organized way?"

[@l_t_truth_seeker]

Thank you very much Sir

[@tzunari]

the amount of times i asked what the dollar sign do, I only understand after I watched this

[@reylanaguada344]

how do u get to "data analysis" in 1:32?

[@ScottDellinger]

First you have to load and Load and activate the Analysis ToolPak. 1) Click the FILE tab, click OPTIONS, and then click the ADD-INS category. ...2) In the Manage box, select Excel Add-ins and then click Go. ...3) In the Add-Ins box, check the Analysis ToolPak check box, and then click OK. Finally In the tabs across the top click DATA -> DATA ANALYSIS (look to the far right) -> DESCRIPTIVE STATISTICS

[@user-pz6yz5eg1c]

Prof. scott can you please explain how we decide bin number as here you take 7

[@ScottDellinger]

There is no "best" number of bins, and different bin sizes can reveal different features of the data. Since this video was originally for 14 year old students, I just give some general "rules of thumb" that generally work well (the 1-4 items in the text box in the video) when picking bin number and width. This is where the "7" comes from, and work wells for simple data visualizations. Using wider bins in smaller datasets can reduce noise due to sampling randomness; using narrower bins in larger datasets can give you greater precision. At a higher level there are many approaches to calculating bin number and width. One of the most common for the number of bins is simply taking the square root of the number of data points and rounding up. If you want to read more I would suggest en.wikipedia.org/wiki/Histogram#Number_of_bins_and_width.

[@karlstalker2890]

I feel like there is an error somewhere in here. You used 0.018 as the range and divided by 6 bins to get 0.003 as the bin size. You then made 7 bins to include all the data. Also, typically when I see histograms, each column includes the upper and lower edges of each range.

[@ScottDellinger]

No...as long as your bins are the same size and you make sure every datapoint fits into a bin everything is good. As to the column showing the bounds, you can certainly choose to format it that way of you so choose. This video originally was intended for 14-15 year old students, so I was focused more on getting them to visualize data. (This was early in their statistics lessons.)

[@adsonkool]

how do i do bin size that goes 1-10 to 10-100 to 100-1000 then 1000-10000

[@ScottDellinger]

adsonkool Just use those numbers for your bin sizes and skip all my calculations that make them all the same size.

[@amiteendraghosh6734]

excellent tank u sir

[@priyanshupathak4755]

Thank you 🙏

[@parisaborzouei7884]

Very helpful

[@divyamverma2606]

thanks!

[@arzoodhaka]

Thanku

[@daverecommendlurdweb01onte26]

you’re a blessing 👆👆👆to me no one has every continuously helped me like you have I thank God for ur presence in my life you’re the best !!! Thanks dude

[@HIM_MOTION]

dankii bafanas

[@ciaranhiggins5736]

Where is the data analysis button?

[@ScottDellinger]

Data tab -> Analysis -> Data Analysis. I don't THINK that it is enabled by default so you may have to load the plug-in yourself first. That's more complicated but this link to Microsoft support article will help. You want the "Load and activate the analysis ToolPak" section. support.microsoft.com/en-us/office/use-the-analysis-toolpak-to-perform-complex-data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6

[@ariqdzaky1166]

thank you so much, it helped me a lot

[@daverecommendlurdweb01onte26]

you’re a blessing 👆👆👆to me no one has every continuously helped me like you have I thank God for ur presence in my life you’re the best !!! Thanks dude

[@daverecommendlurdweb01onte26]

you’re a blessing 👆👆👆to me no one has every continuously helped me like you have I thank God for ur presence in my life you’re the best !!! Thanks dude