|
| Questions? Call us 302-234-9857, 8AM to 10PM U.S. East Coast time 7 days a week |
|
|
|
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.
|
|
| Copyright 2010 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark of Add-ins.com LLC. Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. |
