Main menu:

Excel Books

Books that I own and use while developing in Excel

Goods and Services

Excel or charting related products and services which I use or feel are worthwhile additions

Excel User Conference

2008 US East Coast Excel User Conference
September 24-26, 2008
Atlantic City, NJ

Subscribe

Site search

Google
Web
PeltierTech.com

Recent Posts

Recently Commented

May 2008
S M T W T F S
« Apr    
 123
45678910
11121314151617
18192021222324
25262728293031

Archive


 

Categories


 

Archive for 'Statistics'

Introducing Control Charts (Run Charts)

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

Introduction to Control Charts
While employed as a scientist/engineer for a large manufacturing corporation, I pulled a stint as trainer for my company’s Total Quality program. This role occupied half of my time for three or four years. A large component of our Total Quality initiative was related to Statistical Process Control (SPC). And of all [...]

Statistical Process Control

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

Statistical Process Control (SPC) is a set of statistical and related methods for monitoring processes with an aim to improve productivity and reduce costs, time, and waste incurred by these processes. In fact, SPC is a philosophy surrounding the monitoring, analysis, and adjustment of process variables to produce continuous improvements in the process.
There are a [...]

Bill James Interview on Freakonomics

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

The Freakonomics blog interviewed Sabermetrics founder Bill James, in Bill James Answers All Your Baseball Questions. Bill James has been educating and entertaining us with his statistics-based observations about baseball for three decades. Baseball has always been surrounded by statistical analysis, but Mr James has been driven by a need to understand the game [...]

Statistics: Main Effects Plot

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

A commonly used chart type for statistical analysis is a Main Effects Plot. I won’t go into the statistics behind this chart type here, but I want to show how easy it can be to construct such a chart. For this example, suppose there are three main effects, designated X1, X2, and X3, and an experimental [...]