# 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

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

Proje NO: #4399766

## Bu iş için 12 freelancer ortalamada \$103 teklif veriyor

PerfectSquare

Hi statistics expert here I can do this Let start Thanks

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(64 Değerlendirme)
5.2
diegoforteza

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

in %bids___i_period_sub_35% gün içinde88%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(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 Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
1.5
hnhuang

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
UPCsoftware

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

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
harishary

I am ready to begin work immediately

in %bids___i_period_sub_35% gün içinde86%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(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 Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
davecoleman

Hi.I can help to solve this problem.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
PETRA

in %bids___i_period_sub_35% gün içinde154%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
tupuconstantin

in %bids___i_period_sub_35% gün içinde88%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(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 Fazla

in %bids___i_period_sub_35% gün içinde75%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0