This is a supplemental text intended to accompany an introductory statistics textbook. Each chapter is organized around a particular statistical concept or technique. Some of the chapters contain experiments designed to permit students to explore statistical concepts by using the computer to perform experiments. The use of Excel to conduct established analytical procedures is fully covered.

This is a supplemental text intended to accompany an introductory statistics textbook. Each chapter is organized around a particular statistical concept or technique. Some of the chapters contain experiments designed to permit students to explore statistical concepts by using the computer to perform experiments. The use of Excel to conduct established analytical procedures is fully covered.

Business statistics students at both the undergraduate and MBA level who are not experts in the use of Excel. This text is designed to reflect the important changes in the teaching of statistics brought about by the usage of computers. It takes advantage of the ability of computers to help students understand statistical methods. It uses a straightforward, step-by-step approach, and uses the computer both as a tool for solving statistical problems and as pedagogical device to help students understand difficult concepts. *Excel usage has been simplified: Less emphasis on formatting. More emphasis on helping students get the 'big picture'. *Excel is used more as a scratch pad: In the revision the approach has moved from creating worksheets which automatically solve problems to using Excel as a scratch pad for each problem that arises. *All screen captures updated to Excel 2000 and all the material has been tested on Excel 2000. *Step-by-step instructions: Detailed instructions are given as each new topic is introduced. As students become more familiar with the topics less coaching is provided. *Computer demonstrations reinforce student understanding: Students are directed to use Exce

On statistics with Excel

The personal computer has made statistical analysis easier and cheaper. Previously, statistical analysis was difficult for many reasons. Two of the reasons were: (1) statistical analysis was slow and tedious because calculations were done by hand; (2) it was costly because it was done on mainframes and mainframe time was expensive. This book discusses statistical analysis using two personal computer software packages, Minitab 12 and Microsoft Excel 97, Minitab was chosen because it is powerful and is one of the more user-friendly statistical software packages. Microsoft Excel 97 was selected because it is one of the most important software packages to learn and most companies use Microsoft Excel. Excel is a software package that is not dedicated to statistical analysis like Minitab, but it has many statistical features and a very powerful development environment for writing customized statistical analysis. The book is organized in a textbook format. Each chapter discusses statistical conceptsand illustrates the use of Minitab and/or Excel. Often it becomes necessary to write macros (programs) in order to do specific statistical analysis. This books prints the codes of the macros for the reader to use and study. This is valuable because usually the difficult part is how to write the code. What the reader will find after studying this book is that statistical analysis will become more fun because he will have more time doing statistical analysis and make less statistical calculations.

Applied Business Statistics for Business and Management using Microsoft Excel is the first book to illustrate the capabilities of Microsoft Excel to teach applied statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical statistical problems in industry. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in statistics courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Applied Business Statistics for Business and Management capitalizes on these improvements by teaching students and practitioners how to apply Excel to statistical techniques necessary in their courses and workplace. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand business problems. Practice problems are provided at the end of each chapter with their solutions.