Excel and Data Analysis (Includes 1 CD-ROM) (With CD-ROM)

Author: Yu Chuanhua
Publisher:
Publish Date: 2002-09-01
Features: The CD-ROM includes a large number of data analysis example files, statistical analysis templates, and computer experiment teaching materials. It comprehensively introduces methods for easily conducting data analysis using Excel and provides solutions to data analysis problems encountered in practical work. The book utilizes Excel's unique functions, combined with specific examples, to systematically and comprehensively explain methods such as data editing, querying, the creation of sub-data lists, data organization and pivot, the creation of statistical graphs, and statistical analysis of data. The book not only uses Excel functions to develop numerous statistical analysis modules, achieving functions that cannot be completed by Excel's data analysis tools, but also uses Excel functions to create many statistical computer experiments. These experiments help in understanding abstract statistical concepts and are beneficial for statistical teaching. The book also explores experimental design methods in Excel, such as randomization grouping and sample size calculation. The CD-ROM that accompanies the book is easy to operate; readers need only to copy or enter data to obtain statistical analysis or computer experiment results immediately.