Em Andamento

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

Ver mais: would like know whether, lognormal, excel automate, automating excel, probability density, excel probability density, hence proficient, excel risk, automate excel work, zero distribution, excel data points, collect data using excel, job work spreadsheets, 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

Premiar a:

igorssv

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 Avaliações)
3.8

12 freelancers estão ofertando em média $1015 para este trabalho

Teloquence

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)
7.0
seaanddream

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)
6.5
deepbluetech

A proposal has not yet been provided

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

A proposal has not yet been provided

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

A proposal has not yet been provided

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

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)
3.5
Ibrahim33

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)
2.9
quantinvest

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

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

A proposal has not yet been provided

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

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)
0.0
freetowork2015

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)
0.0
nifferboy

Bir öneri henüz sağlanmadı

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