Data Analysis Using Microsoft Excel or The SSCP Prep Guide

Data Analysis Using Microsoft Excel: Updated for Office XP

Author: Michael R Middleton

Spreadsheet skills are important for a first job, and DATA ANALYSIS USING MICROSOFT EXCEL prepares students to enter the world of work with stronger spreadsheet skills. Designed as a supplement to a main statistics text or as a reference for professionals, this handbook helps students build their proficiency in Microsoft Excel and shows them how to use the built-in capabilities of Excel to analyze data and make decisions. Although many of the examples are business oriented, the step-by-step approach makes this book appropriate for statistical analysis in other courses and academic disciplines.

Table of Contents:

Ch. 1	Introduction to Excel	1
Ch. 2	Managing Files and Printing	13
Ch. 3	Basic Charts	25
Ch. 4	Univariate Numerical Data	35
Ch. 5	Categorical Data	49
Ch. 6	Bivariate Numerical Data	61
Ch. 7	Probability Distributions	71
Ch. 8	Sampling and Simulation	85
Ch. 9	One-Sample Inference for the Mean	97
Ch. 10	Quality Control Charts	113
Ch. 11	Two-Sample Inference for Means	123
Ch. 12	Chi-Square Tests	139
Ch. 13	Analysis of Variance	149
Ch. 14	Simple Linear Regression	167
Ch. 15	Simple Nonlinear Regression	183
Ch. 16	Multiple Regression	197
Ch. 17	Regression Using Categorical Variables	207
Ch. 18	Autocorrelation and Autoregression	219
Ch. 19	Time Series Smoothing	233
Ch. 20	Time Series Seasonality	249
App	Excel on the Macintosh	271
	References	273
	Index	275

Read also Electronic Commerce or Online Retrieval

The SSCP Prep Guide: Mastering the Seven Key Areas of System Security

Author: Debra S Isaac

• SSCP (System Security Certified Practitioner) is the companion test to CISSP, appealing to the practitioners who implement the security policies that the CISSP-certified professionals create

• Organized exactly like the bestselling The CISSP Prep Guide (0-471-41356-9) by Ronald L. Krutz and Russell Dean Vines, who serve as consulting editors for this book

• This study guide greatly enhances the reader's understanding of how to implement security policies, standards, and procedures in order to breeze through the SSCP security certification test

• CD-ROM contains a complete interactive self-test using all the questions and answers from the book, powered by the Boson test engine