Free Trial

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
  • PrintPrint
Share this Page URL

Chapter 6. Problem Solving with Multiple... > 6.2 Comparing Multiple Columns

6.2 Comparing Multiple Columns

What remains to be answered is whether there are important multiple-column relationships (looking at more than two columns) that might be present in the data. Complex products or systems often have these relationships. While these multiple-column relationships are not always present in the questions you are trying to answer, knowing that you have access to methods to identify them should help. In fact, sometimes to see the forest for the trees, you need these methods so that you can focus on only those columns that drive your learning from the data.

Example 6.2. Financial

We will be using the data file to illustrate the steps in this chapter. The data is from companies in the Fortune 500, selected from the April 23, 1990 Fortune magazine issue. This data includes columns for:

Type: type of company

Sales($M): yearly sales in millions of dollars

Profit($M): yearly profits in millions of dollars

#emp: number of employees at time of measurement

Profits/emp: profits per employee in thousands of dollars

Assets($Mil.): assets in millions of dollars

Sales/emp: sales per employee in thousands of dollars

Stockholder's Eq($Mil.): stockholder's equity in millions of dollars

You can access this data at Help > Sample Data > Business & Demographic > Financial.


You are currently reading a PREVIEW of this book.


Get instant access to over $1 million worth of books and videos.


Start a Free 10-Day Trial

  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint