I’ve been two years using Microsoft excel to complete almost all my office tasks. It’s nice to know how to use statistics analysis tools in this software, instead of using particular statical analysis software. In fact, table-related tasks mostly need calculation, either simple or complex.
If you have to deal with complex task calculations, you may need this simple guideline. There are two facilities to make statistic analysis in Microsoft excel 2007. The first one is Data Analysis which is an additional instruction. How to set up this instruction?
• Find Excel options in Office button (see a big circle button in the left upper bar?)
• Choose Adds In tab
• Tick Analysis toolpak and Analysis Toolpak VBA
• OK
The software will allocate a new group in Data tab. It appears in the right side after Outline group. What can we do with Data analysis? This tool provides a range of statistics analysis such: Anova (both single and two factors, correlation, covariance, regression, sampling, moving average etc)
![Reblog this post [with Zemanta]](http://img.zemanta.com/reblog_e.png?x-id=63b86754-2e4e-405d-80c8-68c49b1998a5)
- statistical tools excel 2007, how to install add in smart regression in excel 2007, smart regression for excel 2007, statistical tools for excel 2007, tools in microsoft excel
THANK YOU very much…. you saved my sanity and may have helped me pass statistics class
wow good tools, but i don’t understand about this