Probabilty

%3CLINGO-SUB%20id%3D%22lingo-sub-912132%22%20slang%3D%22en-US%22%3EProbabilty%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-912132%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20find%20the%20probability%20of%20a%20number%20being%20drawn%20from%20a1%20to%20a41%20cells.%20I'm%20labeling%20the%20numbers%201%20that%20are%20being%20drawn%20sporadically.%20I'm%20trying%20to%20find%20the%20probability%20for%20a42%20cell%20being%20drawn.%20(Like%20a%20lottery).%26nbsp%3B%20Thanks%2C%20Ann%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-912132%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

I'm trying to find the probability of a number being drawn from a1 to a41 cells. I'm labeling the numbers 1 that are being drawn sporadically. I'm trying to find the probability for a42 cell being drawn. (Like a lottery).  Thanks, Ann

1 Reply
Highlighted

Hello @curley1,

 

I'm afraid I need some clarification on your problem before I can provide an answer:

  • Is the cell A42 a value contained inside the range A1:A41?
  • Are the values in A1:A41 all unique? Are some duplicates?
  • Are you looking for the probability of drawing A42 after only one draw? After multiple unsuccessful draws?