Archive for Monday, March 10th, 2008
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 [...]
Posted: Monday, March 10th, 2008 under Charting Principles, Example Charts, Statistics.
Comments: 5
How To: Record Your Own Macro
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
In a recent post, I showed how to copy someone else’s VBA procedure (i.e., “macro”) and paste it into your own workbook. Fortunately you don’t have to rely on others for custom macros. Excel includes a Macro Recorder which captures your actions, so that you can replay them later, saving yourself time and keystrokes.
It’s easy [...]
Posted: Monday, March 10th, 2008 under VB Editor, VBA.
Comments: none
