Question

Please explain using EXCEL function

Solve the confidence intervals for proportion, proportion with correction factor, and standard deviation

2.         Confidence Interval for a Proportion using the Correction Factor?

A retailer in Singapore has monitored a random sample of 500 customers who have viewed the firm’s website on a certain day and found that 380 of them purchased at least one item.   So, first, calculate the sample proportion of those who visited the website and purchased at least one item. Knowing that website has on average 10,000 views per day, the retailer would like to know how reliable of an estimate your calculated sample proportion is. So do her a favor and prepare the relevant confidence interval with a probability content of 95%, rounding to 3 digits.

Answer 1