Bryman: Social Research Methods: 4e
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
- Excel 2: Descriptive Statistics
- Excel 3: Contingency Tables (Cross Tabulation)
- Excel 4: Charting and Regression
- Excel 5: Inference (Statistical Significance)
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.
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).
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.
Topics covered: Charts, including: line, column, bar, and scatter charts; trend lines (both linear and quadratic), linear regression, time series, multiple regression.
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.