Spreadsheets for Bayes, GLM, Eigenvalues, curve fitting

codyswan · Mar 19th, 2002, 10:18 AM

Where are some good places to look for excel-based tools related to statistical analysis using Bayesian methods, Generalized Linear Models, Eigenvalues, and curve fitting for multiple types of distributions (e.g., beta, lognormal, weibull)?

I'm hoping for free software or at least free demos. I want to try it out rather than buying and returning several pieces of software.

Thanx

Mark W. · Mar 19th, 2002, 04:08 PM

Have you considered the @RISK suite...

http://www.palisade.com/

DMeador52 · Mar 19th, 2002, 06:42 PM

I have quite a bit of experience in doing some of the things your looking for. But, the best thing I can tell you is that you are much better off using a canned package like Matlab or S-PLUS to do these things.

Curve fitting (on a modest level) can be done quite easily in Excel. However, something such as eigenvalue calculation is a very intensive process and I don't believe that Excel is the place to do it. If it's important to have the results back in Excel, you can always OLE link the other App. I work in a trading environment and traders absolutely love Excel. But, we can' do most of the intense calculations there. So I automate the other App (S+) from Excel and send the data back and forth.

Regards,

Doug

codyswan · Mar 20th, 2002, 09:49 AM

I used @Risk extensively a few years ago. I downloaded the current version and it does much of what I need. The curve fitting is much better than before.

@Risk doesn't do Bayesian analysis or Eigenvalues. I believe some of the other Palisade products do Bayesian. I'm also taking a look at Winbugs for the Bayesian part.

I'll take a look at Matlab for Eigenvalues.

Thanks for your help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 10:18 AM	#1
codyswan New Member Join Date: Mar 2002 Posts: 22	Where are some good places to look for excel-based tools related to statistical analysis using Bayesian methods, Generalized Linear Models, Eigenvalues, and curve fitting for multiple types of distributions (e.g., beta, lognormal, weibull)? I'm hoping for free software or at least free demos. I want to try it out rather than buying and returning several pieces of software. Thanx

Mar 19th, 2002, 04:08 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Have you considered the @RISK suite... http://www.palisade.com/

Mar 19th, 2002, 06:42 PM	#3
DMeador52 New Member Join Date: Mar 2002 Posts: 32	I have quite a bit of experience in doing some of the things your looking for. But, the best thing I can tell you is that you are much better off using a canned package like Matlab or S-PLUS to do these things. Curve fitting (on a modest level) can be done quite easily in Excel. However, something such as eigenvalue calculation is a very intensive process and I don't believe that Excel is the place to do it. If it's important to have the results back in Excel, you can always OLE link the other App. I work in a trading environment and traders absolutely love Excel. But, we can' do most of the intense calculations there. So I automate the other App (S+) from Excel and send the data back and forth. Regards, Doug

Mar 20th, 2002, 09:49 AM	#4
codyswan New Member Join Date: Mar 2002 Posts: 22	I used @Risk extensively a few years ago. I downloaded the current version and it does much of what I need. The curve fitting is much better than before. @Risk doesn't do Bayesian analysis or Eigenvalues. I believe some of the other Palisade products do Bayesian. I'm also taking a look at Winbugs for the Bayesian part. I'll take a look at Matlab for Eigenvalues. Thanks for your help.