bin

I am trying to find a way to create optimal bin size for the data (random size/rows - based on user input) provided by user to create a histogram. The data has random times within a 24 hour time period along with varying quantities. I did find two methods online, but they had issues; The...

Hello, I am trying to sort data I have into bins, preferably through some sort of formula. I have tried looking through this website (and others) but can't seem to find a solution. Any help would be greatly appreciated. Ok, so I have two columns. The first column (say Column A) has a number...

Hello, I'm using excel 2013. I have a table that is a log of a product that displays how many days until it failed, date it was shipped, the cause of the failure, etc. There is also a column that buckets the causes by a broader category. ex. cause "broken components" and "broken frame" fall...

Is possible count by formulas eBay Buy It Now price ? My cost price is £10 I want 40% = £14 (£4 profit) I need add ebay Fees + Postage + PayPal fees so I need selling price £17.90 Where is PayPal 3.4% + 20p Ebay 40p listing Ebay 10% Fee Postage £0.9 I need formula where I set my cost...

Hi folks, The idea is to have a formula to count the number of rows(clients) who have at least 1 or more of the options: Anxiety Depression Bipolar I have the following which works a treat: =COUNT(1/FREQUENCY(IF(ISNUMBER(SEARCH({"Anxiety","Depression","Bipolar...

I have been googling this to no avail: How can I put multiple histograms on a single chart without having all of the bins (i.e., the x-axis values) being the same? This is easy to do with the XY Scatter Plot format (I mean letting all of the plots have their own range of X values), but I can't...

Why do I have More with a number in the results? How do I get rid of the More and number? Without having to delete and resort. Thanks for your help in advance.

Heya, I'm trying to make an histogram, but I get totally lost when they ask me to define BIN-numbers. I understand these are the limits between which you wanna count the data. E.g. if I have the numbers 3.8, 4.3, 4.2, 5.1, 5.5, 5.3, 7.1 and the following BIN numbers: 4 5 6 7, I'll find a...