Addressing Odd Behaviour in Histogram Bin Counting for Experimental Data

In summary, When creating a histogram in OpenOffice Calc (Excel equivalent), the frequency function may display odd behavior when counting for a certain number, such as placing it in the wrong bin. This can be solved by setting the bins to start at 1 instead of 0 and understanding that the frequency function searches from a bin down to the last one.
  • #1
Hypercubes
38
0
I am making a histogram for some experimental data in OpenOffice Calc (Excel equivalent). However, when I have it count frequency for a certain number, it displays odd behaviour.

For example:

Data:
1
499500
1000
375250
1000

Bins:
0
50000
100000
150000
200000

The problem is that it counts the 1 in the data in the 50000 bin instead of the 0 bin, which seems pretty ridiculous. If I set the 0 bin to 5, for example, it is grouped under that. My question is, is this statistically correct behaviour? If not, how should I fix this? Start the bin at 1, perhaps?

Thanks in advance.
 
Physics news on Phys.org
  • #2
Never mind, I found what the problem was.

Apparently the frequency function searches for frequency from a bin down to the last one. For example:

Bins
0
5000
10000

The corresponding ranges are:
0-0
0-5000
5001-10000
 

What is a histogram bin?

A histogram bin is a range of values that is used to group data in a histogram. It is represented by a bar on the x-axis of the histogram.

How do you determine the number of bins for a histogram?

There is no specific rule for determining the number of bins for a histogram. It depends on the number of data points and the underlying distribution of the data. A common rule of thumb is to have between 5-15 bins, but it is important to experiment with different bin sizes to see which one best represents the data.

What is the purpose of a histogram bin?

The purpose of a histogram bin is to group data into meaningful categories to better understand the distribution of the data. It allows for visual representation of the data and helps to identify any patterns or trends.

Can the number of bins in a histogram affect the interpretation of the data?

Yes, the number of bins in a histogram can affect the interpretation of the data. Too few bins may oversimplify the data and hide important patterns, while too many bins can make the histogram difficult to interpret. It is important to choose an appropriate number of bins to accurately represent the data.

Are there any limitations to using histogram bins?

Yes, there are some limitations to using histogram bins. Histograms can only represent numerical data, and the shape of the histogram can be affected by the choice of bin size. Additionally, histograms may not be suitable for all types of data, such as data with outliers or non-normal distributions.

Similar threads

I Computing uncertainties in histogram bin counts
    • Set Theory, Logic, Probability, Statistics
Replies
3
Views
7K
Histogram Bin Sizing Methodology
    • Set Theory, Logic, Probability, Statistics
Replies
2
Views
3K
A Bin Width for Overlay Plots of Data + Estimation
    • Set Theory, Logic, Probability, Statistics
Replies
8
Views
2K
Fitting distribution to histogram with low number of counts
    • Set Theory, Logic, Probability, Statistics
Replies
8
Views
4K
Excel Histogram How does it calculate bin width
    • MATLAB, Maple, Mathematica, LaTeX
Replies
1
Views
12K
Histograms in Excel: Analysis of Lab Report Grading
    • Computing and Technology
Replies
4
Views
4K
Creating Histogram & PDF for Data Sample
    • MATLAB, Maple, Mathematica, LaTeX
Replies
1
Views
3K
MATLAB Counting Occurrences in a 2D Array with MATLAB
    • MATLAB, Maple, Mathematica, LaTeX
Replies
1
Views
8K
MHB A PHP Function To Perform Nth-Order Lagrange Interpolation
    • General Math
Replies
1
Views
3K
I'm not sure what you are asking here. Could you clarify?
    • Calculus and Beyond Homework Help
Replies
2
Views
1K

Hot Threads

Recent Insights

Back
Top