Excel Statistics

Well, I just need some Excel statistic functions, and does not want to call Excel, so I looked on .NET support, and find NOTHING!. :thumbd:

So, I are ranting here:
:mad:
... and whining here:
:mad:
_

Rant away :)

As to your problem, might I suggest, OH I don't know, writing a program. :)

This might help.
http://www.bearcave.com/misl/misl_te...tat/index.html

I know, everyone please don't wack me. Just making a bad joke.

Quote:

---

Originally Posted by sotoasty

...
As to your problem, might I suggest, OH I don't know, writing a program. :)
...

---

Ok, so, I need to code an accumulated gamma function, check it works equally than Excel Function, lost time, debugging, post the code and being mocked by nasty boys. :D

Thanks Billy Gates. You are so nice.

I bought a car...it didnt come with a life preserver
I bought a bouat...it didnt come with a spare tire.
I traveled on a train...there were no parachutes
...

VB (C#,C++,Pascal,Fortran,Algol,PL/1, etc) are all general purpose programming languages. It would NOT be appropriate for a full statistical package to be included.

Third parts libraries are available for all of the languages listed above.

The ONLY language I have worked with in the last 35 years that inherently included a full statistical package was APL.

APL is still available, and there APL.Net implementations also.

Remember a large part of the "true power" of .Net is the ability to mix high level languages into a single application.

So you want to use an Excel function, but not call Excel and you complain that it is Microsoft's fault/problem??......


I'd say you should take the advice of sotoasty and make a program .... or I don't know - use Excel.

Blaming Microsoft or Excel will not get you far ;)
You cannot use Excel capabilities without Referencing it. Sooner or later, you will need to set a reference to the appropriate Excel Library ( if you want to check if your app and Excel get to the same conclusion )

I suggest that you learn some math. Any statistical function that exists in Excel was not 'invented' by Microsoft (for the most part, anyways)

Talk to a mathematician, and have him give you a formula that you can use in another language.