Microsoft Office Tutorials and References
In Depth Information
Generating Financial Results
MAX
MAX returns the largest value in a set of values.
The MAX function can be used on numbers and dates. As you notice in Figure 2.3, the MAX
function is used to return the largest date in a range of dates.
MIN
MIN returns the smallest number in a set of values with MIN .
The MIN function, like the MAX function, can return dates and values. In Figure 2.3, the MIN
function is used to return the lowest value within the range.
STDEVA
STDEVA estimates standard deviation based on a sample, and it acts upon values.
The standard deviation is based on how widely the values are dispersed from the average
value. The average value is referred to as the mean. In Figure 2.3, the standard deviation
from the average count of units is 1.41.
FORECAST
FORECAST calculates or predicts a future value by using existing values.
The FORECAST function returns the forecast for the existing units sold in column F of Figure
2.3. The known y’s and known_x’s are in arrays, and the predicted value is achieved using
linear regression.
Figure 2.3
Commonly used
STATISTICAL
functions.
Generating Financial Results
CUMIPMT
Use CUMIPMT to return the cumulative interest on a loan between start and stop dates.
Search JabSto ::

Custom Search