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.


Related 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
ADVERTISEMENT