Student Resources

Interactive Quizzes

Chapter 1

Chapter 2

Chapter 3

Chapter 4

Chapter 5

Chapter 6

Chapter 7

Chapter 8

Chapter 9

Chapter 10

Chapter 11

Chapter 12

Chapter 13

Chapter 14

Chapter 15

Chapter 16

Chapter 17

Chapter 18

Chapter 19

Chapter 20

Chapter 21

Chapter 22

Chapter 23

Chapter 24

Chapter 25

Data Sets

The Excel and SPSS files below relate to Chapters 12 & 23 of the book.
Chapter 12 uses SPSS to analyze the data and the Questions for Review refer you to the dataset to do an analysis.
Chapter 23 introduces the dataset of the gym survey. Click on the links below to download the datasets to your computer.
Please note that you will need the SPSS programme installed on your computer in order to download the dataset in SPSS format.

Excel dataset - gym attendance
SPSS dataset - gym attendance

Web Boxes

Part 1

Chapter 1

Chapter 2

   

Part 2

Chapter 3

Chapter 4

Chapter 5

Chapter 6

Chapter 7

Chapter 8

 

 

Part 3

Chapter 9

Chapter 10

Chapter 11

Chapter 13

Chapter 14

Chapter 15

Chapter 16

Chapter 17

Chapter 18

Chapter 19

Chapter 20

Chapter 21

Chapter 22

     

Part 4

Chapter 25

Additional Resources

Author: Weblinks: Albert J. Mills , St. Mary's University, and Anthony R. Yue, Mount Saint Vincent University / Research Project Guide: Adapted by: Albert J. Mills , St. Mary's University, and Anthony R. Yue, Mount Saint Vincent University

Weblinks

Research Project Guide

Student Interviews

Tips for Using Excel in Data Analysis

This resource has been authored by David Whigham, Senior Lecturer in Economics at Glasgow Caledonian University.

The workbooks contain instructions and practical examples to help you make the most of using Excel in data analysis.
Click on the links below to download the workbooks.

Excel 1: Basic Excel Techniques
Topics covered: Excel preliminaries, including: definitions and data types; customizing, sheet operations (inserting sheets, naming sheets, linking sheets, selecting areas of sheets); saving and printing; naming cells; copying (fully relative copying and dollar fixing); IF statements; vlookup function; and sumproduct function.

Excel 2: Descriptive Statistics
Topics covered: Weighted Average; If Statement; central tendency; dispersion (variance, standard deviation, quartiles and interquartile range); frequency distributions; descriptive statistics; ranking data; correlation (Pearson's correlation coefficient); and rank correlation (Spearman's rank correlation coefficient).

Excel 3: Contingency Tables (Cross Tabulation)
Topics covered: Two way pivot (contingency) tables and three way pivot (contingency) tables, including: Absolute count, percentage count, and averages; refreshing data in contingency tables; and categorizing data with contingency tables.

Excel 4: Charting and Regression
Topics covered: Charts, including: line, column, bar, and scatter charts; trend lines (both linear and quadratic), linear regression, time series, multiple regression.

Excel 5: Inference (Statistical Significance)
Topics covered: Inference and statistical significance, including: inferences about the population mean; the difference between two population means; the population regression coefficients; the association between categorical variables, The Chi Squared Statistic; and the population regression coefficients.