00:01
Looks like you're trying to find how do you use excel to find a confidence interval for proportion population proportion and so yours is a 95 % confidence interval for a proportion so you can go to your excel spreadsheet let's say we have you know columns a, b, c, d, etc and and then we have our numbered lines along here for our rows.
00:36
And so let's say you enter in x, which is going to be the number of successes.
00:42
And let's say you enter in n, which will be the sample size.
00:46
And then you can calculate what your population proportion is, p hat, and then you can find its complement, one minus that answer.
00:57
And then you'll be able to get your critical value, and then you can find your margin of air, and then you'd be able to go through and calculate your intervals.
01:11
So let's say, for instance, again, i don't have your data here, but let's say you go and you enter in x into that, and let's say the number of successes is 405.
01:27
And let's say that the total number ended up being 700.
01:33
So the p hat would be to take your equals b1 divided by b2.
01:45
And then that would give you what the sample proportion is.
01:49
Then to find q, you would take one minus this cell, which is b3.
01:56
And that will give you that value.
02:00
Now, for 95 % confidence, you're going to use as critical value...