Chapter 9. Analyzing Alternative Data Sets

Chapter at a Glance

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 ...

Get Microsoft® Office Excel® 2007 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.