Technical data

Chapter 11 Using Built-in Functions in Analytic M odels
• SIN(PI()/2)returns 1 (sine of PI / 2 radians).
• SIN(45 * PI( ) / 180) returns 0.7071067812 (sine of 45 degrees).
SLN
Syntax
SLN(Cost, Salvage, Life )
Description
The SLN functi
on returns the depreciation o n an asset by using the straight line method, which is a single
programming s
tatement. This function returns the same depreciation for each period.
Parameters
Parameter Description
Cost The cost of the asset.
Salvage The worth of the asset at the end of its useful life.
Life The number o
f periods in the asset’s useful life.
Returns
The depreciation on an asset using the Straight Line method. This function returns the same depreciation
for each period.
Example
Suppose that you purchase a machine for 6,000 USD, and you plan to sell it for 500 USD after five years. You
can calculate the depreciation for each year as follows:
SLN(6000, 500, 5) = 1100
SLOPE
Syntax
SLOPE(Dimension, Y, X, {Condition})
Description
The SLOPE f
unction returns the slope of the line that has the closest fit to the points represented by Y and X.
(The slope
isthechangeinY divided b y the change in X.) If Condition is omitted, the function fits the line to
all of the
members in Dimension.IfCondition is included, the function fits the line only to those members
that meet
the condition.
Use the SLOPE function together with the INTERCEPT function to find the line with the closest fit to a set of
points. You can use these functions to analyze a historical trend, and then use the trend to make forecasts.
You can also use these functions to analyze the relationship between different variables, such as sales and
travel expense.
Copyright © 1988-2007, Oracl e. All rights reserved. 189