Excel 2003 Functions and Statistical Applications Practice

Author: Wu Quanwei / Lü Linlin
Publisher:
Publish Date: 2005-01-01
Features:
Features of this book:
· This 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 coherent examples.
· The accompanying CD-ROM includes all the example files in the book, providing readers with a shortcut to quickly master the application of Excel in statistics.
This 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: Excel Basic 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, and automated programming).
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.