|
Anthony's VBA Forum Where the knowledge is shared |
|
|
View previous topic :: View next topic |
Author |
Message |
duskgal
Joined: 06 Jan 2010 Posts: 2
|
Posted: Wed Jan 06, 2010 5:14 am Post subject: Excel program to find statistical distribution of data |
|
|
Hi!
I have just been introduced to the whole new world of Excel Programming and am required to create a program that allows a user to input his/her data into my program, and the program gives an output on what statistical distribution the data follows.
I was wondering if this was possible? And what other possible methods or suggestions for this?
Should I use VBA? Solver?
The data could follow any distribution. Gamma, Weibull, Normal, Logistics. Just to name a few.
Would really appreciate any help and suggestions!
Thank you! |
|
Back to top |
|
|
Anthony Site Admin
Joined: 29 Sep 2004 Posts: 36 Location: New York, USA
|
Posted: Thu Feb 04, 2010 12:49 pm Post subject: |
|
|
You may try to get a copy of this: http://excel-modeling.com/index_008.htm
It has VBA source code that generates the following distributions:
Log Normal Distribution | Log Pearson Type III Distribution | Normal Distribution
Chi-Square Distribution | F-Distribution | Student-T Distribution | Multivariate Standard Normal Distribution | Gamma Distribution | Beta Distribution | Hypergeometric Distribution | Triangular Distribution | Binomial Distribution
Anthony |
|
Back to top |
|
|
duskgal
Joined: 06 Jan 2010 Posts: 2
|
Posted: Thu Feb 04, 2010 7:53 pm Post subject: |
|
|
Hi,
Thank you so much for replying. Have you heard of the software EasyFit? |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2002 phpBB Group
|