Apple Numbers '08 Manual do Utilizador descarregar pdf (Página 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.

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.

1 2 ... 228 229 230 231 232 233 234 235 236 237 238 ... 294 295

Sem comentários

Apple Numbers '08 Manual do Utilizador Página 233