Confidence Intervals and Hypothesis Testing

Confidence Intervals and Hypothesis Testing Assume once again that you are a consultant who works for the Diligent Consulting Group. You are continuing to work on the analysis of the customer database from Module 1. SLP Assignment Expectations Complete the following tasks in the Module 2 SLP assignment template: Generate a 95% confidence interval for the following two variables by hand: “Annual Amount Spent on Organic Food” and “Age.” 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. Interpret the confidence intervals for each of the variables. 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?