A Guide to Statistics Using Excel and Palisade's StatTools Software
By Dr. Chris Albright
Palisade's StatTools software brings unprecedented statistical power to Microsoft Excel. By combining robust statistical procedures, Excel's ease-of-use, and customization capabilities, StatTools sets a new standard in statistical analysis. Learning Statistics with StatTools is written to help you get the most out of StatTools in a practical, straightforward manner.
Much more than a software reference manual, this book shows you how to apply statistics to problems you face. Each chapter discusses a logically grouped set of statistical procedures, grouped as they are in the StatTools menu structure. The author illustrates each procedure with a representative data set, explaining how StatTools can be used to analyze the data in an appropriate way. He even discusses the meaning of the StatTools output, just for those of you who need a refresher in basic statistics. After many of the sections, additional notes are provided about alternative StatTools possibilities or statistical details.
Statistical procedure groups covered include:
• Summary Statistics
• Summary Graphs
• Statistical Inference
• Normality Tests
• Data Utilities
• Regression and Classification
• Time Series and Forecasting
• Quality Control
• Expanding StatTools with Custom Procedures
Dr. Chris Albright
Dr. Chris Albright received his B.S. degree in Mathematics from Stanford in 1968 and his Ph.D. in Operations Research from Stanford in 1972. Since then, he has been teaching in the Operations and Decision Technologies Department in the Kelley School of Business at Indiana University. He has taught courses in management science, computer simulation, and statistics to all levels of business students: undergraduates, MBAs, and doctoral students. He has published over 20 articles in leading operations research journals in the area of applied probability, and he has authored other successful titles including Practical Management Science, VBA for Modelers, and Data Analysis and Decision Making.