Fit distributions to data using Palisade @Risk software (and Excel)

I have a large job to fit around 500 separate data series to Probability Density Functions using Palisade @Risk. The data are spread across about 100 different spreadsheets (each with an average of ~5 data sets to be fitted).

These data can be fit manually using @Risk, but this is slow and tedious work. I would like to know whether someone can automate this task, at least partially.

A major difficulty is that all of the data sets are different sizes, and hence (currently) need to be individually selected by hand.

Each data set is arranged as Cumulative (X,P) Points and will need to be fitted using that option in @Risk. Each data set will need to be fitted to a lognormal distribution with a fixed bound lower limit of zero and open upper limit (extends to +Infinity).

You will need to have a recent version of Palisade @Risk to complete this job and will need to be proficient at using it.

I am hoping that someone can come up with a clever way of (at least partially) automating this task.

Habilidades: Excel

Veja mais: proficient in using, i would like to know whether, lognormal, fit, excel automate, automating excel, probability density, excel probability density, hence proficient, excel risk, automate excel work, zero distribution, excel data points, import data using drop menu excel, collect data using excel, capturing research data using excel, job can work spreadsheets, import excel data using nhibernate, excel report mysql data using php, proficient excel, reading excel data using, capture data using excel, read excel data using, find excel data using

Acerca do Empregador:
( 19 comentários ) Sydney, Australia

ID do Projeto: #6842884

Concedido a:


As discussed if you need only summary spreadsheet I can to automate this work. I want to create program that uses RISK functions and calculate parameters mu and sigma for lognormal distribution. Waition for your resp Mais

$750 AUD em 3 dias
(17 Comentários)

12 freelancers are bidding on average $1015 for this job


Hello, I am top excel developer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your refere Mais

$1000 AUD in 4 dias
(234 Comentários)

Hi, my name is Sevinc. I belive you remember me from our previous project... I am a 5-star excel and vba coding expert here. pls check my profile and feedbacks first to have some idea bout the quality of my previous wo Mais

$950 AUD in 5 dias
(108 Comentários)

A proposal has not yet been provided

$1000 AUD in 5 dias
(136 Comentários)

A proposal has not yet been provided

$1100 AUD in 10 dias
(46 Comentários)

A proposal has not yet been provided

$1250 AUD in 20 dias
(14 Comentários)

Hi sir, It is being my pleasure to introduce you to me. I'm organize and hard working person. I can assure you that I follow the instruction to provide you quality job. I am expert in excel, web research, searchin Mais

$750 AUD in 7 dias
(9 Comentários)

Hello Dear my name is Ibrahim Ragab I'm an administrative assistant specializes in all kind of data entry services. I'm highly experienced in any kind of handwritten data entry, web researching, excel, word SEO Mais

$1000 AUD in 3 dias
(9 Comentários)

hi there, there is a way I think. let discuss this further

$1111 AUD in 3 dias
(1 Comentário)

A proposal has not yet been provided

$1333 AUD in 20 dias
(0 Comentários)

Good day, My name is Nikola Nuspahic and I am business manager at BlueViSion IT Solutions. It is a team of web developing and market research experts from East Europe. Our expertise are Web Development, Database Dev Mais

$911 AUD in 20 dias
(0 Comentários)

I am experienced and talented • Able to cope with pressure and work in a fast paced environment. • Willing and capable of learning and adapting quickly. • Understanding a client’s needs and issues from a business Mais

$1250 AUD in 20 dias
(0 Comentários)

Bir öneri henüz sağlanmadı

$888 AUD in 3 dias
(0 Comentários)