Confidence interval (Regarding population-variance-known-z-score lesson)

Question

Is there formula in excel to find out the confidence interval or should we do it manually only

Answer 1

I'm using LibreOffice Calc and I found this:
CONFIDENCE.NORM(alpha, StandardDeviation, SampleSize) for normal distribution
and
CONFIDENCE.T(alpha, StandardDeviation, SampleSize) for Student's T distribution

I believe Confidence exists in Excel as well: https://support.microsoft.com/en-us/office/confidence-function-75ccc007-f77c-4343-bc14-673642091ad6

Answer 2

Please try the following in excel based on what you're working on:

CONFIDENCE

CONFIDENCE.T

CONFIDENCE.NORM

Confidence interval (Regarding population-variance-known-z-score lesson)

Submit an answer

related questions