creating histograms

[hoth7]

hello everyone,. i have two columns in my spreadsheet, the first is "wages" the second is "FEMALES AND MALES" males are represented as "0" and females as "1". i need to produce two separate histograms for the wage rates of males and females respectively and Use an appropriate number of bins for histograms. can someone please tell me how can i separate them and create the histograms? thank you.

 

[pbornemeier]

Sort by the Sex column and copy the resultant Males and Female blocks to different worksheets.

For each of the single-sex worksheets, sort by wages

The "appropriate number of bins for histograms" depends on your data and what you are trying to display. This site has some good discussion on that: http://mathforum.org/library/drmath/view/74078.html

Once you figure out how you want to break down your data, use the FREQUENCY formula to calculate the results.