Apple Numbers '08 Manual de usuario descargar pdf (Pagina 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.

1 2 ... 211 212 213 214 215 216 217 218 219 220 221 ... 294 295

Sin comentarios

Apple Numbers '08 Manual de usuario Pagina 216