4 ms·
The income histogram has zeroes cut off on the horizontal axis. Or is it just me?
by joubert 17y ago
The income histogram has zeroes cut off on the horizontal axis. Or is it just me?
- ironchef 17y agoI don't think it's just the histogram. Check out the Age vs Income plot. There's no way people aren't making over 100k.
- deleted 17y ago[deleted]
- deleted 17y ago[deleted]
- viggity 17y agoI cut off the age vs income plot at 100k because otherwise it would severely compress the points where it would be really hard to discern anything from it. There are people who reported over 100K.
- joubert 17y agoHow about reporting in 1000's, instead of including every zero? Typical in financial statements.
- viggity 17y agoI wanted to do that, but I'm not proficient enough in excel to do it quickly. Surprisingly enough, even getting the histograms was kind of a pain in the ass. I spent an hour and a half getting those 4 charts done.
- roundsquare 17y agoYeah, its always shocked me that Microsoft couldn't be bothered to put in decent histogram fucntionality where you can choose your buckets and it'll put together a histogram.
- thetrumanshow 17y agoYes, starting at 105,000 and on up to 300,000 (the max on the chart) the last zero seems to have been cut off,
- viggity 17y agoI didn't even notice, I guess it is some sort of bug (or "feature") with excel, because the data driving that chart is correct. The numbers are in the correct order (increasing in 5K increments), but the second half has a zero clipped for some reason.
- joubert 17y agoPerhaps decreasing the font (I use Numbers so don't know whether it is possible in Excel) of the horiz. axis will allow the full text to appear (if you can't display in 1,000's).