Refer to the Excel file Pallet (attached to the assignment) to address all the questions below: The file contains the weight in pounds from a sample of 368 pallets of

Refer to the Excel file Pallet (attached to the assignment) to address all the questions below: The file contains the weight in pounds from a sample of 368 pallets of Boston shingles and 330 pallets of Vermont shingles. For the Boston shingles, construct a 95% confidence interval for the mean weight. For the Vermont shingles, construct a 95% confidence interval estimate for the mean weight. Do you think the assumptions needed to construct the confidence interval estimates in 1 and 2 are valid? Based on the results of 1 and 2, what conclusions can you reach concerning the mean weight of the Boston and Vermont Shingles? Refer to the Excel file InsuranceClaims for the assignment below: The files contains data for 90 randomly selected auto injury claims. Construct a 95% confidence interval for the population proportion of all auto injury files that have exaggerated loss amounts. Construct a 95% confidence interval for the population mean dollar excess payment amount.