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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.