Question

how can I calculate the confidence interval and it's coefficient from a data set?? also using excel thank you.

Answer 1

Confidence Interval Excel Formula

=CONFIDENCE(alpha,standard_dev,size)

The CONFIDENCE function uses the following arguments:

1. Alpha (required argument) – This is the significance level used to compute the confidence level. The significance level is equal to 1– confidence level. So, a significance level of 0.05 is equal to a 95% confidence level.
2. Standard_dev (required argument) – This is the standard deviation for the data range.
3. Size (required argument) – This is the sample size.