Thread: histograms
View Single Post
  #2  
Old February 1st, 2006, 10:08 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default histograms

In article , "=?Utf-8?B?
anVzdCBtZQ==?=" just says...
I have a problem with entering the data to get the result that I need.A study
examined how long air conditioning units operated after repair(in hours), I
have the operating times and know to put them in the 2nd column, but i don't
know how to tell the program that ineed to have results in six fourty hour
wide classes.I'm not sure of the 1st column as the times are for one unit.
I'm using excel 2003

Put the upper bounds of the desired classes in 6 adjacent cells in a column.
Now, create a Histogram with Tools | Data Analysis... | Histogram In the
resulting dialog box, the Input Range is your data set (what you called the
2nd column) and the Bin Range is the new 6 cell range you just created.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions