Please solve this problem in excel and provide me with the codes and step by step directions so that I can simply copy and paste it into excel. Also, please show which collum/codes I need. Now here is the problem:

Directions:

AFC is interested in exploring the relationship between the number of visits (Q2), the importance of the reasons for participating in AFC programs (Q5), the likeliness of recommending (Q6), and revenues. Regress revenue on the six predictor or independent variables using the median to replace any missing data. Answer the questions below and upload the Excel file with the output and answers. Is there an overall statistically significant relationship between the set of predictors and the outcome variable? How much of the variance in the dependent variable can be explained by the combination of the predictor variables? Which of the variables are statistically significant predictors of revenues? For the significant predictors, how much does the revenue increase or decrease for every one-unit increase in the variable? What can you conclude from this analysis? and now here is the description: Statistical Tests: Use the AFC dataset to answer these questions:

Report the correlation between 'visits' and 'revenue'.

Interpret the meaning of the correlation coefficient. What is the t-stat for the correlation coefficient?

Do you reject the null hypothesis?

Create a cross-tabulation table between these two variables: 'wom' and 'weight'.

Calculate the Chi-square value and discuss the outcome.

Are these two variables independent?

Do you reject the null hypothesis?

Regress: 'daypart', 'age', 'gender', 'education' against 'revenue'.

Discuss the results. Using a sample of 200 individuals, researchers at a studio found out that the average satisfaction with a movie be 7.5 on a scale of 1 to 10. Standard Deviation of satisfaction was found to be 3.2. For a much larger sample, the average satisfaction was found to be 8.3. Find out if the sample average is different from global average. What is your null and alternative hypothesis? What is your conclusion? Do you reject the null?

Use the values in Table 1 to answer this question:

Week Sales (Units) 1 130

2 381

3 329

4 255 5

230

6

170 7

362

8 194

9 260

10 431

11 400

12 108

A company launched a product in a test market and recorded its weekly sales for 12 weeks. First column shows the week number and the second column has the corresponding sales in units. The management believes that if the average sales per week is more than 215, then they will launch the product nationally. Can you write the null and alternative hypothesis? What test can we use to reject the null? Run the test and interpret the results.