Microsoft Office Tutorials and References
In Depth Information
Exhibit 5.4 Out of range and non-integer data error check
remainder. If that remainder is not 0, then the condition is TRUE (there is a remain-
der) and the text message OUT is returned. If the condition is FALSE (no remainder),
then the next condition, B4>6, is examined. If the condition is found to be TRUE ,
then OUT is returned, and so on. Note that the MOD function simply becomes one
of the three arguments for the OR . Thus, we have constructed a relatively complex
IF function for error checking.
Exhibit 5.4 shows the results of both tests. As you can see, this is a convenient
way to determine if a non-integer value is in our data, and the values 0 in B2, 5.6
in C2, and 7 in C3 are identified as either out of range or non-integer. The value
0, satisfies both conditions, but is only detected by the out of range condition. This
application shows the versatility of the IF function, as well as other related logical
functions, such as OR , AND , NOT , TRUE , and FALSE . Any logical test that can be
conceived can be handled by some combination of these logical functions.
Once we have verified the accuracy of our data, we are ready to perform several
types of descriptive analyses. This includes cross - tabulation analysis, through the
use of Excel’s PivotChart and PivotTable tools. PivotChart s and PivotTable sare
frequently used tools for analyzing qualitative data—e.g. data contained in customer
surveys, operations reports, opinion polls, etc. They are also used as exploratory
techniques to guide us to more sophisticated types of analyses.
5.3 PivotChart or PivotTable Reports
Cross-tabulation provides a methodology for observing the interaction of several
variables in a set of data. For example, consider an opinion survey that records
Search JabSto ::




Custom Search