An Excel companion for business statistics

Synopsis

Although the primary purpose of this workbook is to introduce the statistical capabilities of Excel, it is written assuming students may not have had prior experience with Windows and/or Excel. Accordingly, Chapter 1 includes a brief introduction to the Windows environment and an introduction to Excel. Because of the large degree of consistency in the topics and organization of many business statistics textbooks, this manual is designed to be used with most business statistics textbooks. For those topics where there is no consistency in organization, a modular approach is used. Providing step-by-step instructions, the intent is to work through a topic within the manual and then apply Excel to similar exercises in the textbook being used. The topics within this manual include: (1) the charts, graphs and descriptive measures of descriptive statistics, (2) the probability distributions, point estimates, confidence intervals and hypothesis testing of introductory inferential statistics, and (3) the multivariate analysis approaches of the analysis of variance, regression analysis and time series forecasting.