ExcelFlux

CONFIDENCE function

the confidence interval for a population mean.

Compatibility · Guided Excel example

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Find the normal-approximation margin in a legacy confidence-interval formula.

A worked example from the workbook

RowABC
6AlphaStandard deviationSample size
70.051025
80.11236
90.0139
Record 1
=CONFIDENCE(A7,B7,C7)

Illustrative output3.919927969

See the inputs and instructions for all 3 examples

Compatibility function for older workbooks.

Worked examples

Find the normal-approximation margin in a legacy confidence-interval formula.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A B C
6 Alpha Standard deviation Sample size
7 0.05 10 25
8 0.1 12 36
9 0.01 3 9
Trial Expression Sample output
Record 1 =CONFIDENCE(A7,B7,C7) 3.919927969
Record 2 =CONFIDENCE(A8,B8,C8) 3.289707254
Record 3 =CONFIDENCE(A9,B9,C9) 2.575829304
Microsoft Excel reference