Complete the following tasks in the https://tlc.trident.edu/content/enforced/153607-BUS520-2019DEC09FT-2/BUS520%20Module%202%20SLP.xlsx?_&d2lSessionVal=aW0LazZ3SY0KyZ9DgMH1ApWHc&ou=153607 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?