Excel 2003 Functions and Statistical Applications Practice

Author: Wu Quanwei
Publisher:
Publish Date: 2005-05-01
Features:
Features of the Book:
· The book starts with basic Excel operations, then guides readers on how to use Excel's statistical functions, and finally applies these techniques to data collection and statistical practical work.
· The content is presented in a step-by-step manner, with illustrations and clear explanations, featuring typical and continuous examples.
· The book includes a CD-ROM containing all the example files, providing readers with a shortcut to quickly master the application of Excel in statistics.
The book begins with simple Excel editing techniques, then guides readers on how to use Excel's statistical functions, and finally applies these techniques to data collection and statistical practical work. The book is divided into three parts:
Part 1: Basic Excel Operations (introducing basic editing techniques in Excel, including data editing, general formula and function input, statistical chart creation, and report output).
Part 2: Data Analysis and Statistical Applications (introducing data analysis and statistical application techniques, including text splitting and format conversion, data filtering and pivot tables, statistical function application, data analysis toolset, macro and VBA programming design, and automated programming design).
Part 3: Online Surveys and Statistics (introducing techniques for online surveys and statistical applications, including basic database editing techniques, ASP and Excel data automatic updates).
The appendix briefly introduces the operation methods of SPSS11.5.