Histogram Development

[Pestomania]

Good day all,

I am working on a dataset and trying to create some formulas and a histogram for the year, but I am getting a lot of issues whenever I try to do do it.

Please see the chart below which shows three columns of the same vertical set (i.e. (2000, 2001]). Not sure what to do to make this correct.

Link to the dataset: Arrests Dataset

Thank you for any help!

 

[StephenCrump]

You given us no information on how you're getting the x-axis to look like this.

But it should be very simple to specify:

 

[Pestomania]

You given us no information on how you're getting the x-axis to look like this.

But it should be very simple to specify:

View attachment 114211

Hi Stephen, I apologize. I downloaded the dataset and selected the entire year column and clicked Histogram in Excel, it gave me a weird decimal point response.

I then did the count totals you have above, clicked histogram and it gave me what you see above.

What you have here is a bar chart, rather than a histogram. The histogram option in Excel is giving the weird data above.

 

[StephenCrump]

The histogram option in Excel is giving the weird data above.

OK, that makes sense. I get the same histogram as you, as Excel automatically picks a bin width of 0.28 (i.e. around 1/3 of a year, so that the bins are 1997.00 to 1997.28, 1997.28 to 1997.56 etc). You can adjust the bin width to 1, but Excel will still show each bin as a range, rather than a single value 1997, 1998 etc

So the obvious question. Do you need a histogram? Are you going to do some frequency analysis based on numbers of arrests?

If you just want a year by year graph, then bar chart is the easier way to go.

If you do want a histogram, perhaps you could use the better Analysis ToolPak version instead. See here, for example: How to make a histogram in Excel

​