Confidence Interval [SpreadSheet Probem]
Trying to find the right formulation to work out the confidence interval.
The data set is on the set and my solution for a 99% confidence interval for profits given the data is [£4,106.92. £19,351.08]
My question is do I input alpha as 0.05 as oppose to 0.1 on an excel spreadsheet to find a 99 confidence interval.
Formula for confidence range is in the input formula box above, to see what cells were used.
The data set is on the set and my solution for a 99% confidence interval for profits given the data is [£4,106.92. £19,351.08]
My question is do I input alpha as 0.05 as oppose to 0.1 on an excel spreadsheet to find a 99 confidence interval.
Formula for confidence range is in the input formula box above, to see what cells were used.
Original post by Abdul-Karim
Trying to find the right formulation to work out the confidence interval.
The data set is on the set and my solution for a 99% confidence interval for profits given the data is [£4,106.92. £19,351.08]
My question is do I input alpha as 0.05 as oppose to 0.1 on an excel spreadsheet to find a 99 confidence interval.
Formula for confidence range is in the input formula box above, to see what cells were used.
The data set is on the set and my solution for a 99% confidence interval for profits given the data is [£4,106.92. £19,351.08]
My question is do I input alpha as 0.05 as oppose to 0.1 on an excel spreadsheet to find a 99 confidence interval.
Formula for confidence range is in the input formula box above, to see what cells were used.
You should use alpha = 0.01 for a 99% confidence interval.
Quick Reply
Related discussions
- Edexcel A-level Statistics Paper 2 (9ST0 02) - 12th June 2023 [Exam Chat]
- How mathematical is business economics course?
- How to get faster at STEP?
- research analysis
- GSS Higher Statistical Officer Interview
- KS plot
- Engaa help plsss urgent!!
- OCR A-level Further Mathematics A Statistics (Y542) - 14th June 2023 [Exam Chat]
- Academic literacy
- Is it worth applying to imperial?
- Uni choices for psychology
- Stressed cos I can’t find a placement
- drawing error bars from standard deviation urgent!!
- Help urgent mathematics
- C2 trig changing the intervals
- Poisson process
- Access course
- MY journey to (hopefully) all nine's!! (●'◡'●)
- Where is offer spreadsheet for 2024
- further maths question
Latest
Trending
Last reply 3 days ago
Did Cambridge maths students find maths and further maths a level very easy?Last reply 2 weeks ago
Edexcel A Level Mathematics Paper 2 unofficial mark scheme correct me if wrongMaths
71
Trending
Last reply 3 days ago
Did Cambridge maths students find maths and further maths a level very easy?Last reply 2 weeks ago
Edexcel A Level Mathematics Paper 2 unofficial mark scheme correct me if wrongMaths
71
