Find answers here for the following questions:
Excel 2003 Courses from Microsoft
What tools do I use to do data analysis on a data set?
How do you add the Analysis ToolPak?
Why can't I run solver due to a security violation relating to macros?
--------------------------------------------------------------------------------
Q: What tools do I use to do data analysis on a data set?
A:
Go to Tools => Data Analysis and choose the type of analysis you want to perform on your data set.
Enter the input range and the output range, and then select the options you want. Before using an analysis tool, you must arrange the data you want to analyze in columns or rows on your worksheet. This is your input range.
If the Data Analysis command is not on the Tools menu, you need to install the Analysis ToolPak in Microsoft Excel. (see next FAQ)
--------------------------------------------------------------------------------
Q: How do you add the Analysis ToolPak?
A:
Go to Tools => Add-ins
Select the Analysis ToolPak and Analysis ToolPak VBA check boxes. Click ok.
--------------------------------------------------------------------------------
Q: Why can't I run solver due to a security violation relating to macros?
A: You need to change your macro security settings.
Go to Tools => Macros => Security
Select the Medium option box. Click ok. (see image below)
