https://docs.google.com/spreadsheets/d/1CAFd-9h7nq8edtjalOiK2DLOkF9Qh-Pm/edit?usp=sharing&ouid=107720906726785495549&rtpof=true&sd=true

The file has 10013 records of customers for a credit card company. The fields with the red font indicate inaccuracy based on some matching and data integrity criterion. Using the RAND () function take a sample of 50 records. Sheet 2 should contain your sampled data

1. Find the Confidence Interval estimation for the mean of the population (U)

of number of errors / record, with 95% confidence level.

Standard Error(show the equation) and the value
Value of Z or T
Lower Interval
Upper Interval
Conclusion

Use the result of part (a) to calculate a new sample size if the band (margin of error) is to be 50% of margin of error in part (a)? 25% of margin of error in part (a)? Assume a 95% confidence level. Do not take a new sample: only calculate them

25%
50%

Find the Confidence Interval estimation for the mean of the population (u) of credit limit for the customer. Assume a 95% confidence level

Standard Error(show the equation) and the value
Value of Z or T
Lower Interval
Upper Interval
Conclusion