Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
9. Analyzing Alternative Data Sets
|
In this chapter, you will learn to: | |
|
? |
Define and edit alternative data sets. |
|
? |
Define multiple alternative data sets. |
|
? |
Vary your data to get a desired result using Goal Seek. |
|
? |
Find optimal solutions with Solver. |
|
? |
Analyze data with descriptive statistics. |
When you store data in a Microsoft® Office Excel® 2007 workbook, you can use that data, either by itself or as part of a calculation, to discover important information about your business. When you track total sales on a time basis, you can find your best and worst sales periods and correlate them with outside events. For businesses such as Consolidated Messenger, package volume increases dramatically during the holidays as customers ship gifts to friends and family members.
