Microsoft Office Tutorials and References
In Depth Information
Chapter 4
Presentation of Qualitative Data
Contents
4.1 Introduction—What is Qualitative Data? .................... 99
4.2 Essentials of Effective Qualitative Data Presentation ............... 100
4.2.1 Planning for Data Presentation and Preparation .............. 100
4.3 Data Entry and Manipulation ......................... 103
4.3.1 Tools for Data Entry and Accuracy ................... 103
4.3.2 Data Transposition to Fit Excel ..................... 106
4.3.3 Data Conversion with the Logical IF ................... 109
4.3.4 Data Conversion of Text from Non-Excel Sources ............. 112
4.4 Data queries with Sort, Filter, and Advanced Filter ............... 116
4.4.1 Sorting Data .............................. 116
4.4.2 Filtering Data ............................. 118
4.4.3 Filter ................................. 118
4.4.4 Advanced Filter ............................ 123
4.5 An Example ................................. 129
4.6 Summary .................................. 133
Key Terms .................................... 135
Problems and Exercises .............................. 136
4.1 Introduction—What is Qualitative Data?
In Chaps. 2 and 3 we concentrated on approaches for collecting, presenting, and
analyzing quantitative data. Here, and in Chap. 5, we turn our attention to qualitative
data. Quantitative data is simple to identify; for example, sales revenue in dollars,
number of new customers purchasing a product, and units of a SKU (Stock Keeping
Unit) sold in a quarter. Similarly, qualitative data is easily identifiable. It can be
in the form of such variables as date of birth, country of origin, and revenue status
among a sales force (1st, 2nd, etc.).
H. Guerrero, Excel Data Analysis , DOI 10.1007/978-3-642-10835-8_4,
C
99
Springer-Verlag Berlin Heidelberg 2010
Search JabSto ::




Custom Search