Question
In: Math
While using crunchit/ excel/ software of your choose how do you find a confidence interval when...
While using crunchit/ excel/ software of your choose how do you
find a confidence interval when your variables are in words? i have
a list of over 300 patients who are positive or negative for
influenza and I'm not sure how to solve!
Solutions
Expert Solution
As the list is not furnished, I just take a sample of my own. The "POSITIVE" response are replaced by 1 and the "NEGATIVE" response are replaced by 0. This is done in Excel with the formula
=IF(A2="positive",1,0) in cell B2
=IF(A3="positive",1,0) in cell B3
select both the cells and drag it down to B301.
| Response | Response(converted) |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
| positive | 1 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| negative | 0 |
| positive | 1 |
| positive | 1 |
Now the counts of positive and negative responses are made.
The counts for positive response are obtained by the formula
=countif(b2:b301,1)
The counts for negative response are obtained by the formula
=countif(b2:b301,0)
Now the corresponding proportions of the responses are counted.
This is made by dividing the corresponding cell in which the count is stored by 300(total number of observations).
Now the 80% CV is calculated by the following formula
=NORM.INV(0.9,0,1)
The standard error is calculated by the formula
=SQRT(F11*F12/F8)
where F11 is the proportion of positive responses
F12 is the proportion of negative responses
F8 is the total number of observations=300
The margin of error is calculated by
=F14*F15
where F14 is 80% CV
F15 is the standard error
The upper confidence interval is calculated by the sum of the proportion of the positive responses and the margin of error.
The lower confidence interval is calculated by the difference of the proportion of the positive responses and the margin of error.
Hence the confidence interval is
(0.3933691,0.4666309)
A screenshot of the excel sheet is attached for betterment of understanding.
In case of any query, do comment. If this helps, give a thumbs up. Thanks.
milcah answered 2 months agoRelated Solutions
Using, Microsoft Excel, how do you construct a 95% confidence interval for the difference in means?...
Using, Microsoft Excel, how do you construct a 95% confidence
interval for the difference in means?
I have two extremely long lists of numbers and need someone to
explain the process.
How do you find a 99% Confidence Interval when given the average and the standard deviation?...
How do you find a 99% Confidence Interval when given the average
and the standard deviation? STD=8.54 AVG=66.43
Distinguish between point estimate and confidence interval. How do you construct confidence interval when population SD...
Distinguish between point estimate and
confidence interval. How do you construct confidence interval when
population SD is known and unknown?
how do I find the confidence interval for the median of a population?
how do I find the confidence interval for the median of a
population?
how do you calculate 95% confidence interval using population variance
how do you calculate 95% confidence interval using population
variance
What is Mirr? how do you find it using excel without using excel formula? Below is...
What is Mirr? how do you find it using excel without using excel
formula?
Below is cash flow. I found IRR is 15.59% and required return is
12%
CF
Y0
Y1
Y2
Y3
Y4
Y5
Y6
Capital spen
$ (30,000,000.00)
$ 15,062,400.00
Opp cost
$ (5,000,000.00)
NWC
$ (1,120,000.00)
$ (150,000.00)
$ (170,000.00)
$ 140,000.00
$ 1,300,000.00
OCF
$ 9,015,600.00
$ 11,392,500.00
$ 12,193,200.00
$ 10,435,800.00
$ (2,640,000.00)
$ (3,960,000.00)
CF
$ (36,120,000.00)
$ 8,865,600.00
$ 11,222,500.00
$ 12,333,200.00
$...
How do I find the lower limit of a confidence interval using a z-table. Having trouble...
How do I find the lower limit of a confidence interval using a
z-table. Having trouble understanding where the 1.645 number came
from in this solution
Sample proportion {p} = 367 / 561 = 0.654 Lower limit for 95%
confidence interval is {p} - Z\alpha * sqrt( {p} ( 1 - {p} ) / n) =
0.654 - 1.645 * sqrt( 0.654 * 0.346 / 561) = 0.617
What is the benefit of using a confidence interval? What exactly does a confidence interval do...
What is the benefit of using a confidence interval? What exactly
does a confidence interval do that a P value does not? I need this
to be clear because I am so confused.
Give an example of a confidence interval for the mean of a population when you do...
Give an example of a confidence interval for the mean of a
population when you do not know the population standard deviation
by describing the population, the variable, and how you would go
about finding the interval. You may want to mention a sample size,
a confidence level, and a possible interval.
How do I find the margin of error with a 98% confidence interval estimate of the...
How do I find the margin of error with a 98% confidence interval
estimate of the population mean sales price and population mean
number of days to sell for Domestic cars?
For Domestic Cars
Statistics
List Price
Sale Price
Days to Sell
N
Valid
200
200
200
Missing
0
0
0
Mean
32.1615
29.7430
32.9050
Median
29.5500
27.5500
31.0000
Std. Deviation
18.31094
18.25088
17.86735
Range
75.00
74.60
69.00
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- urgent please, in operating system: One simple method to protect a critical section is to use...
- Andretti Company has a single product called a Dak. The company normally produces and sells 120,000...
- A projectile is fired from ground level at an angle of 63 degree above the horizontal...
- Find and share an advertisement that looks interesting and persuasive. Describe why you pick up the...
- Why are grammatical mistakes that all children make as they acquire language important to psycholinguistics? What do...
- Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income...
- Problem 5-22 Yield to Maturity and Yield to Call Arnot International's bonds have a current market...
ADVERTISEMENT