# solve probability in MS excel

Hello

I need a solution to find the next number based on group of numbers I got about 30 number as a series of numbers that range from 0001 to 4999

I want the formula that generate these numbers to find the next number (or probable one) the numbers are:

2437

2838

2732

3009

2814

579

1601

3610

707

3467

2446

3480

4846

4205

4802

4054

3554

3430

1892

532

1934

4404

1535

111

39

4323

4003

1190

1487

the trick is the series might have changed the to new one somewhere in the way up so take the first number (1487) as the start point to find the next (1190) and so on ... if you find the series then somewhere the formula doesn't work it means the series has changed and find the next one (I don't know how many are there it might be only one and might be many).

one hint I can provide is the excel formula that might have been used:

BETAINV(probability,alpha,beta,A,B)

where probability = 0,0002

A=1

B=4999

obviously you have to find the steps (alpha, beta)

Project ID: #4399766

## 12 freelancers are bidding on average \$103 for this job

PerfectSquare

Hi statistics expert here I can do this Let start Thanks

\$143 USD in 1 day
(64 Reviews)
5.2
diegoforteza

Hi I'm a statistician I can do what you need.

\$88 USD in 3 days
(3 Reviews)
3.4
Evs1

Hello, Greetings From Evirtual Services!! We understand your value of your time and believe in excellent service with 100% satisfaction. I am Jason and I represent Evirtual Services fast growing US based com More

\$150 USD in 3 days
(1 Review)
1.5
tupuconstantin

\$88 USD in 3 days
(0 Reviews)
0.0
prabash87

Hello, I am an undergraduate for the special degree in Mathematics. So I'm a very hard worker, highly literate and numerate. I am also an expert in Excel and Statistics, and have experience with data analysis and pro More

\$75 USD in 3 days
(0 Reviews)
0.0

Hi I Have already solved it.... The Solution is a 29 Term equation placed on an excel sheet substitute in it with any number of the 29 numbers it will give you the next one ........... i can send you the excel file of More

\$30 USD in 1 day
(0 Reviews)
0.0
PETRA

\$154 USD in 3 days
(0 Reviews)
0.0
harishary

I am ready to begin work immediately

\$86 USD in 5 days
(0 Reviews)
0.0
UPCsoftware

We have big experience. We can make this task at high level.

\$30 USD in 2 days
(0 Reviews)
0.0
hnhuang

\$35 USD in 3 days
(0 Reviews)
0.0
Andromedah

If you graph the numbers in Excel as a scatter with line chart, you can clearly see where the series changes, because the second half doesn't quite match the first. To solve this, I think you will need either more numb More

\$250 USD in 3 days
(0 Reviews)
0.0
davecoleman

Hi.I can help to solve this problem.

\$110 USD in 1 day
(0 Reviews)
0.0