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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
pbornemeier
Well-known Member
- Joined
- May 24, 2005
- Messages
- 3,911
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.
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.
Upvote
0
Similar threads
- Question
