OCONV Query AREV 3.2 (AREV Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 29 OCT 1998 12:48:53AM Mark Ford wrote:

AREV Specific

I am calculating averages, percentages , medians, standard deviations etc on data field that have been either defined as MD0, MD1 or MD2. I wish to print a report with all asnwers normalized to two decimal places. What is the best way to do this?

Normalize the data to two decimal places before starting the calculation?

Any assistance would be greatly appreciated.

Thanks,

Mark

At 29 OCT 1998 01:04AM Steve Smith wrote:

The best technique is calculate then store all numbers

internally as MD6 (eg. a high degree of precision)

and then depict them as MD2 or whatever is convenient

when reporting (via a program) so that the standard

error due to rounding/truncation is reduced to the final

presentation step only.

Steve

At 29 OCT 1998 02:05AM Curt Putnam wrote:

Or you can store them as FLOAT, and as Steve said, convert only for final presentation

At 29 OCT 1998 10:07PM Mark Ford wrote:

Thanks for the information. I have written a program to convert all data to the MD2 format prior to doing the statistical calculations. This seems to work.I will try your MD6 tip to gain greater precision.

Thanks again.

Mark

View this thread on the forum...