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
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.
This manuscript contains various approaches in interpreting data and how the unearthed pieces of information be used as practical inputs for decision making. With the aid of Microsoft Excel, presented in a step-by-step manner, data sets that differ in kind, probability, and distributions are analyzed and interpreted with a framework of solidifying fundamental understanding of data analysis and of carrying through these skills in the daily administration of decisions in managing production, people, money, and all forms of resources. This book hopes to complement with the other existing books in research and statistics that prefer to treat problems manually and explain applications theoretically. Students doing basic high school research will benefit from this book. College and graduate students who are doing a classroom research activity will also take full advantage of this. However, some novice researchers and professionals may find this manuscript equally useful; and those others who decided to dislike mathematics but found awe in it nonetheless. This book is really for them.
