Y Value Estimator

A specialty add-in product for Microsoft Excel

Do you have these problems:

• Missing data values in your spreadsheet?
• Multiple error values you want replaced?

The Y Value Estimator can solve all of these problems and more!

The Y Value Estimator fixes problems with missing data values or values.  For example if you have blanks or error values in your data, the Y Value Estimator will replace these values with an estimated value.  For example, 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" and plot the data, you will end up 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 allow you to specify IF tests and replace the value with an estimate if it is outside of a reasonable range.

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