●
AltHyp=0 for μ<μ
0
●
AltHyp=1 for μ>μ
0
●
AltHyp=2 for μ≠μ
0
Example:
LinRegrTTest({1,2,3,4}, {3,2,0,-2}, 0) returns {−9.814..., 2, 5, −1.7, 0.387..., 0.173...,
0.474..., −0.989..., 0.979...}
Finance app functions
The Finance app uses a set of functions that all reference the same set of Finance app variables. These
correspond to the elds in the Finance app Numeric view. There are 5 main TVM variables, 4 of which are
mandatory for each of these functions, as they each solve for and return the value of the fth variable to two
decimal places. DoFinance is the sole exception to this syntax rule. Note that money paid to you is entered
as a positive number and money you pay to others as part of a cash ow is entered as a negative number.
There are 3 other variables that are optional and have default values. These variables occur as arguments to
the Finance app functions in the following set order:
●
NbPmt—the number of payments
●
IPYR—the annual interest rate
●
PV—the present value of the investment or loan
●
PMTV—the payment value
●
FV—the future value of the investment or loan
●
PPYR—the number of payments per year (12 by default)
●
CPYR—the number of compounding periods per year (12 by default)
●
BEG—payments made at the beginning or end of the period; the default is BEG=0, meaning that
payments are made at the end of each period
The arguments PPYR, CPYR, and BEG are optional; if not supplied, PPYR=12, CPYR=PPYR, and BEG=0.
CalcFV
Solves for the future value of an investment or loan.
CalcFV(NbPmt,IPYR,PV,PMTV[,PPYR,CPYR,BEG]
Example:
CalcFV(360, 6.5, 150000, -948.10) returns -2.25
CalcIPYR
Solves for the interest rate per year of an investment or loan.
CalcIPYR(NbPmt,PV,PMTV,FV[,PPYR,CPYR, BEG])
Example:
CalcIPYR(360, 150000, -948.10, -2.25) returns 6.50
410 Chapter 22 Functions and commands
Komentáře k této Příručce