Microsoft Office Tutorials and References
In Depth Information
Generating Financial Results
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 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 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 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
Generating Financial Results
Use CUMIPMT to return the cumulative interest on a loan between start and stop dates.
Search JabSto ::

Custom Search