Custom Distribution? (Assign specific probability to generate random numbers)

Hey guys
I need to generate random numbers but with a custom distribution, for example generate a random number in a cell with numbers from 1 to 9 (except 3) with different probabilities.

1 and 9 = 5% (each)
2, 6, 7 and 8 = 10% (each)
4 = 20%
5 = 30%
Total = 100%

And on another cell
1 = 19.701%
0 = 80.299%
Total = 100%

----------------------------------
If is not too much...
I also need to generate two more random numbers.
Normal distribution
Mean =2000
Standard Deviation = 400

Uniform Distribution
Range 10000 to 35000

Thank you so much for taking the time!

Try this for your first formula

=LOOKUP(RANDBETWEEN(1,100), {1,6,16,36,66,76,86,96}, {1,2,4,5,6,7,8,9})

RANDBETWEEN randomly assigns a number between 1 and 100
If that number is between 1 and 5, it will assign a 1 to it
between 6 and 15, a 2
between 16 and 35 a 4
and so on.
A Similar technique can be used for your second formula. Give it a try. I'm rusty on my stats, will need to review for your last two formulas.

Note: RANDBETWEEN is volatile and will change every time Excel does a calculation on the page. If you want to lock them in place, Copy> Paste Special> Values to remove the formula and make then constants.