[]

Document Solutions for Excel, .NET Edition Overview
Key Features
Getting Started
Features
Templates
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
  - BETADIST
  - BETAINV
  - BINOMDIST
  - CHIDIST
  - CHIINV
  - CHITEST
  - CONFIDENCE
  - COVAR
  - CRITBINOM
  - EXPONDIST
  - FDIST
  - FINV
  - FLOOR
  - FTEST
  - GAMMADIST
  - GAMMAINV
  - HYPGEOMDIST
  - LOGINV
  - LOGNORMDIST
  - MODE
  - NEGBINOMDIST
  - NORM.INV
  - NORMDIST
  - NORMSDIST
  - NORMSINV
  - PERCENTILE
  - PERCENTRANK
  - POISSON
  - QUARTILE
  - RANK
  - STDEV
  - STDEVP
  - TDIST
  - TINV
  - TTEST
  - VAR
  - VARP
  - WEIBULL
  - ZTEST
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometry Functions
- Statistical Functions
- Text Functions
- Web Functions
File Operations
Document Solutions Data Viewer
API Reference
Release Notes

CONFIDENCE

This function returns the confidence interval for a population mean.

Syntax

CONFIDENCE(alpha, stdev, size)

Arguments

This function has these arguments:

Argument	Description
alpha	[Required] The significance level used to calculate the confidence level. The confidence level equals 100 * (1 - alpha)%
stdev	[Required] Population standard deviation for the range
size	[Required] Number representing the size of the sample; if not an integer, the number is truncated

Examples

CONFIDENCE(0.5,B4,D5)

CONFIDENCE(0.5,R4C2,R5C4)

CONFIDENCE(0.05,3.5,150) gives the result 0.560106363