please help solve

provide an example of a marketing consequence (for a particular company or a group of co hypotheses. In the next step, you will conduct hypothesis tests with the available sample d: the results from your tests. Below I have provided step-by-step instructions. Getting started 1. You will use a copy of this file for your work and add tabs for your analysis. Start by savin name in the file name. You will upload the Excel file to allow the person who grades your w note that you can sort the data based on any of the variables. You will need to sort your da (grouping) variable in order to conduct your independent samples t-test analysis. Description of the data set The next tab includes a dataset with data for a range of different variables for 80 householc such as number of children in the household, to behavioral and spending patterns. Independent samples t-test 1. Review the variables in the dataset and select one grouping (independent) variable and c which you think it is reasonable to argue that the grouping variable affects the outcome vai there will be a difference in the means for the dependent variable between the two groups 2. Write an informal hypothesis that explains why this difference seems reasonable. 3. Explain why the hypothesis could be interesting to a company from a marketing standpo 4. Write a formal null and alternative hypothesis. 5. Make sure to add the data analysis package to your Excel if you haven't done that previo File Options Add-in Go Analysis toolPak OK Data Data Analysis 6. Instructions for how to complete a t-test in Excel is available in the week 13 folder and in recommend selecting the option of getting the results on a separate worksheet ply/tab. 7. Write an interpretation of the t-test test statistic generated through Excel (2-3 sentences that it is possible that you will not reject the null hypothesis based on the data. Chi-square test of independence: two categorical variables 1. Review the variables in the dataset and select two categorical variables that you think co reasonable to assume that the values on one of the variables will depend on the values of 2. Write an informal hypothesis that describes why the relationship between the variables 3. Explain why the hypothesis could be interesting to a company from a marketing standpo 4. Write a formal null and alternative hypothesis. 5. Use the pivot table function to create a cross-tab (contingency table) for your observed 6. Create a table for, and calculate, expected values. 7. Use the test option for chi-square under formulas/more functions. 8. Interpret the result generated through Excel (2-3 sentences will be sufficient). 9. The Chi-square test will be covered in class in week 14. ond Type of home Single-family home Condo/appartment Condo/appartment Single-family home Condo/appartment Single-family home Single-family, home Single-family home Single-family home Single-family home Condo/appartment Single-family home Condo/appartment Condo/appartment Condo/appartment Single-family home Single-family home Single-family home Condo/appartment Condo/appartment Single-family home Condo/appartment Single-family home Condo/appartment Condo/appartment Condo/appartment Single-family home Condo/appartment Single-family home Condo/appartment Single-family home Condo/appartment Single-family home Condo/appartment Single-family home Condo/appartment Single-family home Condo/appartment Single-family home Single-family home Single-family home Single-family home Condo/appartment Single-family home Condo/appartment Single-family home Condo/appartment Single-family home Condo/appartment Single-family home Single-family home Single-family home Condo/appartment Single-familyhome Single-family home Condo/appartment Single-family home Single-family home Condo/appartment Single-family home Condo/appartment Condo/appartment Condo/appartment Condo/appartment Single-family home Single-family home Single-family home Condo/appartment Single-family home Single-family home Condo/appartment Single-family home Single-family home Single-family home Condo/appartment Condo/appartment Condo/appartment Condo/appartment Single-family home Single-family home provide an example of a marketing consequence (for a particular company or a group of co hypotheses. In the next step, you will conduct hypothesis tests with the available sample d: the results from your tests. Below I have provided step-by-step instructions. Getting started 1. You will use a copy of this file for your work and add tabs for your analysis. Start by savin name in the file name. You will upload the Excel file to allow the person who grades your w note that you can sort the data based on any of the variables. You will need to sort your da (grouping) variable in order to conduct your independent samples t-test analysis. Description of the data set The next tab includes a dataset with data for a range of different variables for 80 householc such as number of children in the household, to behavioral and spending patterns. Independent samples t-test 1. Review the variables in the dataset and select one grouping (independent) variable and c which you think it is reasonable to argue that the grouping variable affects the outcome vai there will be a difference in the means for the dependent variable between the two groups 2. Write an informal hypothesis that explains why this difference seems reasonable. 3. Explain why the hypothesis could be interesting to a company from a marketing standpo 4. Write a formal null and alternative hypothesis. 5. Make sure to add the data analysis package to your Excel if you haven't done that previo File Options Add-in Go Analysis toolPak OK Data Data Analysis 6. Instructions for how to complete a t-test in Excel is available in the week 13 folder and in recommend selecting the option of getting the results on a separate worksheet ply/tab. 7. Write an interpretation of the t-test test statistic generated through Excel (2-3 sentences that it is possible that you will not reject the null hypothesis based on the data. Chi-square test of independence: two categorical variables 1. Review the variables in the dataset and select two categorical variables that you think co reasonable to assume that the values on one of the variables will depend on the values of 2. Write an informal hypothesis that describes why the relationship between the variables 3. Explain why the hypothesis could be interesting to a company from a marketing standpo 4. Write a formal null and alternative hypothesis. 5. Use the pivot table function to create a cross-tab (contingency table) for your observed 6. Create a table for, and calculate, expected values. 7. Use the test option for chi-square under formulas/more functions. 8. Interpret the result generated through Excel (2-3 sentences will be sufficient). 9. The Chi-square test will be covered in class in week 14. ond Type of home Single-family home Condo/appartment Condo/appartment Single-family home Condo/appartment Single-family home Single-family, home Single-family home Single-family home Single-family home Condo/appartment Single-family home Condo/appartment Condo/appartment Condo/appartment Single-family home Single-family home Single-family home Condo/appartment Condo/appartment Single-family home Condo/appartment Single-family home Condo/appartment Condo/appartment Condo/appartment Single-family home Condo/appartment Single-family home Condo/appartment Single-family home Condo/appartment Single-family home Condo/appartment Single-family home Condo/appartment Single-family home Condo/appartment Single-family home Single-family home Single-family home Single-family home Condo/appartment Single-family home Condo/appartment Single-family home Condo/appartment Single-family home Condo/appartment Single-family home Single-family home Single-family home Condo/appartment Single-familyhome Single-family home Condo/appartment Single-family home Single-family home Condo/appartment Single-family home Condo/appartment Condo/appartment Condo/appartment Condo/appartment Single-family home Single-family home Single-family home Condo/appartment Single-family home Single-family home Condo/appartment Single-family home Single-family home Single-family home Condo/appartment Condo/appartment Condo/appartment Condo/appartment Single-family home Single-family home