Excel Magic Trick 37: Dynamic Histogram & Frequency Distribu

Dear Christofer99,

I am glad that it helped! I'll keep making more videos!

--ExcelIsFun

Dear heilbronn77,

You are welcome! I'll keep making more videos!

--ExcelIsFun

Dear nsbarnard,

I already have about 20 hours of basic statistic videos at my college web site. Go there and click on the link for Busn 210. You can watch the videos, download the Excel workbooks, and print out pages and pages of handwritten statistic notes!

--ExcelIsFun

Thank you so much for your quick response. I am currently in a statistics class and I attended the first class, the instructor is teaching us with a calculator, however will allow the use of a labtop for tests and class. I thought to myself, "I would love to do this class in excell.", and I found your video's and I am hooked. Thank you so much and I hope you don't mind if I ask questions.

Thanks!! nsbarnard

Dear nsbarnard,

I am glad that this worked!

In 2003 and earlier Excel versions, Merge and Center caused many problems. Instead of Merge and Center, try "Center Across Selection". I made a video concerning this topic. See video:

Excel Magic Trick #76: Alternative To Merge & Center

--ExcelIsFun

I figured it out I think, I had merged cells prior and that does not work. Thanks for the lesson.

Loved this lesson on excel. I am currently taking a statistics class and they are trying to teach us with a calculator, yuk. I was able to follow this lesson and correctly format the spreadsheet. However when I made my chart I could not get my gap width to change to 0. I did enter it in the gap width options area, however my chart did not change like yours? I did use version 2003, I thought that this should not matter? Nadine

Dear UCMSCI,

EXCELlent!

I am happy that this is useful for you and your team!

Hey, In the next month or so, I will begin to post a Statistics Series that will include about 50 videos! Stay tuned because I will show many Statistics Tricks!

--ExcelIsFun

Hi - this is great - I will get my students to use this. The Histogram "feature" in Excel is very problematic, and you have saved me having to think about how to teach them a better way.
Thanks
Nicola

Dear theviper,
The ONLY reason that I am so excited is because anyone who knows their professional content (accounting, physics, finance, or whatever else) and knows Excel, is usually automatically recruited or promoted. Because everyone is required to know Excel and so few people know Excel, anyone who knows Excel well is highly demanded!
By The Way, what is cpsc?
--ExcelIsFun

you get WAAAY too excited about this stuff, and this is coming from a cpsc grad.

But this was informative. I didn't know you could cat in excel formulas. Now I know.

Kudos - 5 stars

Dear cricketfan20078 ,

See my video Respones!

--ExcelIsFun

Dear cricketfan20078,

I will post one in a few days. However, Frequency Polygons are straight forward. You need the midpoints of each class for your X values and Frequency for your Y values - then make an X-Y scatter diagram chart with the points connected with line (DON'T use line chart).

BTW, if you go to my college web site, click on Busn 210 class, find the content for chapter 2, there are hours on videos on this sort of topic.

I'll get back to you soon.

--ExcelIsFun

thanks a lot for posting this helped me a lot! Just one question though, about those frequency polygons... i know what they are but i am not sure how to use them, please could u post a video showing me? thanks a lot!

Dear sammea,

This Histogram has Frequency on the Vertical axis, so if we put an x for the Mode at the top of each column it would not make sense.

Can you look at a past chart where you saw this and tell me what the name of the chart is?

Now I am very curious!?!

--ExcelIsFun

not sure what its called, but it looks like an 'x' on the tallest bar. it actually determines the mode.
thanks for replying!

Dear sammea,

Do you mean Frequncy Ploygon by midpoints?

--ExcelIsFun

Dear sammea,

I am not sure what you mean by "mode line". Tell me exactly what you mean by "mode line". There is one mode for the data in the video. Do you want a mode for each class? And then plot the mode on a secondary axis?

--ExcelIsFun

ok i got the histogram down, but i want to know how to get a mode line using the histogram.can you help asap? i got a presentation near.thanks in advance!
p/s: im using excel 2007 if thats any help.

really nice helped me very much

greetz from austria :)

Cool!! Less Tormet is good!

never mind
i just realized that the 2003 version is similar to the 2007 version
thanks man
you saved me from hours of torment

Dear unwaoko

In 2003, everything you see in the video works, except making the chart. You would have to click on the chart wizard button, in step 1 select column chart, step 3 add title, axes labels & data labels, click Finish. After the chart appears, right-click the columns and in the dialog box click on the options tab, then change gap width to 0.

That should do it. If that does not work, ask me more specific questions and I will answer!

--ExcelIsFun

how do you create a histogram with excel 2003 since i only have microsoft excel 2003

Dear pedrolagoa2,

The frequencies are correct. The class 10 up to 15 means that 10 is included but 15 is not included. The <15 counts everything below but not including 15. The <10 counts everything below but not including 10. Thus, taking the difference, 15 will not be counted and 10 will be counted. If you look at this more closely you will see that the frequencies are correct!

-ExcelIsFun