Apple Numbers '08 - Manual (Page 216)

216 Chapter 12 Dictionary of Functions
CONCATENATE
The CONCATENATE function joins (concatenates) strings.
CONCATENATE(string, [string, . . .])
 string: A string or a reference to a cell containing a string. To include a string in an
argument, place quotation marks around it.
Notes
You can also use the & operator to concatenate strings.
CONFIDENCE
The CONFIDENCE function returns a value for creating a statistical confidence interval
for a sample of a specified size from a population with a known standard deviation. The
confidence estimate assumes that values in the sample are normally distributed.
CONFIDENCE(alpha, stdev, size)
 alpha: The probability that the true population value lies outside the interval. So, 1
minus alpha is the confidence level that the true population value lies within the
interval centered on the sample value. An alpha of 0.05 corresponds to a confidence
level of 0.95, or 95%.
 stdev: The standard deviation of the population.
 size: The size of the sample.
Examples
If cell A1 contains Lorem and cell B1 contains Ipsum, CONCATENATE(B1,", ",A1) returns "Ipsum, Lorem".
CONCATENATE("a", "b","c") returns "abc".
"a"&"b"&"c" returns "abc".
Examples
CONFIDENCE(0.05, 1, 10) returns 0.62. If the mean of the sample values is 100, then with 95%
confidence the population mean falls in the range 99.38–100.62.
CONFIDENCE(0.1, 1, 10) returns 0.52. If the mean of the sample values is 100, then with 90%
confidence the population mean falls in the range 99.48–100.52.
CONFIDENCE(0.05, 1, 20) returns 0.44.
CONFIDENCE(0.05, 1, 30) returns 0.36.
CONFIDENCE(0.05, 1, 40) returns 0.31.