I described an alternative linear regression approach in Deming Regression. Whereas the standard linear regression techniques assume that all measurement error in the calculated model is in the dependent variable Y, the Deming Regression technique considers that both X and Y variable measurements may contain errors. Pairs of X-Y coordinates are used to estimate the [...]

In LOESS Smoothing in Excel I described a technique for smoothing data, which essentially runs a moving weighted regression on the data set. The amount of smoothing that can be achieved without washing out the data is remarkable. In that post I showed a screen shot of a dialog of a working LOESS utility. The [...]

BonaVista Systems, the makers of the MicroCharts family of sparkline and dashboard utilities for Microsoft Excel, has released a new product called Chart Tamer. Chart Tamer is designed to simplify and beautify Excel charts. Actually, I should not say “beautify”, because that implies embellishment. Chart Tamer simplifies and clarifies Excel charts. A peek at the [...]

As my regular readers know, I’ve started building Excel charting utilities. It’s challenging and rewarding, though I certainly won’t retire to my own island in the Caribbean on these utilities alone. Over the past few months I’ve released commercial utilities that create charts that Excel users only used to dream of, such as Waterfall Charts, [...]

Excel is a mighty powerful application, and yet, there are any number of utilities available to extend its capabilities. I’m sure everyone has their favorites, and here I’m going to talk about mine. My reliance on these utilities is as a developer of Excel applications, that is, solutions that combine add-ins, templates, and regular workbook [...]