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
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