The FBI wants to determine the effectiveness of their 10 Most Wanted list. To do so, they need to find out the fraction of people who appear on the list that are actually caught.

Step 1 of 2:

Suppose a sample of 782 suspected criminals is drawn. Of these people, 234 were captured. Using the data, estimate the proportion of people who were caught after being on the 10 Most Wanted list. Enter your answer as a fraction or a decimal number rounded to three decimal places.

Step 2 of 2:

Suppose a sample of 782 suspected criminals is drawn. Of these people, 234 were captured. Using the data, construct the 98% confidence interval for the population proportion of people who are captured after appearing on the 10 Most Wanted list. Round your answers to three decimal places.

If this can be calculated in excel, can you include a screenshot of the formulas?