Descriptive Statistics

Forside_Descriptive Statistics


The purpose of this book is to give the reader a full-scale insight in the tools of descriptive statistics – from construction of tables to regression analysis.

The book forms the foundation of the two subjects

• Statistics

• Descriptive Economics

Descriptive Statistics – with Excel Guidance will open up statistical publications to the reader and teach him/her how to use the statistical tools when writing a report in statistics or economics. The statistics used for the examples are mostly taken from the UN. from the OECD and from national statistical bureaus. The statistics to be used for the exercises can be downloaded from the internet at the address

Descriptive Statistics – with Excel Guidance gives detailed guidance in how to use the spreadsheet Excel for statistics. Elementary previous knowledge in Excel is assumed.

Descriptive Statistics – with Excel Guidance contains 73 exercises. 16 of the exercises deal with misuse of statistics. Detailed answers to the misuse exercises are given in Chapter 2. Answers to the rest of the exercises will be send to teachers on demand.

Students at universities, business schools, business academies etc. are the target group of this book.

The exercises have been tested by students from the University of Southern Denmark and from the Aarhus School of Business. Exchange students from Japan and from Oregon, USA, showed great concern in a preliminary edition long ago and were very helpful in correcting my often incorrect English. The book is dedicated to them.

Aarhus/Odense, 19 January 2010
Erik M. Bøye


Chapter 1.  Statistical Method
Chapter 2.  Misuse of Statistics
Chapter 3.  Tables
Chapter 4.  Index Numbers
Chapter 5.  Standard calculations
Chapter 6.  Growth rate
Chapter 7.  Graphs
Chapter 8.  Logarithmic Scaling
Chapter 9.  Measures of Location
Chapter 10. Measures of Dispersion
Chapter 11. Lorenz Curve
Chapter 12. Time Series Analysis
Chapter 13. Regression
Chapter 14. Correlation