Filter
Top Products
B: More About Calculations 251
File name : 17BII-Plus-Manual-E-PRINT-030709 Print data : 2003/7/11
For the last year of depreciation, DB equals the remaining depreciable
value for the prior year.
Sum and Statistics
n＝number of items in the list.
x’＝an element of the sorted list.
1
2
1
for odd n, where
2
( )
for even n, where
22
( )
1
( -
.
i
i
j
j
j
i
ii
x
TOTAL x MEAN x
n
n
MEDIAN x j
xx
n
MEDIAN j
xx
STDEV
n
yx
WMN
+
===
+
′
==
′′
+
==
Σ−
=
−
=
Σ
Σ
Σ
2
2
) ()
.
() 1
ii i
ii
yx y x
GSD
yy
−
=
−
ΣΣ
ΣΣ
RANGE
＝
MAX
－
MIN
Forecasting
Model Transformation X
i
Y
i
LIN
EXP
LOG
PWR
y = B + Mx
y = Be
Mx
y = B + M ln x
y = Bx
M
y = B + Mx
In y = ln B + Mx
y = B + M ln x
ln y = ln B + M ln x
x
i
x
i
ln x
i
ln x
i
y
i
ln y
i
y
i
ln y
i