Confidence Interval [SpreadSheet Probem] Watch

gr8wizard10
Badges: 21
Rep:
?
#1
Report Thread starter 4 years ago
#1
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.
0
reply
Doctor_Einstein
Badges: 18
Rep:
?
#2
Report 4 years ago
#2
(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.
You should use alpha = 0.01 for a 99% confidence interval.
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

University open days

  • Cardiff Metropolitan University
    Undergraduate Open Day - Llandaff Campus Undergraduate
    Sat, 19 Oct '19
  • Coventry University
    Undergraduate Open Day Undergraduate
    Sat, 19 Oct '19
  • University of Birmingham
    Undergraduate Open Day Undergraduate
    Sat, 19 Oct '19

Why wouldn't you turn to teachers if you were being bullied?

They might tell my parents (11)
5.95%
They might tell the bully (19)
10.27%
I don't think they'd understand (32)
17.3%
It might lead to more bullying (70)
37.84%
There's nothing they could do (53)
28.65%

Watched Threads

View All