Sharp Zaurus SL-5500 Software Guide

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

Sharp Zaurus SL-5500 Specifications

General

Brand	Sharp
Model	Zaurus SL-5500
Category	PDA
Language	English