Excel Statistical Analysis and Decision Making

Author: Blue Imagination Press
Publisher:
Publish Date: 2001-02-01
Features: This book integrates statistics with Excel to form a unique content system. It focuses on statistical theory and methods, introducing how to use Excel's spreadsheet technology, statistical worksheet functions, and data analysis tools to process and analyze various economic phenomena. The book is divided into three parts. The first part covers the basic knowledge and simple operations of Excel. The second part, centered on statistical theory, explores the application of Excel in statistical analysis and decision-making. It provides both an intuitive presentation of statistical theory and case studies, covering topics such as statistical description, probability distributions, statistical inference, regression, and forecasting. This is the core part of the book. The third part is an appendix, detailing the syntax and functions of Excel statistical functions, as well as Excel's statistical analysis tools. The book emphasizes how to use Excel to understand statistical theory, conduct statistical analysis and decision-making, and aims to demonstrate the organic integration of Excel and statistical methods through simulations with large datasets and case studies, showcasing strong practicality. A CD is included with the book, containing the original data, calculation results, and teaching aids for the examples and cases in each chapter. This book is suitable as a computer-assisted textbook for undergraduate statistics courses in higher education institutions, as a reference for Excel applications in statistics, and as a guide for economic and management personnel engaged in statistical analysis and forecasting.