You are here

Business Statistics Using EXCEL and SPSS

Business Statistics Using EXCEL and SPSS

January 2016 | 584 pages | SAGE Publications Ltd
Takes the challenging and makes it understandable. The book contains useful advice on the application of statistics to a variety of contexts and shows how statistics can be used by managers in their work.' - Dr Terri Byers, Assistant Professor, University Of New Brunswick, Canada

A book about introductory quantitative analysis, the authors show both how and why quantitative analysis is useful in the context of business and management studies, encouraging readers to not only memorise the content but to apply learning to typical problems.

Fully up-to-date with comprehensive coverage of IBM SPSS and Microsoft Excel software, the tailored examples illustrate how the programmes can be used, and include step-by-step figures and tables throughout. A range of ‘real world’ and fictional examples, including "The Ballad of Eddie the Easily Distracted" and "Esha's Story" help bring the study of statistics alive.

A number of in-text boxouts can be found throughout the book aimed at readers at varying levels of study and understanding

  • Back to Basics for those struggling to understand, explain concepts in the most basic way possible - often relating to interesting or humorous examples
  • Above and Beyond for those racing ahead and who want to be introduced to more interesting or advanced concepts that are a little bit outside of what they may need to know
  • Think it over get students to stop, engage and reflect upon the different connections between topics
A range of online resources including a set of data files and templates for the reader following in-text examples, downloadable worksheets and instructor materials, answers to in-text exercises and video content compliment the book.

An ideal resource for undergraduates taking introductory statistics for business, or for anyone daunted by the prospect of tackling quantitative analysis for the first time.

About the Authors



Foreword: What is this book? How should you use it?
Part 1: Demystifying Quantitative Analysis
Chapter 1: Demystifying Quantitative Data Analysis
Chapter 2: Gathering and Preparing Data
Chapter 3: The Software Environment
Chapter 4: Describing Your Data
Chapter 5: Introduction to Probability
Chapter 6: Random Variables and Probability Distributions
Chapter 7: Sampling and Intervals
Part 2: Introduction to Statistical Inference Concepts and Methods
Chapter 8: Statistical Hypothesis Testing
Chapter 9: First Steps In Testing Relationships – Goodness of Fit and Independence Tests
Chapter 10: Correlation and Regression
Chapter 11: Regression Special Topics
Chapter 12: Comparing Two Populations
Chapter 13: Population Variances
Part 3: Specialist Topics in Quantitative Analysis
Chapter 14: ANOVA
Chapter 15: Time Series Models and Forecasting
Chapter 16: Using Statistics for Quality Control




Instructor Resources
  • Answers to in-text exercises and think it over boxes in the book
  • Workbooks
  • Answer books
  • Datasets (including figures & tables files)
  • Videos
Student Resources
  • Answers to in-text exercises and think it over boxes in the book
  • Datasets
  • Workbooks for self-study

I am using the book for the course datamining with SPSS, but it didn't cover allthings we need in this course.

Professor Wolfgang Hauke
Business Administration , Kempten University of Applied Sciences
March 8, 2016

Often, SPSS or Statisttica appear to be the exclusive applications to deal with large amounts of data. However, doing statistics with Excel is an alternative, at least for smaller sample sizes (below 9.000). Just, until now, related literature was missing and teaching methods on this level was just good enough for volunteers. The book offers an opportunity to hand it over to students when starting to work on their theses. Thanks to the author.

Dr Thomas Richter
Management , University of Duisburg-Essen
February 24, 2016

Good book, but too involved for the work required

Dr Colin Mackenzie
Business School, Edinburgh Napier University
October 18, 2016

An easy to read and interpretation of Statistics. Clear and concise. Some good tips and recommendation. Examples very simple to follow. Beginner level of stats.

Miss Kate Grant
All Saints Campus, Manchester Metropolitan University
February 25, 2016