Introductory Business Statistics with Interactive Spreadsheets – 1st Canadian Edition is an adaptation of Thomas K. Tiemann’s book, Introductory Business Statistics. This new edition still contains the basic ideas behind statistics, such as populations, samples, the difference between data and information, and sampling distributions as well as information on descriptive statistics and frequency distributions, normal and t-distributions, hypothesis testing, t-tests, f-tests, analysis of variance, non-parametric tests, and regression basics. New topics include the chi-square test and categorical variables, null and alternative hypotheses for the test of independence, simple linear regression model, least squares method, coefficient of determination, confidence interval for the average of the dependent variable, and prediction interval for a specific value of the dependent variable.
This new edition also allows readers to learn the basic and most commonly applied statistical techniques in business in an interactive way — when using the web version — through interactive Excel spreadsheets. For each topic, a customized interactive template has been created within which selected values can be repeatedly changed to observe how the entire process, as well as the outcomes, are automatically adjusted.
Also, in this adapted edition, the real-world examples throughout the text, and the information in general, have been revised to reflect Canadian content.
Unless otherwise noted, Introductory Business Statistics with Interactive Spreadsheets – 1st Canadian Edition is (c) 2010 by Thomas K. Tiemann. The textbook content was produced by Thomas K. Tiemann and is licensed under a Creative Commons-Attribution 3.0 Unported license, except for the following changes and additions, which are (c) 2015 by Mohammad Mahbobi, and are licensed under a Creative Commons-Attribution 4.0 International license.
All examples have been changed to Canadian references, and information throughout the book, as applicable, has been revised to reflect Canadian content. One or more interactive Excel spreadsheets have been added to each of the eight chapters in this textbook as instructional tools.
The following additions have been made to these chapters:
- chi-square test and categorical variables
- null and alternative hypotheses for test of independence
- simple linear regression model
- least squares method
- coefficient of determination
- confidence interval for the average of the dependent variable
- prediction interval for a specific value of the dependent variable
Under the terms of the CC-BY license, you are free to copy, redistribute, modify or adapt this book as long as you provide attribution. Additionally, if you redistribute this textbook, in whole or in part, in either a print or digital format, then you must retain on every physical and/or electronic page the following attribution:
Download this book for free at http://open.bccampus.ca
For questions regarding this license, please contact firstname.lastname@example.org. To learn more about the B.C. Open Textbook project, visit http://open.bccampus.ca.
Cover image: Business chart showing success (https://flic.kr/p/a5M1ZE) by Sal Falko (https://www.flickr.com/photos/safari_vacation/) used under a CC-BY-NC 2.0 license (https://creativecommons.org/licenses/by-nc/2.0/).