bins

I am trying to do a histogram in excel with the bins starting at 0 and each Bin being 0.2 in width. However when i set the bin width at 0.2 it starts the first bin at 0.11 because that is the lowest number in the dataset. how do i get the bin to start at 0 so that that the bins are...

I have a worksheet called "Summary" that should show the total sales by month by category. On a separate worksheet, called "2019", I have a list of sales. I am trying to update the "Summary" worksheet to show the sum of all of sales for each category for each month. The formula I have at this...

Ok - usually I can search these message boards or find a YouTube video, it's just not happening for me today. I am looking to count unique ID's in one column that meet criteria in three other columns. Column G = "" (blank) Column O = Completed Column L - Coaching Column F contains my ID's I...

Hi All, I'm making an Excel histogram with 100 bins. I don't want 100 labels for the bin values, however. How can I limit the number of labels on the bins (i.e. have 100 bins but only 5 value labels)? Thank you!

Dear All, I do have a sample data set across A1:E4. The data represents the NO Of BINs in which the SKU is kept at the DC. I would like to figure out the dates on which the no of BINs is more than the Modal no of BINs across a given period. The formulae put in F2=COUNTIF(B2:E2,"<>"&MODE(B2:E2))...

I have a set of data that I would like to create bins. For example, 45, 23, and 10 will fall in the 0-49 bin. I created the histogram but am struggling in changing the ranges to display as the bins as the ranges below.:confused: Data: 45 23 897 456 123 10 Bins 0 - 49 50 - 99 100 - 175 176 -...

Hi guys, I was hopeful someone could help me with a formula that will look up a number (E3) and return an associated profile that is within a certain range (range of 100 bins).... For example I know that on Week 2 I will process 1200 bins (F3), and I know that the Heavy (1) profile should be...

Hi i have a sheet with column Total Experience and all these numbers are as follows. 11.03, 0.1,0.11. So my boss wants to know the count of the members as 0-2 years experience how many members, 2-5 years experience how many members, 5-8 years experience how many members,8-10 years experience how...

Hi Everyone, I'm not that technical and I'm hoping someone wouldn't mind helping. I have multiple data sets which vary both in range (lower and upper bounds?). Each data set will also change for each new scenario, for example on any given date Set 1 might have a range of -4 to +4 and the next...

I have a large amount of schedule data that I am trying to bucket into half hour increments. I am looking for any assistance on the best way to do this. Here are the 4 important columns: 1) Segment Start Time (ex. 05/02/2015 12:33:00) 2) Segment End Time (ex. 05/02/2015 13:33:00) 3) Segment...

Hi. Situation: I am analyzing data of a courier company. The data is organised into rows with each row representing a delivery from pickup to destination. I now wish to understand performance of the couriers over different distances (delivery lengths). The total distance of each delivery...