solve probability in MS excel

Closed

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)

Skills: Data Processing, Education & Tutoring, Excel, Mathematics, Statistics

See more: excel probability, solve probability, probability how to solve, how to solve probability, can 0 be a probability, work on ms excel, excel formula, excel trick, excel 2013 formula, point excel, probability data, betainv, excel next number series, beta data, generate data excel, excel probability formula, excel find numbers, bid ms project server work, word excel nternate data entry work europ, probability statistic work cited mla format, excel template quality checking work, excel range find, excel vba project online work 2009, excel data web doesnt work xhtml, excel chart graphs contract work

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

Hello, I can help you with the task, quickly! Thank you, Constantin

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

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

I can help you.

$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

Please check your PMB.

$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