Help with the operations management question below. You can do it in excel and send me Google sheet link

Question 4 A local authority is considering whether to introduce a policy to get more householders rainwater storage installed. To help with the decision and design ofthe policy, the current situation needs to be quantied. It has conducted a pilot sampling program with the following results. A random selection of 40 residential properties were surveyed. They found that 13 had rainwater tanks installed with the following total capacities on each property. Capacity (Thousands of Litres) a) What are the 95% confidence limits to the estimate of the mean installed capacity of those households with tanks installed? b) How many residences would need to be surveyed to nd the mean installed capacity of those households with tanks installed, within plus or minus 10% and with 95% confidence in the result? c) What are the 95% confidence limits of the estimate of the percentage of households with tanks installed? d) Estimate the 95% confidence limits of the estimate of the percentage of households with tanks installed after the number in answer to b) above have been surveyed