Please help with c, d, e and f

achtract has its own populations, but all the tracts combined have an average population site 4 Note that the true mean and true standard deviation of the constract populations are based on all the rows in the data file s which has information about all of the census tracts in the United States tal) What is the population mean? 4226 091102 people 763] What is the population standard deviation ? 1981 883959 people 9 The bureau wants the ability to create accurate estimates of the average population site of its census tracts in the future o without having to conduct an expensive full cens during a non-cenus year 1 Instead, they want to perform population surveys over a sample of the constracts. 3 They want to ensure their estimate is accurate to within 110 people of the true mean con sus tract population, 4 with a confidence level of 81%. 6 We will use the current data to make estimates of how large these future samples would need to be to achieve their objectives 7 b) Estimate the necessary samplesien censustracts in order to convince the bureau that then you calculated would achieve the right level of accuracy, with the specified level of confidence, o create 32 simple random samples of sipen, and use the samples to create estimates of the population mean -1 , for each of these, create 2-sided confidence intervals in the following form and determine whether each interval estimate is successful -2 Brielly state how you can make those simple random samples 5 -6 -7 (d) Interval estimates (add rows as needed to enter all of your 32 interval estimates. You may select the bottom line of the table and drag & drop to add as many rows you want. - You should show all selected samples in the worksheet SRS and create interval estimates based on those samples -9 Confidence interval Sample Successful? 0 left bound right bound [Yes/No) (el What is the success rate for your 12 interval estimates? 1 12 2 About 81% of your confidence intervals should contain the true mean which you calculated above. Is this true? Disem 3 4 3 15 15 5 6 7 achtract has its own populations, but all the tracts combined have an average population site 4 Note that the true mean and true standard deviation of the constract populations are based on all the rows in the data file s which has information about all of the census tracts in the United States tal) What is the population mean? 4226 091102 people 763] What is the population standard deviation ? 1981 883959 people 9 The bureau wants the ability to create accurate estimates of the average population site of its census tracts in the future o without having to conduct an expensive full cens during a non-cenus year 1 Instead, they want to perform population surveys over a sample of the constracts. 3 They want to ensure their estimate is accurate to within 110 people of the true mean con sus tract population, 4 with a confidence level of 81%. 6 We will use the current data to make estimates of how large these future samples would need to be to achieve their objectives 7 b) Estimate the necessary samplesien censustracts in order to convince the bureau that then you calculated would achieve the right level of accuracy, with the specified level of confidence, o create 32 simple random samples of sipen, and use the samples to create estimates of the population mean -1 , for each of these, create 2-sided confidence intervals in the following form and determine whether each interval estimate is successful -2 Brielly state how you can make those simple random samples 5 -6 -7 (d) Interval estimates (add rows as needed to enter all of your 32 interval estimates. You may select the bottom line of the table and drag & drop to add as many rows you want. - You should show all selected samples in the worksheet SRS and create interval estimates based on those samples -9 Confidence interval Sample Successful? 0 left bound right bound [Yes/No) (el What is the success rate for your 12 interval estimates? 1 12 2 About 81% of your confidence intervals should contain the true mean which you calculated above. Is this true? Disem 3 4 3 15 15 5 6 7