Anitha
Last answered:

03 Jul 2022

 Posted on:

16 Apr 2021
3

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

in Statistics / Population variance known, z-score

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

2 answers ( 0 marked as helpful)
Ahmed AbouElhamayed
Posted on:

20 Nov 2021
0

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

Taiwo Alao
Posted on:

03 Jul 2022
0

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

CONFIDENCE

CONFIDENCE.T

CONFIDENCE.NORM

Submit an answer

related questions

Dylan Ritter
0
14
Standard deviation compared to Variance
Xiaoshi Tang
3
8
Population Variance - do we ever know this in real life?
Asmaa Abdulhamid
2
8
how to include both the interval start and end in the axis's name??? any help!!
Valerie Spitaels
1
6
Resolved: Calculating Variance
Sherine Chen
0
6
Resolved: why is the population mean, mu presented with sample mean here?
Maureen Njeri
0
6
The lower and higher interval bounds are repetitive and it's confusing to me
Anas Alkhaldi
0
6
Is it a must that the population sample has to be normally distributed to work with student T dist?
Lucia Indah Pramanti
0
6
Resolved: Hypothesis testing: P value or T/Z score
Salaheddine Hammou
0
6
sample variance
Sulthan ,
1
6
Resolved: Using Excel built-in CONFIDENCE() function to find the intervals
Sai Lalith Polawar
1
6
Regarding question no.5 in practice exam (Descriptive Statistics)
Uzair Mansoor
0
6
Resolved: population standard deviation