You can use chi-squared tests to determine if hypothesized results are verified by an experiment. Returns the confidence interval for a population mean. The confidence interval is a range on either side of a sample mean. For example, if you order a product through the mail, you can determine, with a particular level of confidence, the earliest and latest dates the product should arrive. Alpha is the significance level used to compute the confidence level.
Size is the sample size.
Returns the correlation coefficient of the given arrays. Use the correlation coefficient to determine the relationship between two properties. For example, you can examine the relationship between a location's average temperature and the use of air conditioners. Array1 is an array or a cell range of values. Array2 is a second array or cell range of values.