Microsoft Office Tutorials and References
In Depth Information
28. Click Cancel .
The Solver Results dialog box closes.
CLEAN UP Save the AdBuy workbook, and then close it.
Analyzing Data by Using Descriptive Statistics
Experienced business people can tell a lot about numbers just by looking at them to see
if they “look right.” That is, the sales figures are about where they’re supposed to be for a
particular hour, day, or month; the average seems about right; and sales have increased
from year to year. When you need more than an informal assessment, however, you can
use the tools in the Analysis ToolPak.
If you don’t see the Data Analysis item in the Analysis group on the Data tab, you can
install it. To do so, click the File tab, and then click Options. In the Excel Options dialog
box, click Add-Ins to display the Add-Ins page. At the bottom of the dialog box, in the
Manage list, click Excel Add-Ins, and then click Go to display the Add-Ins dialog box.
Select the Analysis ToolPak check box and click OK.
Tip You might be prompted for the Microsoft Office system installation CD. If so, put the CD
in your CD drive, and click OK.