frequency distribution

Hi all, I am trying to calculate the percentiles in a frequency table, but I'm having trouble creating the cum sum with multiple criteria - the idea is to replicate the values in column D State Color Count Cum. sum for "blue" per state Alabama Blue 2 2 Alabama Yellow 4 Alabama Blue...

Imagine that we have 100 pens in our box (each numbered from 1 to 100). We mix them and then randomly draw ten pens and put them aside. Afterwards, we put ten new pens numbered from 101-110 into the box, and then again randomly draw other ten pens and put them aside. We continue doing these...

Hi all, new to this site. I'm hoping to find an answer to this. I have been looking to figure this out for some time, and have tried a couple of methods that don't work quite right. I want to find the median in a frequency distribution table in excel. I only have one sample group to work from. I...

Hey guys, I have a spreadsheet with the past frequency of losses in a row before having a winner. What formula can I use to calculate the probability of having a winner after 1,2,3(etc) losses in a row according do this data? Thanks, appreciate the help!

I have a list with more than 10 000 rows containing Units/Sub-units. Each unit can have from 1 to n sub-units, and are characterised by a set of properties as shown below. Unit Sub-unit Property1 Property2 Fabrication status A 1 a d Not started A 2 b d Started A 3 a e Completed B 1 b d...