Calc Guide

Syntax Description
is the price (purchase price) of the security
per 100 currency units of par value.
Redemption is the redemption value per 100
currency units of par value. Basis indicates
how the year is to be calculated.
YIELDMAT(settlement;
maturity; issue; rate;
price; basis)
Calculates the annual yield of a security, the
interest of which is paid on the date of
maturity. Settlement is the date of purchase
of the security. Maturity is the date on which
the security matures (expires). Issue is the
date of issue of the security. Rate is the
interest rate of the security on the issue date.
Price is the price (purchase price) of the
security per 100 currency units of par value.
Basis indicates how the year is to be
calculated.
Statistical analysis functions
Calc includes over 70 statistical functions which enable the evaluation
of data from simple arithmetic calculations, such as averaging, to
advanced distribution and probability computations. Several other
statistics-based functions are available through the Add-ins which are
noted at the end of this appendix.
Table 37: Statistical analysis functions
Syntax Description
AVEDEV(number1;
number2; ... number_30)
Returns the average of the absolute deviations
of data points from their mean. Displays the
diffusion in a data set. Number_1; number_2;
... number_30 are values or ranges that
represent a sample. Each number can also be
replaced by a reference.
AVERAGE(number_1;
number_2; ... number_30)
Returns the average of the arguments.
Number_1; number_2; ... number_30 are
numerical values or ranges. Text is ignored.
AVERAGEA(value_1;
value_2; ... value_30)
Returns the average of the arguments. The
value of a text is 0. Value_1; value_2; ...
value_30 are values or ranges.
B(trials; SP; T_1; T_2) Returns the probability of a sample with
binomial distribution. Trials is the number of
independent trials. SP is the probability of
Appendix B Description of Functions 449