Forecast – Apple Numbers '08 User Manual
Page 233

Chapter 12
Dictionary of Functions
233
FORECAST
The FORECAST function uses linear regression analysis of known value pairs to find the
y (dependent) value that corresponds to a chosen x (independent) value.
FORECAST(x, y-values, x-values)
 x: The x value for which you want to find a corresponding y value.
 y-values: A range of cells containing the known y values. Must be the same size as x-
values.
 x-values: A range of cells containing the known x values.
Notes
You can use the SLOPE and INTERCEPT functions to find the equation used to calculate
forecast values.
FV
The FV function calculates the future value of an investment, given a series of fixed,
periodic added payments, interest rate, and number of periods. FV stands for future
value.
FV(rate, num-periods, [payment], [present-value], [when-due])
 rate: The interest rate per period.
 num-periods: The number of periods.
 payment: Optional; the added payment to be made per period, specified as a
negative number. If omitted, you must include present-value.
Examples
FLOOR(0.25,1) returns 0.
FLOOR(1.25,1) returns 1.
FLOOR(5,2) returns 4.
FLOOR(73,10) returns 70.
FLOOR(-0.25,-1) returns 0.
FLOOR(9,2.5) returns 7.5.
Examples
Given the following table:
FORECAST(9, A3:F3, A2:F2) returns 19.