STDEV function - Microsoft Support
Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
STDEVA function - Microsoft Support
This article describes the formula syntax and usage of the STDEVA function in Microsoft Excel. Description. Estimates standard deviation based on a sample. The standard deviation is a …
CONFIDENCE function - Microsoft Support
Returns the confidence interval for a population mean, using a normal distribution. The confidence interval is a range of values. Your sample mean, x, is at the center of this range and the range …
STDEV.P function - Microsoft Support
STDEV.P uses the following formula: where x is the sample mean AVERAGE(number1,number2,…) and n is the sample size.
STDEV.S function - Microsoft Support
Estimates standard deviation based on a sample (ignores logical values and text in the sample). The standard deviation is a measure of how widely values are dispersed from the average …
CONFIDENCE.NORM function - Microsoft Support
Returns the confidence interval for a population mean, using a normal distribution. Description. The confidence interval is a range of values. Your sample mean, x, is at the center of this …
VAR.S function - Microsoft Support
Estimates variance based on a sample (ignores logical values and text in the sample). Syntax. VAR.S(number1,[number2],...) The VAR.S function syntax has the following arguments: …
Z.TEST function - Microsoft Support
Returns the one-tailed P-value of a z-test. For a given hypothesized population mean, x, Z.TEST returns the probability that the sample mean would be greater than the average of …
VAR function - Microsoft Support
VAR uses the following formula: where x is the sample mean AVERAGE(number1,number2,…) and n is the sample size.
Statistical functions (reference) - Microsoft Support
Lists all statistical functions, such as the AVERAGE, COUNTBLANK, and MEDIAN functions.
ZTEST function - Microsoft Support
Returns the one-tailed probability-value of a z-test. For a given hypothesized population mean, μ0, ZTEST returns the probability that the sample mean would be greater than the average of …