
PredX
Returns the predicted x for a given y.
PredX(mode, y, parameters)
●
Mode governs the regression model used:
1 y= sl*x+int
2 y= sl*ln(x)+int
3 y= int*exp(sl*x)
4 y= int*x^sl
5 y= int*sl^x
6 y= sl/x+int
7 y= L/(1 + a*exp(b*x))
8 y= a*sin(b*x+c)+d
9 y= cx^2+bx+a
10 y= dx^3+cx^2+bx+a
11 y= ex^4+dx^3+cx^2+bx+a
●
Parameters is either one argument (a list of the coeicients of the regression line), or the n
coeicients one after another.
HypZ1mean
The one-sample Z-test for a mean.
HypZ1mean( ,n,μ
0
,σ,α,mode,[”configuration”])
The input parameters can be a range reference, a list of cell references, or a simple list of values.
Mode: Species which alternative hypothesis to use:
●
1: μ < μ
0
●
2: μ > μ
0
●
3: μ ≠ μ
0
Conguration: a string that controls what results are shown and the order in which they appear. An empty
string "" displays the default: all results, including headers. The options in the conguration string are
separated by spaces.
●
h: header cells will be created
●
acc: the test result, 0 or 1 to reject or fail to reject the null hypothesis
●
tZ: the test Z-value
●
tM: the input value
●
prob: the lower-tail probability
●
cZ: the critical Z-value associated with the input α-level
●
cx1: the lower critical value of the mean associated with the critical Z-value
394 Chapter 22 Functions and commands
Komentarze do niniejszej Instrukcji