Microsoft Office Tutorials and References
In Depth Information
Exhibit 4.29 Filter of projects X and Y for question 5
Once we have constructed our database, we are ready to begin soft or non-
mathematical analysis of the data, in the form of sorts, filtering, and queries. I like
to think of this type of analysis as isolation, summarization, and cross-tabulation
(more on this topic in Chap. 5) of the records in our database. Summarization can
be as simple as finding totals for categories of variables, while isolation focuses on
locating a specific record, or records, in the database. Cross-tabulation allows the
database user to explore more complex relationships and questions. For example,
we may want to investigate if a particular sales associate demonstrates a propen-
sity to sell a particular brand of automobile. Although Excel is not designed to
be a full service database program, it contains many important tools and functions
that will allow relatively sophisticated database analysis on a small scale. More on
Cross-tabulation in later in chapters.
Chapter 4 also introduced a number of powerful cell functions that aided our
database analysis, although these functions have utility far beyond the analysis of
qualitative data. Among them were Subtotal , Transpose , and the logical IF , AND ,
Search JabSto ::

Custom Search