CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2007
    Location
    Argentina
    Posts
    579

    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!.

    So, I are ranting here:

    ... and whining here:

    _

  2. #2
    Join Date
    Sep 2000
    Location
    FL
    Posts
    1,452

    Re: Ranting at Microsoft ¡No statistics!

    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.

  3. #3
    Join Date
    Mar 2007
    Location
    Argentina
    Posts
    579

    Re: Ranting at Microsoft ¡No statistics!

    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.

    Thanks Billy Gates. You are so nice.

  4. #4
    Join Date
    Mar 2002
    Location
    St. Petersburg, Florida, USA
    Posts
    12,125

    Re: Ranting at Microsoft ¡No statistics!

    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.
    TheCPUWizard is a registered trademark, all rights reserved. (If this post was helpful, please RATE it!)
    2008, 2009,2010
    In theory, there is no difference between theory and practice; in practice there is.

    * Join the fight, refuse to respond to posts that contain code outside of [code] ... [/code] tags. See here for instructions
    * How NOT to post a question here
    * Of course you read this carefully before you posted
    * Need homework help? Read this first

  5. #5
    Join Date
    Feb 2005
    Location
    Denmark
    Posts
    742

    Re: Ranting at Microsoft ¡No statistics!

    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.

  6. #6
    Join Date
    Jul 2001
    Location
    Sunny South Africa
    Posts
    11,284

    Re: Ranting at Microsoft ¡No statistics!

    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 )

  7. #7
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: Excel Statistics

    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.
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured