HISTOGRAM ANALYSIS - BIN RANGES

[Antoan]

Hello!



I am writing here regarding bin ranges's creation. I am not totally sure how i am supposed to do that, but I am 100 percent sure that these are the exact limits in terms of numbers that i have to use. The observation and Job time on the left have 6500 rows in total, so i just posted it as an example. Additionally, when I try to create the frequency row to build the histogram, the formula is spilling for some reason. I apologize for not using XL2BB; it doesn't work right now on my Excel for some reason, but that's pretty much it anyway.

1. Could you tell me how i can create the bin ranges?
2. How can I transform the data into the frequency column so i can create a Histogram?

Thanks in advance!

Your contribution would be highly appreciated!

Observations	JobTime
1​	202​
2​	199​			bin limits	frequency
3​	158​			<= 90
4​	151​			(90, 105]
5​	222​			(105, 120]
6​	201​			(120, 135]
7​	1339​			(135, 150]
8​	195​			(150, 165]
9​	182​			(165, 180]
10​	270​			(180, 195]
11​	1592​			(195, 210]
12​	226​			(210, 225]
13​	135​			(225, 240]
14​	246​			(240, 255]
15​	519​			(255, 270]
16​	929​			(270, 285]
17​	104​			(285, 300]
18​	116​			(300, 315]
19​	217​			(315, 330]
20​	142​			(330, 345]
21​	125​			(345, 360]
22​	220​			(360, 375]
23​	153​			(375, 390]
24​	223​			(390, 405]
25​	158​			(405, 420]
26​	184​			(420, 435]
27​	202​			(435, 450]
28​	159​			(450, 465]
29​	161​			(465, 480]
30​	227​			(480, 495]
31​	153​			(495, 500]
32​	210​			>500

 

[AhoyNC]

This link may help. Probably starting around the 13:50 mark is where you'll find how to set up bins and frequency.