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

How has the start of this academic year been for you?

Loving it - gonna be a great year (138)
17.74%
It's just nice to be back! (209)
26.86%
Not great so far... (280)
35.99%
I want to drop out! (151)
19.41%

Watched Threads

View All