Business Statistics Using Excel provides students with the tools they need to confidently approach their course, using screenshots to integrate Excel effectively throughout the text. Each chapter is packed with exercises to engage students and encourage self testing. The authors provide various pedagogical features to show how statistics are used in the real world, including numerous examples throughout, and running 'techniques in practice' exercises at the end of each chapter. The book also contains chapters on how to use Excel and a maths refresher, as well as hosting a numerical skills revision chapter online, all of which help to reinforce students' confidence in their mathematical ability, even if they feel they have forgotten what they have previously learnt. The text is based around a typical one semester business statistics course, thus ensuring that the content maps well to the modules. It is also accompanied by an extensive Online Resource Centre providing a wealth of self-test questions for students, and a test bank for lecturers. Online Resource Centre Student resources: Numerical skills workbook Multiple-choice questions Annotated web links Online glossary of terms Revision tips Podcasts Lecturer resources: Instructor's manual (including detailed worked answers to the exercises in the book) Cases from the book with suggested solutions Assignment questions Examination questions PowerPoint slides for each chapter Test bank of questions (a suite of 15-20 questions per chapter, comprising and equal number of multiple choice, multiple response and true-false questions) The test bank can be downloaded by lecturers and imported into an appropriate e-Learning platform.
How to use the Online Resource Centre
1 Introduction to Microsoft Excel 2003 1
2 Numerical Skills Revision 31
3 Visualizing and Presenting Data 75
4 Data Descriptors 128
5 Probability Distributions 177
6 Sampling Distributions and Estimating 238
7 Introduction to Parametric Hypothesis Testing 297
8 Chi Square and Non-Parametric Hypothesis Testing 352
9 Factorial Experiments 393
10 Linear Correlation and Regression Analysis 454
11 Time Series Data and Analysis 518
Student Exercises Answers 577
Glossary 595
Index 601
