Kapalı

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)

Beceriler: Veri İşleme, Eğitim & Özel Ders, Excel, Matematik, İstatistik

Daha fazlasını görün: excel probability, probability solve, 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 project server work, excel range find, excel formula range, processing excel, excel range, alpha solution, formula excel

İşveren Hakkında:
( 0 değerlendirme ) Riyadh, Saudi Arabia

Proje NO: #4399766

12 freelancer bu iş için ortalamada 103$ teklif veriyor

PerfectSquare

Hi statistics expert here I can do this Let start Thanks

1 gün içinde 143$ USD
(64 Değerlendirme)
5.2
diegoforteza

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

in 3 gün içinde88$ USD
(3 Değerlendirme)
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 Daha fazlası

in 3 gün içinde150$ USD
(1 Değerlendirme)
1.5
hnhuang

Please check your PMB.

in 3 gün içinde35$ USD
(0 Değerlendirme)
0.0
UPCsoftware

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

in 2 gün içinde30$ USD
(0 Değerlendirme)
0.0
harishary

I am ready to begin work immediately

in 5 gün içinde86$ USD
(0 Değerlendirme)
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 Daha fazlası

in 3 gün içinde250$ USD
(0 Değerlendirme)
0.0
davecoleman

Hi.I can help to solve this problem.

1 gün içinde 110$ USD
(0 Değerlendirme)
0.0
PETRA

I can help you.

in 3 gün içinde154$ USD
(0 Değerlendirme)
0.0
tupuconstantin

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

in 3 gün içinde88$ USD
(0 Değerlendirme)
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 Daha fazlası

in 3 gün içinde75$ USD
(0 Değerlendirme)
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 Daha fazlası

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0