CONFIDENCE INTERVALS AND HYPOTHESIS TESTING Assume once again that you are a consultant who works for the Diligent Consulting Group. Assignment Expectations Complete the following tasks in the attached excel document assignment template: 1. Generate a 95% confidence interval for the following two variables by hand: “Annual Amount Spent on Organic Food” and “Age.” 2. Generate a 95% confidence interval for the following two variables using the Excel formula =CONFIDENCE.T(): Annual Income and Number of People in the Household. 3. Interpret the confidence intervals for each of the variables. 4. The client insists the average income of his organic food customers is $150,000. Conduct a hypothesis test at the 0.10 level to test his statement. What is your decision?
