Use of Microsoft Excel for Statistical Analysis
Contemporary Business Statistics with Microsoft Exel is first and foremost a statistics textbook that emphasizes statistical concepts and applications. But, since most practical problems are too large to be solved using hand calculations, some type of statistical ware package is required to sove these problems. There are several excellent statistical packages a available today. However,because most students and potential employerrs value
spreasheet experience, many schools now use a spreadsheet package in their statisticcs courses. Microsoft Excel is the most widely used spreadsheet package in C as well as in colleges and universities. We have written Contemporary Business Statisticcs with Microsoft Excel especially for statisticcs courses in which Excel is used as the software package.
Excel has been integrated within each of the chapters,and integral part in providing an application orientation. We assume that reader using this text are familiar with Excel basics such as selecting cells, entering formulas, copying, and so on. We build on that familiarity by showing how to use the appropriate Excel statistical functions and data analysis tools
Chapter 1 Data and Statistics 1
Chapter 2 Descriptive Statistics: Tabular and Graphical Presentations
Chapter 3 Descriptive Statistics: Numerical Measures
Chapter 4 Introduction to Probability
Chapter 5 Discrete Probability Distributions
Chapter 6 Continuous Probability Distrrbutions
Chapter 7 Sampling and Sampling Distributions
Chapter 8 Interval Estimation
Chapter 9 Hypothesis Tests
Chapter 10 Statistical Inference About Means and Proportions with Two Populations
etc.