Sharp Zaurus SL-5500 Software Manual page 65

SLOPE
(independent range, dependent range) Calculates the slope from a simple regression.
SMALL
(data range, value)
SQRT
(value)
SQRTPI
(value)
STANDARDIZE
(value, average, standard
deviation)
STDEV
(value1,value2,...)
STDEVMO
(value1,value2,...)
STERR
(independent
range)
SUBSTITUTE
(string, old string, new string,
position)
SUBTOTAL
(type, data range)
SUM
(value1, value2, ...)
SUMIF
(data range, condition, sum range)
SUMPRODUCT
(range1, range2, ...)
SUMSQ
(value1, value2, ...)
SUMXMY2
(range_x, range_y)
SYD
(cost, salvage, life, point)
TAN
(radians)
TANH
(radians)
TDIST
(value, freedom, cumulative)
TDISTINV
(probability, freedom)
TRIM
(string)
TRIMMEAN
(data range, percent)
TRUNC
(value, digits)
TVALUE
(value, sample data range, mean
of population)
UNIFORM
(min, max, value, cumulative)
UNION
(string1, string2, ....)
UPPER
(string)
VALUEIDX
(base period price, base period
quantity, compare period price, compare
period quantity)
CHAPTER 3:
range, dependent
HancomMobileSheet
Returns the k-th smallest value in a data range.
Calculates a positive square root of a value.
Calculates the square root of (value * pi).
Normalizes a value with average and standard
deviation.
Calculates the standard deviation of sample data.
Calculates the standard deviation of population.
Calculates the standard error of an estimated value
from a simple regression.
Substitutes an old string with a new string at the
position of an old string.
Calculates a subtotal by the type.
Adds all the numbers in a range of cells or values.
Adds the cells specified by a given condition.
Multiplies corresponding components in the given
ranges, and returns the sum of those products.
Returns the sum of the squares of values.
Returns the sum of the difference of squares of
corresponding values in two ranges.
Calculates the sum-of-years-digits depreciation of an
asset for a period.
Returns the tangent of radians.
Returns the hyperbolic tangent of radians.
Calculates the probability of T-distribution.
Calculates the inverse of T-distribution.
Removes all spaces from a string except for spaces
between words.
Calculates the mean
percentage of data points from the top and bottom
tails of a data set.
Truncates a value to an integer by removing the
fractional part of the number.
Calculates the T statistic under unknown variance of
a population.
Calculates the probability of uniform distribution.
Joins strings into a unified string.
Changes all lowercase letters into uppercase.
Calculates a value index.
taken by excluding
65
a