Formulas used in Static Simulation

Name

Description

Use

DESVMEDIO

Returns the average of absolute deviations as of the average. Standard Deviation is a variance measure in a data group.

=DESVMEDIO(num1;num2;...)

DISTENXPON

Return exponential distribution. Use DISTENXPON to adjust the hour among events (the time it takes an ATM to deliver the money).

=DISTEXPON(X;LAMBDA;CUMULATIVO)

DISTRBINOM

Returns the probability of binomial distribution of individual term. (ex: calculates the probability of two out of three babies be born boys)

• Number: the number of successful trials;
• Trials: the number of independent trials;
• Probability: success probability in each trial;
• Cumulative: logical value that establishes the form of function. If cumulative is True, then DISTRBINOM returns the cumulative distribution function, that is the probability in most of numbers achievements. If False, it returns to the mass probability function, that is the probability in numbers achievements.

=DISTRBINOM(NUM;TRIALS;PROBABILITIES;CUMULATIVE)

False

Return False Value for an expression.

=False()

MAXIMUM

Evaluates values sequence and returns the higher value.

=MAXIMUM(num1;num2;...)

AVERAGE

Returns arithmetic average of the arguments.

=MEDIA(num1;num2;...)

MIINIMUM

Evaluates values sequence and returns the lower value.

MINIMUM(num1;num2;...)

MONTC

amount is the sum of capital with interests.

Parameters:

Value: Capital;

 

Rate: Rate Value;

 

Time: Period;

 

Type of Rate: 0 – Day, 1 – Month, 2 – Year.

 

Type of Period: 0 – Day, 1 – Month, 2 – Year.

=MONTC(Value,Rate,Time,Type Rate,TypePeriod)

MONT:

Return the simples amount.

 

1) The MONT formula is composed by 5 parameters presented below:
I. Capital
II. Rate
III. Period
IV. Type of Rate (0 = days; 1 = months; 2 = years) Default = 0
V. Type of Period (0 = days; 1 = months; 2 = years) Default = 0

 

2) The following scenario will be used as an example
I. R$1200.00 Capital
II. 1.8% rate per month
III. 2-years period

 

C = capital, I = rate, T = time, J = interests, M = amount. 
M = C + J 
J = C * I * T 
I = 1.8% = 1.8 / 100 = 0.018 
T = 2 years = 2 * 12 = 24 months (equality between the period and rate – 1.8% rate per month) 
J = 12000 * 0.018 * 24 
J = 5184 
  
M = 12000 + 5184 
M = R$ 17184.00

=MONT(12000,00;1,8%;2;1;2)

NAO

Evaluates an expression and returns a logical value, if checking of the function \"no\" is true, function returns True. In the event it is false, it returns False.

=NO(expression)

TRUE

Returns the True value when an expression is true and returns False when expression is false.

=TRUE(EXPRESSION)

DESVPAD

Calculates standard deviation as of a sample. Standard deviation is a measure of dispersion degree of values related to average value (the average).

Usage: =DESVPAD(num1; num2; num3;...)

EPGTO

Calculates interests paid in an investment specific period. This function is provided in order to be compatible with Lotus 1-2-3.

EPGTO(rate;period;nper;vp)

INTERESTS

Are increases added to initial capital stock at the end of the investment

=INTERESTS(Capital;Interest Rates;Investment Time; Type of Rate;Type of Period)