0:01
hi everyone and welcome back to Exel
0:03
with in today's video I'm going to show
0:05
you how you can calculate 95% interval
0:14
Excel the first thing that you need to
0:16
do once you have your data click on data
0:23
tab on your right side of your Ribbon
0:25
you should find a data analysis or under
0:28
analyze and if you do not have this this
0:31
is what you should do click on file
0:36
options and a general click on add
0:39
ins and manage click on
0:43
go and then choose analysis two pack and
0:47
sure you also have your analysis T Pack
0:53
checked and then click on
0:58
okay once that that's done click on
1:02
data again and now click on data
1:05
analysis see it appears
1:26
now choose descriptive statistics and
1:29
and click on okay input range you need
1:38
weight the range of your weight and then
1:42
we the output options we need the output
1:46
range under the output range just select
1:51
one or two celles that you need your
1:53
information to be at and then under
1:56
confid confidence level for means
2:04
it and also ensure summary statistics is
2:08
checked so we can be able to see the
2:15
summaries once that's done click on
2:24
okay and as you can see here is our data
2:30
so we have our confidence level as
2:34
3.86 527 so if we'd like to calculate or
2:39
know the confidence interval the lower
2:55
interval and the upper
3:06
so for the lower confidence interval all
3:09
we do we have to just uh start with your
3:15
mean and then now subtract your
3:19
level and your lower confidence interval
3:26
65681 for the upper confidence interval
3:30
your mean sorry you have to start with
3:36
mean and then plus the confidence level
3:44
your your data is going to be range
3:49
57 kgs to 63 kgs and that's how you
3:55
calculate 95% confidence interval in
4:02
if you found this video helpful please
4:04
leave a comment down section and leave
4:07
us a thumbs up as well as subscribe and
4:10
ring the click on the notification Bell
4:13
so you could get more notifications as
4:15
we upload more videos and if you want a
4:18
specific videos for us to do please ask
4:20
in the comment section and we'll do it
4:23
otherwise thank you very much for always
4:24
watching to the end and see you again in
