Chapter 8. Analyzing Alternative Data Sets

Analyzing Alternative Data Sets

Chapter 8 at a Glance

In this chapter you will learn to:

✓ Define and edit an alternative data set.

✓ Define multiple alternative data sets.

✓ Vary your data to get a desired result.

✓ Use the Solver to find solutions to multivariate problems.

✓ Describe your data using the Analysis ToolPak.

When you store data in a Microsoft Excel 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 like ...

Get Microsoft® Office Excel® 2003 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.