How to use excel in data analysis?

[Mitu]

Hello friends!
I want to know about data analysis through application of Excel. Please guide me if anybody knows about this.


Awaiting for your earliest reply.
Thanking you.

[NKOTB_VBA]

Try to use the Analysis Tool Pack Excel Add-In; not sure about Excel 2003 but it is there in Excel 2010. It has various data analysis options like Annova, Correlation, Covariance, Histogram, F-test, etc. and are ease to use.