Student Resources
Interactive Quizzes
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
Part 2
|
|
Part 3
Part 4
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
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.