Data analysis tool like MS excel


Data analysis tool like MS excel



I have a large number of data that needs to be compared, We are using Microsoft EXCEL, it costs, and it is slow, besides the graph that it generates is also not up to the mark. Now, is their any other tool, that is free, and has good graph's facility.

Thank you.




How do I copy a range into a temp workbook and return a reference to it with a vba function?

1:



Select a Node in a TreeView with VBA
If you need good data analysis toolkit, you can spend some time and try R --- free software statistics/data analysis toolkit.


How do I copy a range in vba?
It has pretty good graphic capabilities, especially via ggplot2 package for static graphics and ggobi for dynamic data exploration..
Why is this file always saved as FALSE.xls?
Data import/export pretty easy too --- R can import csv/tsv, or Excel data via ODBC and so on..
HTML type drop down in excel
It takes some time to learn, but after that you are not limited with tool capabilities: R can handle plenty of analysis tasks: from simple data crunching, pivoting.


Starting and controlling two instances of excel within my program?
aggregation tasks to advanced statistics/machine learning methods: clustering/classification/ regression etc..
Lotus 123 to Excel 2003 conversion
If you more more interested in data transformation with simple calculations, you can use some kind of Extract-Transform-Load toolkit, such as Talend Open Studio..
Reporting Services Excel rendering extensions?


2:


If you already have MS Office Suite, you probably have MS Access already installed.

It does a better job of processing heaps of data, and is a bit more versatile in graphing/charting/displaying data.

There may be a bit of a learning curve if you've never used it before.. As for free: I like working with Resolver One, which is free-ish under certain circumstances.

At very least its charts are marginally nicer to look at than Excel 2003.. It's going to be difficult to find a free, fast, powerful alternative that generates classy charts though, unless you're willing to code something yourself in, say a web interface..



70 out of 100 based on 50 user ratings 400 reviews