Microsoft Office Tutorials and References
In Depth Information
Chapter 2
Presentation of Quantitative Data
Contents
2.1 Introduction ................................. 19
2.2 Data Classiﬁcation .............................. 20
2.3 Data Context and Data Orientation ...................... 21
2.3.1 Data Preparation Advice ........................ 24
2.4 Types of Charts and Graphs .......................... 26
2.4.1 Ribbons and the Excel Menu System ................... 27
2.4.2 Some Frequently Used Charts ...................... 29
2.4.3 Speciﬁc Steps for Creating a Chart .................... 33
2.5 An Example of Graphical Data Analysis and Presentation ............ 36
2.5.1 Example—Tere’s Budget for the 2nd Semester of College ......... 38
2.5.2 Collecting Data ............................ 40
2.5.3 Summarizing Data ........................... 40
2.5.4 Analyzing Data ............................ 42
2.5.5 Presenting Data ............................ 48
2.6 Some Final Practical Graphical Presentation Advice ............... 49
2.7 Summary .................................. 51
Key Terms .................................... 51
Problems and Exercises .............................. 52
2.1 Introduction
We often think of data as being strictly numerical values, and in business, those
values are often stated in terms of dollars. Although data in the form of dollars are
ubiquitous, it is quite easy to imagine other numerical units: percentages, counts
in categories, units of sales, etc. This chapter, and Chap. 3, discusses how we can
best use Excel’s graphics capabilities to effectively present quantitative data ( ratio
H. Guerrero, Excel Data Analysis , DOI 10.1007/978-3-642-10835-8_2,
C
19
Springer-Verlag Berlin Heidelberg 2010
Search JabSto ::

Custom Search