Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Statistical Analysis Tools

Statistical Analysis Tools

Scheduled Pinned Locked Moved The Lounge
pythonoracletoolsquestionlearning
40 Posts 18 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • B Bassam Abdul Baki

    Well you had six other threads to read first before you came to mine. :D

    Web - BM - RSS - Math - LinkedIn

    P Offline
    P Offline
    Paulo Augusto Kunzel
    wrote on last edited by
    #15

    :-D I'm trying to keep the conversation going and to vote up on the stuff that is adding more knowledge.

    There are no secrets to success. It is the result of preparation, hard work, and learning from failure. Colin Powell

    1 Reply Last reply
    0
    • J Jorgen Andersson

      SAS and SPSS are tools, R is a programming language (of sorts), so it's mostly up to what you want to achieve. Keep in mind that R isn't intended to be anything but a specialized language that never will be mainstream. Also note that I have no personal experience with R, I've only read up on it a bit to see if we have any use for it.

      Wrong is evil and must be defeated. - Jeff Ello[^]

      P Offline
      P Offline
      Pualee
      wrote on last edited by
      #16

      I worked extensively in SAS... it was dreadful. If you care to know why, I can elaborate. I won't go back to it.

      J 1 Reply Last reply
      0
      • P Pualee

        I worked extensively in SAS... it was dreadful. If you care to know why, I can elaborate. I won't go back to it.

        J Offline
        J Offline
        Jorgen Andersson
        wrote on last edited by
        #17

        We're having a couple of people here that uses SPSS. They're not happy about it. It suffers badly from featuritis while lacking usability and stability. So yes, I'm interested in hearing your opinion on SAS.

        Wrong is evil and must be defeated. - Jeff Ello[^]

        P 1 Reply Last reply
        0
        • P Paulo Augusto Kunzel

          Hi, Just wondering, does anyone know which are the most used tools for statistical analysis? I know about R and Python(with pandas), but there has got to be more than that... I would imagine that oracle or microsoft would have something, but so far I haven't found anything. To those who work with such tools, what do you use at your company? Regards

          There are no secrets to success. It is the result of preparation, hard work, and learning from failure. Colin Powell

          M Offline
          M Offline
          Member 10088171
          wrote on last edited by
          #18

          R is scripting language but mostly it is open source library of statistical tests with charting capabilities.It is easy to learn and use. Few lines of "code" (mostly calling library functions) will produce desired answer from simple descriptive stats to complex machine learning tests, signal processing etc. There are more than 4000 packages developed by individuals or universities with documentation. R is easiest to start. Python is slightly more complex and has extensive libraries as well. As with all statistics what really counts is to know which test applies to given problem and what to do with the test results. Both R and Python have lots of free information on the web and extensive literature in bookstores (Amazon).

          P 1 Reply Last reply
          0
          • M Member 10088171

            R is scripting language but mostly it is open source library of statistical tests with charting capabilities.It is easy to learn and use. Few lines of "code" (mostly calling library functions) will produce desired answer from simple descriptive stats to complex machine learning tests, signal processing etc. There are more than 4000 packages developed by individuals or universities with documentation. R is easiest to start. Python is slightly more complex and has extensive libraries as well. As with all statistics what really counts is to know which test applies to given problem and what to do with the test results. Both R and Python have lots of free information on the web and extensive literature in bookstores (Amazon).

            P Offline
            P Offline
            Paulo Augusto Kunzel
            wrote on last edited by
            #19

            :cool:Cool, it is interesting to see someone talking about R as being the easier one to start with any studies. I might have to look more into R to check that... I agree with the knowlwdge thing, I'm already enrolled for a statistics course to see if I can get a better grasp on how/why to do the test. Thanks!

            There are no secrets to success. It is the result of preparation, hard work, and learning from failure. Colin Powell

            1 Reply Last reply
            0
            • J Jorgen Andersson

              We're having a couple of people here that uses SPSS. They're not happy about it. It suffers badly from featuritis while lacking usability and stability. So yes, I'm interested in hearing your opinion on SAS.

              Wrong is evil and must be defeated. - Jeff Ello[^]

              P Offline
              P Offline
              Pualee
              wrote on last edited by
              #20

              I used it about 3 years ago... I worked with it for a about five years up to that point (versions 8 through 9.1). 1. Licensing was always an issue. They were stuck on some old mainframe idea of charging per processing core. If you tried to run it on a modern Linux or Windows box it became unaffordable without a long negotiations fight. 2. It requires a mind shift to realign with their programming practices. All the SQL you might know and love is backwards in the world of SAS, which processes everything more like a cursor. So while that is not necessarily bad, it is uncomfortable until you understand it. 3. The interpreted sas language, which was powerful and useful for its original design (creating massive reports) was terrible if you had a real-time transactional piece inputting or updating to the database. Everything runs best in batch. You will require a 2nd system for transactional input, and require a daily synchronization process at night. 4. The interpreted sas language itself was inconsistently implemented. The syntax around keywords and operators, even for simple things, could be different from one feature to the next, so you were always having to look up documentation (even after 5 years). 5. The compiled SCL language (which I think they were dropping support) had compiler issues. Even adding or removing white space could cause random errors (basically the grammar had bugs and was unreliable). You could spend days tracking down compiler problems in and around SCL. 6. Things that should be easy in other languages are difficult or expensive (additional feature, new license) in sas. 7. Documentation was regularly missing, and unlike more popular languages, I couldn't find what I needed on the web. Maybe that has changed with some of the newer social Q/A sites. I have a lot more opinions, but those might be related to where I worked, and not the product itself. Edit: I had a very bad job at the time (on call every other week, multiple calls per night, etc, etc). A bank called and offered a job where I would convert SAS into .NET... I refused because I was not taking another job dealing with SAS X| It was really that bad.

              J 1 Reply Last reply
              0
              • P Paulo Augusto Kunzel

                Hi, Just wondering, does anyone know which are the most used tools for statistical analysis? I know about R and Python(with pandas), but there has got to be more than that... I would imagine that oracle or microsoft would have something, but so far I haven't found anything. To those who work with such tools, what do you use at your company? Regards

                There are no secrets to success. It is the result of preparation, hard work, and learning from failure. Colin Powell

                B Offline
                B Offline
                BobJanova
                wrote on last edited by
                #21

                R doesn't do any stats stuff but there are well tested standard packages (libraries) that do. I've used some R in my job and it's fairly easy to work with, and for any vaguely standard stats the packages will just do it for you.

                1 Reply Last reply
                0
                • P Pualee

                  I used it about 3 years ago... I worked with it for a about five years up to that point (versions 8 through 9.1). 1. Licensing was always an issue. They were stuck on some old mainframe idea of charging per processing core. If you tried to run it on a modern Linux or Windows box it became unaffordable without a long negotiations fight. 2. It requires a mind shift to realign with their programming practices. All the SQL you might know and love is backwards in the world of SAS, which processes everything more like a cursor. So while that is not necessarily bad, it is uncomfortable until you understand it. 3. The interpreted sas language, which was powerful and useful for its original design (creating massive reports) was terrible if you had a real-time transactional piece inputting or updating to the database. Everything runs best in batch. You will require a 2nd system for transactional input, and require a daily synchronization process at night. 4. The interpreted sas language itself was inconsistently implemented. The syntax around keywords and operators, even for simple things, could be different from one feature to the next, so you were always having to look up documentation (even after 5 years). 5. The compiled SCL language (which I think they were dropping support) had compiler issues. Even adding or removing white space could cause random errors (basically the grammar had bugs and was unreliable). You could spend days tracking down compiler problems in and around SCL. 6. Things that should be easy in other languages are difficult or expensive (additional feature, new license) in sas. 7. Documentation was regularly missing, and unlike more popular languages, I couldn't find what I needed on the web. Maybe that has changed with some of the newer social Q/A sites. I have a lot more opinions, but those might be related to where I worked, and not the product itself. Edit: I had a very bad job at the time (on call every other week, multiple calls per night, etc, etc). A bank called and offered a job where I would convert SAS into .NET... I refused because I was not taking another job dealing with SAS X| It was really that bad.

                  J Offline
                  J Offline
                  Jorgen Andersson
                  wrote on last edited by
                  #22

                  Have some sympathy and an upvote for the info. We were quite recently recommended by a professor in statistics to "upgrade" to SAS, I'll think we'll pass.

                  Wrong is evil and must be defeated. - Jeff Ello[^]

                  1 Reply Last reply
                  0
                  • P Paulo Augusto Kunzel

                    Open source.... Probably one of the best ways to learn about something!! Thanks Any recommendations on what else to learn to better work with statistical analysis?

                    There are no secrets to success. It is the result of preparation, hard work, and learning from failure. Colin Powell

                    J Offline
                    J Offline
                    Jorgen Andersson
                    wrote on last edited by
                    #23

                    I told an analyst at our company about PSPP, and her comment was that it's lacking functionality compared to SPSS for our needs. Thereby not said it's not enough for you.

                    Wrong is evil and must be defeated. - Jeff Ello[^]

                    1 Reply Last reply
                    0
                    • P Paulo Augusto Kunzel

                      Hi, Just wondering, does anyone know which are the most used tools for statistical analysis? I know about R and Python(with pandas), but there has got to be more than that... I would imagine that oracle or microsoft would have something, but so far I haven't found anything. To those who work with such tools, what do you use at your company? Regards

                      There are no secrets to success. It is the result of preparation, hard work, and learning from failure. Colin Powell

                      J Offline
                      J Offline
                      Jorgen Andersson
                      wrote on last edited by
                      #24

                      Oh, I forgot to mention Stata[^]. It feels outdated but is quite capable.

                      Wrong is evil and must be defeated. - Jeff Ello[^]

                      1 Reply Last reply
                      0
                      • E Ennis Ray Lynch Jr

                        Statisticians use R, claim it's complete, then hand it to me to "code" into a system. Except ... R is documented, specifically, to not be able to be run programmatically. My R based systems are the buggiest I have. Oh, and just imagine trying to install all of the required libraries through a firewall! One at a time! UGH. Just tell me the functions and I can write them, sheesh. BTW, on topic, the Closest thing I use is Aforge.NET.

                        Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost "All users always want Excel" --Ennis Lynch

                        M Offline
                        M Offline
                        Member 10088171
                        wrote on last edited by
                        #25

                        Would Rcpp or RInside help in this situation?

                        1 Reply Last reply
                        0
                        • P Paulo Augusto Kunzel

                          Hi, Just wondering, does anyone know which are the most used tools for statistical analysis? I know about R and Python(with pandas), but there has got to be more than that... I would imagine that oracle or microsoft would have something, but so far I haven't found anything. To those who work with such tools, what do you use at your company? Regards

                          There are no secrets to success. It is the result of preparation, hard work, and learning from failure. Colin Powell

                          Sander RosselS Offline
                          Sander RosselS Offline
                          Sander Rossel
                          wrote on last edited by
                          #26

                          Some people already mentioned it, but I will mention it again, SPSS. I've used it at my University. I still get nightmares from it, but that's probably because I'm allergic to math :)

                          It's an OO world.

                          public class SanderRossel : Lazy<Person>
                          {
                          public void DoWork()
                          {
                          throw new NotSupportedException();
                          }
                          }

                          1 Reply Last reply
                          0
                          • P Paulo Augusto Kunzel

                            Hi, Just wondering, does anyone know which are the most used tools for statistical analysis? I know about R and Python(with pandas), but there has got to be more than that... I would imagine that oracle or microsoft would have something, but so far I haven't found anything. To those who work with such tools, what do you use at your company? Regards

                            There are no secrets to success. It is the result of preparation, hard work, and learning from failure. Colin Powell

                            S Offline
                            S Offline
                            stuxstu
                            wrote on last edited by
                            #27

                            Minitab. It is one of the most common statistical analysis softwares. It is used heavily in engineering and six sigma. It is also a very common statistics software in colleges.

                            1 Reply Last reply
                            0
                            • P Paulo Augusto Kunzel

                              Hi, Just wondering, does anyone know which are the most used tools for statistical analysis? I know about R and Python(with pandas), but there has got to be more than that... I would imagine that oracle or microsoft would have something, but so far I haven't found anything. To those who work with such tools, what do you use at your company? Regards

                              There are no secrets to success. It is the result of preparation, hard work, and learning from failure. Colin Powell

                              R Offline
                              R Offline
                              rnbergren
                              wrote on last edited by
                              #28

                              I feel like adding my .02 Worked at insurance company for years in SAS. It wasn't horrible as some propose but it does have some serious limitations. The company mainly needed a reporting tool. Should have used something else. SSRS maybe? Worked at a college for many many years. SPSS, SAS and some stupid reporting tool called WebFocus (Biggest piece of garbage I have ever, ever had to deal with) We ended up writing our own modules in C for most of what we needed. Worked at Commodities trading for a few years, WebFocus for reporting (Did I say biggest POS ever!) Used parts of Mathematica or parts of F# for some serious math in there. It just worked. I know this wasn't about reporting buttttt... anyhoo SAS not horrible, SPSS barely works, Mathematica works. Thanks

                              To err is human to really mess up you need a computer

                              P 1 Reply Last reply
                              0
                              • P Paulo Augusto Kunzel

                                Hi, Just wondering, does anyone know which are the most used tools for statistical analysis? I know about R and Python(with pandas), but there has got to be more than that... I would imagine that oracle or microsoft would have something, but so far I haven't found anything. To those who work with such tools, what do you use at your company? Regards

                                There are no secrets to success. It is the result of preparation, hard work, and learning from failure. Colin Powell

                                C Offline
                                C Offline
                                Christopher Lloyd
                                wrote on last edited by
                                #29

                                What are you trying to do? If you just want to run some analysis on some data you already have, then SPSS is probably your best bet, although it is expensive (if you're at college then there's a good chance they'll have a license). If you want to include some stats tests in something you're writing then it really depends on what tests you need to include.

                                P 1 Reply Last reply
                                0
                                • P Paulo Augusto Kunzel

                                  Hi, Just wondering, does anyone know which are the most used tools for statistical analysis? I know about R and Python(with pandas), but there has got to be more than that... I would imagine that oracle or microsoft would have something, but so far I haven't found anything. To those who work with such tools, what do you use at your company? Regards

                                  There are no secrets to success. It is the result of preparation, hard work, and learning from failure. Colin Powell

                                  D Offline
                                  D Offline
                                  dpminusa
                                  wrote on last edited by
                                  #30

                                  http://sourceforge.net/projects/pspp4windows/[^] Here is an open source SPSS clone that is very powerful. You may want to evaluate it. There are multiple environments.

                                  "Courtesy is the product of a mature, disciplined mind ... ridicule is lack of the same - DPM"

                                  P 1 Reply Last reply
                                  0
                                  • D dpminusa

                                    http://sourceforge.net/projects/pspp4windows/[^] Here is an open source SPSS clone that is very powerful. You may want to evaluate it. There are multiple environments.

                                    "Courtesy is the product of a mature, disciplined mind ... ridicule is lack of the same - DPM"

                                    P Offline
                                    P Offline
                                    Paulo Augusto Kunzel
                                    wrote on last edited by
                                    #31

                                    Hi, Thx for the reply. One of the guys has already mentioned it. It truly looks quite good. :thumbsup: Regards

                                    There are no secrets to success. It is the result of preparation, hard work, and learning from failure. Colin Powell

                                    1 Reply Last reply
                                    0
                                    • C Christopher Lloyd

                                      What are you trying to do? If you just want to run some analysis on some data you already have, then SPSS is probably your best bet, although it is expensive (if you're at college then there's a good chance they'll have a license). If you want to include some stats tests in something you're writing then it really depends on what tests you need to include.

                                      P Offline
                                      P Offline
                                      Paulo Augusto Kunzel
                                      wrote on last edited by
                                      #32

                                      Hi Christopher, I'm actually trying gather as many ideas and points of view as possible. This is a field that interest me and I would like to study the subject, maybe even run some experiments. who know... ;P I thought that I would have to do something from scratch, but it appears that there are quite a few tools ready to be used. Unfortunately my university doesn't have any "agreement" to provide licenses for SPSS Regards

                                      There are no secrets to success. It is the result of preparation, hard work, and learning from failure. Colin Powell

                                      C 1 Reply Last reply
                                      0
                                      • R rnbergren

                                        I feel like adding my .02 Worked at insurance company for years in SAS. It wasn't horrible as some propose but it does have some serious limitations. The company mainly needed a reporting tool. Should have used something else. SSRS maybe? Worked at a college for many many years. SPSS, SAS and some stupid reporting tool called WebFocus (Biggest piece of garbage I have ever, ever had to deal with) We ended up writing our own modules in C for most of what we needed. Worked at Commodities trading for a few years, WebFocus for reporting (Did I say biggest POS ever!) Used parts of Mathematica or parts of F# for some serious math in there. It just worked. I know this wasn't about reporting buttttt... anyhoo SAS not horrible, SPSS barely works, Mathematica works. Thanks

                                        To err is human to really mess up you need a computer

                                        P Offline
                                        P Offline
                                        Paulo Augusto Kunzel
                                        wrote on last edited by
                                        #33

                                        Cool, It's nice to know you have a big array of software knowledge in your belt. No worries, in most cases it will end up on reports... lol... How did F# performed? Was it easy to learn? And how was Mathematica? regards

                                        There are no secrets to success. It is the result of preparation, hard work, and learning from failure. Colin Powell

                                        1 Reply Last reply
                                        0
                                        • P Paulo Augusto Kunzel

                                          Hi Christopher, I'm actually trying gather as many ideas and points of view as possible. This is a field that interest me and I would like to study the subject, maybe even run some experiments. who know... ;P I thought that I would have to do something from scratch, but it appears that there are quite a few tools ready to be used. Unfortunately my university doesn't have any "agreement" to provide licenses for SPSS Regards

                                          There are no secrets to success. It is the result of preparation, hard work, and learning from failure. Colin Powell

                                          C Offline
                                          C Offline
                                          Christopher Lloyd
                                          wrote on last edited by
                                          #34

                                          I wasn't so much thinking that your university would have an agreement to provide you with a license for SPSS, but more that someone would have a copy you could use - but that would only really have been useful if you had a specific data set you wanted to analyse. A program that's widely used in biological sciences is Prism Graphpad. I've not used it myself, but my understanding is that it's quite straightforward (in contrast to SPSS, for example, which has a pretty step learning curve) and Prism provide a fully functioning 30 demo that you can download for free. Once you've familiarised yourself with some of the tests then the best way to really learn about them would be to code them yourself!

                                          P 1 Reply Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups