Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

answered 2013-02-17 04:46:34 +0100

ROSt52 gravatar image

@Confuddled @horst,

Why was horst's proposal not the solution? - it is needed to define bins to count how many entries are in each bin - next is to create a column chart with bins at the x-axis and the counts on the y-axis

I did not check horst's formulas because they look OK to me. I only used a different approach using not if-function and counted thereafter.

I defined 4 bins covering the range >0 and <=12. For bin1 (>0 and <=3) I used the formula

=IF(AND(B3>0,B3<=3),1,0)

Here is what I did in Calc

image description

and what I got as chart (=histogram):

image description