Excel Statistics 31: Histogram using Data Analysis Add-in

See how to create a Frequency Distribution, a Cumulative Freqency Distribution, a Histogram Chart and an Ogive Chart with the Data Analysis Add-in.

Chapter 02 Busn 210 Business and Economic Statistics and Excel Class

This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel Excelisfun Girvin

Category:

Education

Tags:

• Excel
• 2007
• Statistics
• Frequency
• Distribution
• Histogram
• Chart
• and
• an
• Ogive
• with
• the
• 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

[theboss4223]

thanks so much mate

[ExcelIsFun]

You are welcome!

[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.

[SenorCajones]

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

[ExcelIsFun]

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

[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..