Business Analytics and Decision Making Assignment

Please open the attached Excel Document and go through each tab to answer the questions.
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?
***Please make sure to show the work on the excel file that you send back*** Thank you

Please open the attached Excel Document and go through each tab to answer the questions.

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?
***Please make sure to show the work on the excel file that you send back*** Thank you

Please open the attached Excel Document and go through each tab to answer the questions.

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?
***Please make sure to show the work on the excel file that you send back