EXCEL FORMULAS PLEASE ONLY EXCEL

This dataset shows a sample of customers' orders from AJ Madison, an online retailer of electronic appliances. a) Calculate a 95% confidence interval for the proportion of all customers whose total cost is more than $100. b) Calculate a 99% confidence interval for the mean total cost for NorthEast Transactions. This dataset shows a sample of customers' orders from AJ Madison, an online retailer of electronic appliances. a) Calculate a 95% confidence interval for the proportion of all customers whose total cost is more than $100. b) Calculate a 99% confidence interval for the mean total cost for NorthEast Transactions