Excel Statistics 31: Histogram using Data Analysis Add-in

[jonathan92591]

Thank you!

[ExcelIsFun]

@jonathan92591 , You are welcome!

[ochysam75]

I need to creat a graph from a huge number of data. Its a result from sample collection. The date is from 1981 to 2011 with different variable measurements like temperature,conductivity, suspended solid etc. I want to plot a graph to show the trend of change over time.Please How do I go about it.

[ExcelIsFun]

post questions to:

mrexcel[dot]com/forum

[SenorCajones]

@ochysam75 And while you're at it, Mr. Excelisfun, he'd like to create averages yet account for the outliers in separate linked charts, each with its own linked bar and pie charts...eventually breaking all of the data down to the thickness of one electron. And can you please do that for him AAASSSAAAPPP. Thanks, you're a prince of peace.

[theboss4223]

thanks so much mate

[ExcelIsFun]

You are welcome!

[thenadaad]

Thank you very much!! all your tutorials are amazing !!

[ExcelIsFun]

You are welcome!

[Mananpatel143]

This video is just amazing... i was stucked on how to draw histogram and now finally with your help i did it. thank you very much..

[SenorCajones]

@Mananpatel143 Now it's time for that remedial English course you've been putting off.

[CivilTechStudent]

Very good, thank you!

[ExcelIsFun]

You are welcome!

[cxnitesh]

Microsoft should pay you for this.. to make histogram i read the instructions on their excel support website and those instructions got me no where..

but thanks a lot for these videos.. really helpful!

[ExcelIsFun]

Nothing like a visual to see how!

[ExcelIsFun]

Yes, Microsoft should, but since they are an abusive monopoly, they would NEVER do that.

[youtubbin16]

very informative, but still having troubles grasping some of it. Back to the books!

[ExcelIsFun]

I hope the combo of books and videos will get it done for you!

[3rni3PL]

Let me tell you how much these types of techniques are helping me.Since I'm very good with computers & OK with math,I use techniques like this to analyze data I extract & discover ways to work more productively at my job. I analyze the data, & compile & calculate solutions to be more lean & save on set up times & on raw materials, and on actual time. I have received several promotions & I am hated by all my coworkers who can't even formulate a simple email. One day it will do you alot of good.

[ExcelIsFun]

I am glad that the videos help!

[rodman182]

Thanks. Really helped. Still hate statistics though.

[ExcelIsFun]

You are welcome!

[lopov74]

Thank you very much! This was very helpful!

[godswordsheal]

Very, very helpful. Thanks.

[ExcelIsFun]

I am glad that it was helpful!

[TheNatlyful]

how do you know what your bins should be?

[ExcelIsFun]

You have to watch the earlier videos in the series:

Excel Statistics 20

Excel Statistics 21

Excel Statistics 22

It is never a straight forward calculation, though. It is part science and part art.

[xeniosm]

wow 1 and a half year space between lesson 30 and 31!

[ExcelIsFun]

Cool!

[ExcelIsFun]

Ya, it takes a long time to make all the videos!

[fpseli117]

thank you so much you really helped me with my ib math portfolio

[ExcelIsFun]

You are welcome!!

[ExcelIsFun]

You are welcome!