Statistical Quality Control Using Excel

Rating:
Summary: Excellent way to learn Excel charting and SPC
Review: This book does double duty by teaching the basics of Excel and basic statistics. It starts with the assumption that you know nothing about Excel, which can be skipped if you are familiar with the product, then starts tying things together with a chapter on fundamental statistics using Excel. From there the book devotes a foundation chapter on distributions, which is a nice refresher if you're a bit rusty, and next covers functions and data analysis tools that come with Excel 97 or higher that you're be using throughout the remainder of the book.

The remaining chapters thoroughly cover statistical process control charts (X-Bar, R, p, np, c and u), and process capability. You'll learn much about SPC from this part of the book, as well as some advanced Excel charting techniques. Also, the material with which you'll be working is provided on the accompanying disk, saving a lot of time by avoiding creating spreadsheets from scratch.

Pareto charts and Ishikawa (fishbone) diagrams are also covered, as well as advanced distributions such as binomial and hypergeometric, and excellent material and techniques for determining operating characteristics and power curves.

This is an excellent learning tool that has additional value from the accompanying spreadsheets that can be used on real projects with modification and expansion. I use the spreadsheets as a basic library of templates, which have proven to be real time savers. The book is clearly written and easy to follow, making it ideal for self-study.

Rating:
Summary: Excellent way to learn Excel charting and SPC
Review: This book does double duty by teaching the basics of Excel and basic statistics. It starts with the assumption that you know nothing about Excel, which can be skipped if you are familiar with the product, then starts tying things together with a chapter on fundamental statistics using Excel. From there the book devotes a foundation chapter on distributions, which is a nice refresher if you're a bit rusty, and next covers functions and data analysis tools that come with Excel 97 or higher that you're be using throughout the remainder of the book.

The remaining chapters thoroughly cover statistical process control charts (X-Bar, R, p, np, c and u), and process capability. You'll learn much about SPC from this part of the book, as well as some advanced Excel charting techniques. Also, the material with which you'll be working is provided on the accompanying disk, saving a lot of time by avoiding creating spreadsheets from scratch.

Pareto charts and Ishikawa (fishbone) diagrams are also covered, as well as advanced distributions such as binomial and hypergeometric, and excellent material and techniques for determining operating characteristics and power curves.

This is an excellent learning tool that has additional value from the accompanying spreadsheets that can be used on real projects with modification and expansion. I use the spreadsheets as a basic library of templates, which have proven to be real time savers. The book is clearly written and easy to follow, making it ideal for self-study.