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

University open days

  • University of Stirling
    Undergraduate Open Day Undergraduate
    Thu, 26 Sep '19
  • Heriot-Watt University
    Undergraduate Open Day - Scottish Borders Campus Undergraduate
    Fri, 27 Sep '19
  • Royal Holloway, University of London
    Undergraduate open day Undergraduate
    Sat, 28 Sep '19

Are you attending a Global Climate Strike?

Yes, I'm striking (28)
6.71%
No, but I wanted to/I support the cause (244)
58.51%
No (145)
34.77%

Watched Threads

View All
Latest
My Feed