I am posting my question again because I really need help. My boss is a math whiz and gave me the question, and I am freaking out because I can't figure out how to do it. I need to figure out how many groups of 10 there are in the prime numbers from 2-67 and how many groups of 10 there are in the the numbers that are only divisible by 3 from 6-69. No numbers that create a remainder should be used so it is just 6,9,12,15,18...till 69. Please help me my math sucks. How would I formulate this to get the answer in an exell worksheet. Thank you so much for your help. Andrea

Question

I am posting my question again because I really need help. My boss is a math whiz and gave me the question, and I am freaking out because I can't figure out how to do it.  I need to figure out how many groups of 10 there are in the prime numbers from 2-67 and how many groups of 10 there are in the the numbers that are only divisible by 3 from 6-69. No numbers that create a remainder should be used so it is just 6,9,12,15,18...till 69. Please help me my math sucks. How would I formulate this to get the answer in an exell worksheet. Thank you so much for your help. Andrea

dumbcow · Answer

there are 19 prime numbers from 2-67, to find groups of 10 use combinations
19 choose 10 = 19!/(10! 9!) = 92,378
or in Excel use function "=Combin(19,10)"

anonymous · Answer

Thank you. Andrea 
I will try it.

dumbcow · Answer

For next one, there are 22 numbers divisible by 3 from 6-69
22 choose 10 = 646,646

anonymous · Answer

Thanks