Home » Video » ...

How to draw histogram in excel Videos

How to Construct a Histogram in Excel 2007

This video demonstrates how to create a histogram from data in Excel 2007.

User Comments

Dr. Cyders commented on 05 Feb 2012

@Pyarapradip I agree - unfortunately, Microsoft didn't see fit to include a histogram function with the base install of Excel. There is an add-on pack that gives the additional functionality, but even then, their tool is pretty clunky. Instead, I recommend programs such as SciDAVis and FreeMat for advanced plotting and statistical analysis, as they are far more powerful, and produce better looking graphs than Excel. This was just an example to show how histograms work.

Kim Williams commented on 05 May 2013

Thanks, Thanks Thanks I have been working on this project for class that required me make a histogram etc for my math 111 class. This was a Blessing and thank you for sharing your knowledge with other and God Bless you.

Ishan Chotani commented on 21 Feb 2013

thnx sir.. but how we can calculate data for histogram in production of components in any company.....?

Royal nash commented on 09 Mar 2013

Thanks and easy to understand your a good teacher

swiftguygaming commented on 16 Jul 2012

Thanks! You helped me with my math assignment :D

SchoolandUniversity.com commented on 21 Mar 2013

good teachers here send in our school some

saba sahba commented on 25 Feb 2013

why don't you control shift enter?

stan oo commented on 05 Feb 2013

Thank u sir. very simple.

Valentino Sanvito commented on 14 Sep 2012

thank you so much

How To... Draw a Simple Histogram Excel 2010

Here's a useful technique using Excel's Data Analysis tool to draw a histogram. This video shows you how to create intervals (called bins) and measure ...

User Comments

Ahmed Moussa commented on 10 Nov 2014

very simple and easy to understand. thank you

Vanmax22 Gaming commented on 28 Dec 2014

I hope those weren't students actual grades

Troxxity commented on 28 Sep 2015

Eugene I love you

Excel Statistics 01 - Creating a Frequency Distribution and Histogram

This video demonstrates how to create a Frequency Distribution table and a Histogram chart in Excel 2010 using the Frequency Function. Details/Examples: ...

User Comments

Xictus commented on 24 May 2013

Thanks Michael! This video is the only one (of many i've seen) that properly shows the convention for Bins and Histograms (that's it "equal or lower to" the value shown, or in your words "the upper level of each interval"). It seems that everybody thinks just the opposite, making their videos misleading. P.S.: I tried to access to the Excel file linked on the Word document and the link is broken. But i got my hands on the file by searching on the backwardsteps site! Thanks

Tom Guy commented on 27 Oct 2013

Where di you get the −4? You did a lot of things that assumed we knew where you were getting this stuff from. If you’re trying to teach someone how to spell dog, don’t tell them it’s spelled like dog.

Michael Herman commented on 02 Apr 2013

a histogram is a type of bar chart. most histograms have no spaces between the bars, which i left. that can be easily changed.

Tyler R. commented on 24 Mar 2013

Hi! I just wanted to say thanks for making such a clear, easy to follow video. It really helped me in my stats class.

Tabitha Dente commented on 02 Apr 2013

What is shown is NOT a histogram. It is a bar chart.

NOOBlikesgaming commented on 14 Aug 2013

how though

Joseph Mackay commented on 16 May 2013

how?

Frequency Counts and Histograms in Excel for Mac 2011

In the video, I show how I do frequency counts and histograms of data in Excel for Mac 2011 (to answer questions such as "how often did a value, or a range of ...