CONFIDENCE Function in Excel: Syntax, Examples and Free Practice
CONFIDENCE is an Excel Compatibility function. Legacy confidence interval formula — kept for compatibility with older files.
CONFIDENCE syntax
Arguments
alpha: A shape parameter of the distributionstandard_dev: The standard deviation of the distributionsize: The sample size
When to use CONFIDENCE
CONFIDENCE is kept mainly for opening older files built in earlier versions of Excel.
Practice CONFIDENCE online, free
Open the live Excel-style spreadsheet and try CONFIDENCE yourself. No Excel install or sign-up needed to start.
Practice CONFIDENCE now →More Compatibility functions
- BETADIST
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- COVAR
- CRITBINOM
- EXPONDIST
- FDIST
- FINV
- FTEST
- GAMMADIST
- GAMMAINV
- HYPGEOMDIST
Frequently asked questions
What does the CONFIDENCE function do in Excel?
Legacy confidence interval formula — kept for compatibility with older files.
What is the syntax of CONFIDENCE in Excel?
The syntax is =CONFIDENCE(alpha, standard_dev, size). alpha: A shape parameter of the distribution; standard_dev: The standard deviation of the distribution; size: The sample size.
Where can I practice CONFIDENCE online for free?
Open the free live spreadsheet on Cellgrids and try CONFIDENCE yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Compatibility functions · Excel case studies · Excel tutorials · Excel shortcuts