Closed

solve probability in MS excel

This project received 12 bids from talented freelancers with an average bid price of $103 USD.

Get free quotes for a project like this
Employer working
Project Budget
N/A
Total Bids
12
Project Description

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)

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online