Data Analysis Using Microsoft Excel Updated

The latest edition of this reference book shows readers how to do statistical analysis with the popular Microsoft Excel/Office 97 (or Excel 98 on the Macintosh) spreadsheet program. The book includes its own data sets and is easy to follow and exceedingly comprehensive.

Introduction to Excel

1

(12)

Managing Files and Printing

13

(12)

Basic Charts

25

(10)

Univariate Numerical Data

35

(14)

Categorical Data

49

(12)

Bivariate Numerical Data

61

(10)

Probability Distributions

71

(14)

Sampling and Simulation

85

(12)

One-Sample Inference for the Mean

97

(16)

Quality Control Charts

113

(10)

Tow-Sample Inference for Means

123

(16)

Chi-Square Tests

139

(10)

Analysis of Variance

149

(18)

Simple Linear Regression

167

(16)

Simple Nonlinear Regression

183

(14)

Multiple Regression

197

(10)

Regression Using Categorical Variables

207

(12)

Autocorrelation and Autoregression

219

(14)

Time Series Smoothing

233

(16)

Time Series Seasonality

249

(24)

Appendix

Excel 98 on the Macintosh

271

(2)

References

273

(2)

Index

275

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Rent More, Save More! Use code: BBRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

Data Analysis Using Microsoft Excel Updated for Office 97

Summary

Table of Contents

Supplemental Materials