Monday, January 5, 2009

Statistical analysis in Excel

Yesterday soma shekhar logged into my website familycomputerclub.com and posed the question: How can I perform a stastical analysis in Excel?
Microsoft Excel provides a set of data analysis tools called the Analysis ToolPak. To access these tools, click Data Analysis on the Tools menu.






If the Data Analysis command is not available, you need to load the Analysis ToolPak add-in by doing the following.
On the Tools menu, click Add-Ins.

In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.


If necessary, follow the instructions in the setup program.
In the Data Analysis dialog box, click the name of the analysis tool you want to use, then click OK.
In the dialog box for the tool you selected, set the analysis options you want.
You can use the Help button on the dialog box to get more information about the options.
Another related question:
Where can I find the menu commands in Excel 2007
You can find the answers here:http://www.rondebruin.nl/0307commands.htm
Cheers!

0 comments: