Different software’s differ based on their graphical user interface and way you can fill the data or import your data. Microsoft Excel is most simple for basic statistical analysis. You have to activate the data analysis tool pack of Excel first if it is not activated. Other software like SPSS and Sigma Plot is also very handy. Plenty of web-based resources and videos are available for learning. If you are interested in more depth and advanced statistics you should learn R, it is hard for a beginner but once you learn it, you can do any statistics, graph and modelling.
Hi Archisman I may suggest you that from Different Soft wares you would present different presentations and Statistics such as:
1, MS Excel is more available and user friendly for Data Collection, Tables and Diagramatic Presentations.
2. SPSS is a Licensed software and need to install (Easily available) also need to Learn But extremely Professional for Data Collection, Statistics Tables and Professional Diagramatic Presentation.
3. SAS is also a Licensed Software (Rare Availability) but Professional to use in Statistics and Diagrams vastly used in USA and Canada.
4. MiniTAB Software vastly used in Quality Management Departments for Data collection, Statistics Tables and Diagrams.
5. R Software is for Advanced Statistics and Diagrammatic Presentations.
There are some more Statistical Soft wares but less used and I hope above comments would help you. Regards
Simple Analysis can be done in MS Excel or else MiniTab is a good choice.
Overall for price(free) and all of the analyses it will do(essentially everything) you can't beat R. It has a point and click GUI called Rcommander as an add on package for beginners. I am attaching an introductory book. Good luck, David Booth
Recent versions of the matlab include a powerful statistical analysis toolbox and app. You may try it. Its output results can be easily integrated with other modules within the matlab.
Hello,
Simple analysis can be done by using MS excel..and online software are also available...from where you can learn...
The best software to simple statistical analysis is SPSS because it is simple and accurate. But the most complete is R and Stata. Excel can be good option but has to trigger some add-ons like data analysis. But overall there is no better software than just software that fits better with a particular statistical technique or method.
Hi Archisman,
I wouldn't use Excel at all for this, which doesn't really have functions at all. R of course is the best software, but if your data set ain't too big and you want to use a software which is free and easy to use, in my mind nothing can beat Gretl.
Gretl is econometric software and you can easily build OLS or GLS models with it. Plots are done fast as well. Try it, you don't need any schooling for it really, you can basically "click" through the whole thing. Transformation of data (like logs or squares) can be done via click as well.
Best regards!
Hi Archisman
I would suggest to use SPSS from the very beginning instead of using Excel as it gives a clear and descriptive result along with tabulated values in a well defined way.For quick results you can opt for some online stats programs too.
R is great software, but essentially a programming language for maths and statistics. The learning curve is quite steep, but once you mastered it, you can do anything with it that a Turing machine can do. Many new statistical procedures nowadays are published as R-packages.
Excel is a general purpose spreadsheet, that can be used for some statistical procedures, but becomes limiting as your requirements increase. Plotting routines were developed for business, not science. There are commercial add-ons like XLStat (https://www.xlstat.com/), but these cost extra.
There are special programs for plotting and handling laboratory data, like Origin (https://www.originlab.com/) or SigmaPlot (https://systatsoftware.com/products/sigmaplot/). These are closed-source, expensive and not extensible, so you need to evaluate carefully whether they meet your (future) needs. What they do, they do very well, however. SciDaVis (https://sourceforge.net/projects/scidavis/) does similar things, but is open-source and still actively developed (latest version from 03/19).
SPSS is a statistics program that was written way back for the command line of mainframe computers, but now also has a WYSIWYG interface for PC. It is very powerful (especially if you can handle the command line), but expensive. You may need some of the numerous add-on packages for your analysis, which cost extra. There are also some debatable design decisions, like using PCA as default-method for FA, which send some statisticians into apoplectic fits. If you only need the basic functionality, PSPP (https://www.gnu.org/software/pspp/) is an open-source alternative, it too is actively developed (latest version 11/18).
If your needs center mainly on plotting, then gnuplot (https://sourceforge.net/projects/gnuplot/files/latest/download) may fit your bill. This, too, is command-line (or script-file) controlled and hence very flexible, but requires some learning effort. Being limited to plotting, it is easier to learn than, for example, R. IMHO its biggest disadvantage is that the commands change slightly from version to version, so a script that worked great yesterday may produce an error message tomorrow. It can be integrated with LaTeX for publication, this is the standard setup in maths and physics, less common (but very powerful) in biology.
- Badges
- Science topic