Y Value Estimator

An add-in for Microsoft Excel that estimates missing chart data values.

  • Estimate missing data values for your charts
  • Replace error values with estimates
  • Replace zeros that distort your charts with sensible estimates
  • Specify IF tests and replace values that fall outside a reasonable range
  • Completely menu driven with an exercise file for hands-on practice

The Y Value Estimator add-in for Microsoft Excel fixes problems with missing data values. For example, if you have blanks or error values in your data, the Y Value Estimator will replace them with an estimated value. If your data is “100, blank, 200” the Y Value Estimator will put in the estimate of “150” for the blank value.

If instead of blanks you have zeros — for example “100, 0, 200” — plotting the data leaves you with a strange-looking chart. By using the Y Value Estimator the zeros can be replaced with an estimate, giving a much better looking chart.

Other features of the Y Value Estimator let you specify IF tests and replace a value with an estimate if it falls outside of a reasonable range.

The Y Value Estimator is completely menu driven. The menus are easy to follow and use. To help you learn the features there is an exercise file that provides hands-on practice.

Download a trial version now!

Related add-ins