Statistics

Statistics
Prev	A. Function List	Next

Random Number

rand([Ceil])

Generates a pseudo-random number. Returns a real number between 0 and 1, if ceil is zero (default), or an integer between 1 and (including) ceil.

Arguments.

Ceil: an integer (optional)

Random Number Between Limits

randbetween(Bottom, Top)

Returns an integer between (including) bottom and top.

Arguments.

Bottom: an integer
Top: an integer

Requirement. "Bottom"<="Top"

Descriptive Statistics

Decile

decile(Decile, Data)

Arguments.

Decile: a number >= 0 and <= 100
Data: a vector

Interquartile Range

iqr(Data)

Calculates the difference between the first and third quartile.

Arguments.

Data: a vector

Max

max(Vector)

Returns the highest value.

Arguments.

Vector: a vector

Median

median(Data)

Arguments.

Data: a vector

Min

min(Vector)

Returns the lowest value.

Arguments.

Vector: a vector

Mode

mode(Vector)

Returns the most frequently occuring value.

Arguments.

Vector: a vector

Number

number(Data)

Returns the number of samples.

Arguments.

Data: a vector

Percentile

percentile(Percentile (%), Vector)

Arguments.

Percentile (%): a number > 0 and < 99
Vector: a vector

Quartile

quartile(Quartile, Data)

Arguments.

Quartile: an integer >= 1 and <= 3
Data: a vector

Range

range(Data)

Calculates the difference between the min and max value.

Arguments.

Data: a vector

Sum (total)

total(Vector)

Arguments.

Vector: a vector

Distribution

Logistic Distribution

logistic(X, Scale)

Returns the probability density p(x) at x for a logistic distribution with scale parameter. (from Gnumeric)

Arguments.

X: a free value
Scale: a number >= 0

Pareto Distribution

pareto(X, Exponent, Scale)

Returns the probability density p(x) at x for a Pareto distribution with exponent and scale. (from Gnumeric)

Arguments.

X: a free value
Exponent: a number >= 0
Scale: a number >= 0

Rayleigh Distribution

rayleigh(X, Sigma)

Returns the probability density p(x) at x for a Rayleigh distribution with scale parameter sigma. (from Gnumeric)

Arguments.

X: a free value
Sigma: a number >= 0

Rayleigh Tail Distribution

rayleightail(X, Lower Limit, Sigma)

Returns the probability density p(x) at x for a Rayleigh tail distribution with scale parameter sigma and a lower limit. (from Gnumeric)

Arguments.

X: a free value
Lower Limit: a free value
Sigma: a number >= 0

Means

Geometric Mean

geomean(Data)

Arguments.

Data: a vector

Harmonic Mean

harmmean(Data)

Arguments.

Data: a vector

Mean

mean(Data)

Arguments.

Data: a vector

Quadratic Mean (RMS)

rms(Data)

Arguments.

Data: a vector

Trimmed Mean

trimmean(Trimmed Percentage (at each end), Data)

Arguments.

Trimmed Percentage (at each end): a free value
Data: a vector

Weighted Mean

weighmean(Data, Weights)

Arguments.

Data: a vector
Weights: a vector

Winsorized Mean

winsormean(Winsorized Percentage (at each end), Data)

Arguments.

Winsorized Percentage (at each end): a free value
Data: a vector

Moments

Covariance

covar(Data 1, Data 2)

Arguments.

Data 1: a vector
Data 2: a vector

Mean Deviation

meandev(Data)

Arguments.

Data: a vector

Pooled Variance

poolvar(Data 1, Data 2)

Arguments.

Data 1: a vector
Data 2: a vector

Standard Deviation (entire population)

stdevp(Data)

Arguments.

Data: a vector

Standard Deviation (random sampling)

stdev(Data)

Arguments.

Data: a vector

Standard Error

stderr(Data)

Arguments.

Data: a vector

Variance (entire population)

varp(Data)

Arguments.

Data: a vector

Variance (random sampling)

var(Data)

Arguments.

Data: a vector

Regression

Pearson's Correlation Coefficient

pearson(Data 1, Data 2)

correl

Arguments.

Data 1: a vector
Data 2: a vector

Requirement. dimension("Data 1")=dimension("Data 2")

Spearman's Rho

spearman(Data 1, Data 2)

Arguments.

Data 1: a vector
Data 2: a vector

Requirement. dimension("Data 1")=dimension("Data 2")

Statistical Correlation

cor(Data 1, Data 2)

Arguments.

Data 1: a vector
Data 2: a vector

Statistical Tests

Paired T-Test

pttest(Data 1, Data 2)

Arguments.

Data 1: a vector
Data 2: a vector

Unpaired T-Test

ttest(Data 1, Data 2)

Arguments.

Data 1: a vector
Data 2: a vector

Prev	Up	Next
Number Theory	Home	Trigonometry