Apple numbers User Manual

    Dictionary of Functions 

 

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.
  

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.

  

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".

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.