iSixSigma

Statistical Packages

Six Sigma – iSixSigma Forums Old Forums General Statistical Packages

Viewing 15 posts - 1 through 15 (of 15 total)
  • Author
    Posts
  • #43877

    boettler
    Member

    All,
    I have been tasked with buying statisitical software.  I have reviewed JMP and Minitab, but they are out of the companies price range.   Can anyone point me to some Excel based statistical package or other alternative.
    Rob
     

    0
    #139792

    Ken Feldman
    Participant

    This is a nice package…..I have no relationship with this company but have used the product before.
    http://www.sigmazone.com/spcxl_features.htm

    0
    #139794

    Fisher Man
    Participant

    I do know Darth is a HUGE fan of JMP.   :D   Not to mention home- grown spreadsheets….

    0
    #139795

    Whitehurst
    Participant

    I have used SPC XL and found it to be a great package.

    0
    #139796

    Fisher Man
    Participant

    On a serious note, depending on the level of analysis you need, there are some pretty amazing things you can do with Microsoft Excel.   Controls charts, etc. can be created with a bit of work, and there are examples around with which to start.

    0
    #139798

    Savage
    Participant

    Sigma XL is nice too.  Version 5 was just released.
    You can download most and take them for a spin.

    0
    #139799

    boettler
    Member

    Thanks for the info.  I will try the demo version.   

    0
    #139808

    Heebeegeebee BB
    Participant

    Minitab is worth the investment.   My last company was similarly nearsighted as yours appears to be.   I bought it with my own funds and wrote it off.

    0
    #139809

    danny
    Participant

    I would try SPC for MS Excel – does most of what you need.

    0
    #140108

    Philip
    Participant

    It depends on what you want to do:
    I have Minitab for file compatibility with customers, but would avoid using it in house, as it has some bad default settings which lead to very wrong results unless you know enough to correct things (especially control charts, capability, and Measurement Systems Analysis). If you want to use Minitab, then I would always check the results using another stats package, or by hand analysis. Minitab also has some limitations in the tools implimented (at least as far as I can tell).
    For simple analysis (such as control charts) I use Excel, but I would not use this for statistically intensive applications (e.g. random number generation, anything involving sums of squares – including stdev(), var(), ANOVA and linear regression, as the algorithms in Excel (even Excel 2003) are incorrect – there are various article on this on the internet.
    For a statistically accurate spreadsheet, I use the open source (free!) package “Gnumeric”. (http://www.gnome.org/projects/gnumeric/)  The statistical routines in this have been validated by the R-project team (see below) and are more comprehensive than Excel.
    For a powerful stats package capable of doing anything you might want, try R (http://www.r-project.org) This is also open source and free, and is an implimentation of the S language better known from Insightful’s commercial package S-plus. The only downside to R is the steep learning curve but I found that the book by John Verzani (“Using R for Introductory Statistics”) covers most of the basic stuff. Anyway, R is free so if you don’t like it you haven’t lost anything.
    Hope this helps
    Philip

    0
    #140110

    facius
    Participant

    I found your comments on Minitab both very interesting and disturbing.
    Can you share your list of shortcomings or point me at a place where i can find them. I am using Minitab a lot and would like to know which are the areas in which i should be cautious.
    Thanks

    0
    #140113

    Jered Horn
    Participant

    Hey facius…
    I’ve found that having money in your wallet and bank account can cause MAJOR problems in your life.
    If you believe THAT too, let me know.  I may be able to help you.
    Good luck!

    0
    #140127

    Tierradentro
    Participant

    My friend,
    Go learn from the Shainin Institute.  They’ll teach you how to solve problems and improve quality dramatically without a statistical package.  If you find you need one anyway, they have approved only 1 package that fits the techniques they teach.  Their web is:
    http://www.shainin.com/
    Last, all data collection can be done on Excel or Access data base.  I have used Jump and Minitab … too complicated and always do not give correct answers.  They’re just a cop-out for QEs who can’t perform experiments and verifying magnitude and signficance by hand.  Shainin methods will show you how … simply and effectively.  If I can do it anyone can.
    Good Luck.

    0
    #140240

    Crystal
    Participant

    Rob,
    There is statistical software that you can add to your existing version of Excel that has worked for me in the past when Minitab and JMP were out of the question. It is called QI Macros (http://www.qimacros.com) and is available for a free 30 day trial. The licenses are very affordable compared to Minitab.
    Hope this helps,
    – Crystal

    0
    #140242

    reg
    Participant

    Crystal,
    I looked into the QIMacros program.  I did not like the performance of the tool and had limited functionality.
     
    Rob

    0
Viewing 15 posts - 1 through 15 (of 15 total)

The forum ‘General’ is closed to new topics and replies.