Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Question how to solve using excel

what is the probability that a 4-digit license plate will have exactly one pair of numbers if all digits 0-9 are equally likely to appear?
  #2   Report Post  
Junior Member
 
Posts: 18
Default

Quote:
Originally Posted by lost_and_confused View Post
what is the probability that a 4-digit license plate will have exactly one pair of numbers if all digits 0-9 are equally likely to appear?
Hi,

sorry I don't quite understand ( due to my English skills .. ) what you mean
with "one pair of numbers".

If you mean all possible combinations of 4-digit numbers that can be formed
from numbers from 0 to 9 are awailable, the answer is 1/10 000. Because
license plate can have numbers 0000, 0001, 0002, ... 1000, 1001, 1002 ...
9999. All combinations makes 10 000 different 4-digit numbers.

If you mean what is the possibility to get 4 numbers "right" when
you use numbers from 0 to 9. Thats only 210 variations of numbers.
This is the case which is similar as lottery. So think that you have only
10 possible numbers and you have to find a row "4-right".
At this case the order of digits doesn't matter ; 0278, 7208, 8270, 8207 ...
are all the same. Each of those have the "right" numbers 0, 2, 7 and 8.
This kind of combinations you can make from 10 digits only 210
different combinations when using 4-digit numbers.
At this case the possibility is 1/210.
You can find more info from Excel-help topic : Combination-function.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you help me to solve the below equation in excel ? K Lee Excel Worksheet Functions 10 November 30th 08 04:25 AM
In Excel jow do I solve for X in X^1.5? Shawn Excel Discussion (Misc queries) 12 February 18th 08 05:48 PM
how can I solve two equation with excel? peyman Excel Discussion (Misc queries) 1 February 3rd 07 08:18 PM
How can Excel solve this? zeyneddine Excel Discussion (Misc queries) 4 September 27th 06 10:26 PM
Can Excel solve this or get to optimum. Dennis Saunders Excel Discussion (Misc queries) 1 March 3rd 06 12:54 PM


All times are GMT +1. The time now is 10:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"