Microsoft Office Tutorials and References
In Depth Information
Chapter 3
Analysis of Quantitative Data
Contents
3.1 Introduction ................................. 55
3.2 What is Data Analysis? ............................ 56
3.3 Data Analysis Tools ............................. 57
3.4 Data Analysis for Two Data Sets ....................... 60
3.4.1 Time Series Data—Visual Analysis ................... 61
3.4.2 Cross-Sectional Data—Visual Analysis ................. 65
3.4.3 Analysis of Time Series Data—Descriptive Statistics ........... 67
3.4.4 Analysis of Cross-Sectional Data—Descriptive Statistics .......... 69
3.5 Analysis of Time Series Data—Forecasting/Data Relationship Tools ....... 72
3.5.1 Graphical Analysis ........................... 73
3.5.2 Linear Regression ........................... 77
3.5.3 Covariance and Correlation ....................... 82
3.5.4 Other Forecasting Models ....................... 84
3.5.5 Findings ............................... 85
3.6 Analysis of Cross-Sectional Data—Forecasting/Data Relationship Tools ...... 85
3.6.1 Findings ............................... 92
3.7 Summary .................................. 93
Key Terms .................................... 94
Problems and Exercises .............................. 94
3.1 Introduction
In this chapter we continue our study of data analysis, particularly the analysis of
quantitative data. In Chap. 2 we explored types and uses of data, and we performed
data analysis on quantitative data with graphical techniques. This chapter will delve
more deeply into the topic of quantitative data analysis, providing us with a strong
foundation and a preliminary understanding of the results of a data collection effort.
Some statistical tools will be introduced, but more powerful tools will follow in later
chapters.
H. Guerrero, Excel Data Analysis , DOI 10.1007/978-3-642-10835-8_3,
C
55
Springer-Verlag Berlin Heidelberg 2010
Search JabSto ::




Custom Search