Please use excel and please put the step-by-step on how to input the data. Thank you

3) The following ficticious sample data shows annual income figures, in thousands of Euros, 3) categorized according to the two factors of gender and level of education. State the assumptions that must hold for Two-Way ANOVA to be applicable towards this data set. Assuming that all assumptions to conduct a Two-Way ANOVA hold, perform a Two-Way ANOVA using a significance level of 0.05. Show all work (If you use any technology in your solution (TI-84, excel, SPSS, minitab, etc...), cite when/where.). Does your analysis indicate a significant interaction effect between the variables gender and level of education (on annual income figures)? If NO, then do gender or level of education alone have significant effects on annual income figures? Justify your answers. Female Male High school 23, 27, 24, 26 25, 26, 22, 24 College 28, 36, 31, 33 35, 32, 39, 28 41, 38, 43, 35, 50, 47, 44 State the assumptions required to perform a x2 test for a difference between two population proportions. For the provided data set, assume that all such assumptions hold (verify them where possible.). Perform a x2 test for a difference between the the population proportions of drug recipients who get headaches and placebo recipients who get headaches. State the null and alternative hypotheses for this test. Show all work in the computation of the test statistic. State the conclusion of this investigation. 4) Below is a 2x2 contingency table / frequency distibution. Drug Placebo Headaches 11 No headaches 73 91 State the assumptions required to perform a Wilcoxon rank-sum test for a difference between two population medians. For the provided data set, assume that all such assumptions hold (verify them where possible.). 5) A person who commutes to work is choosing between two different routes. He tries the 5) first route 11 times and the second route 12 times and records the commute time of each trip. The results (in minutes) are shown below. Use a significance level of 0.01 and a suitable formulation of the Wilcoxon rank-sum test to test the claim that the population median commute time from Route 2 is longer than the population median commute time from Route 1. State the null and alternative hypotheses for this test. Show all work in the computation of the test statistic. State the conclusion of this investigation. Route 1 Route 2 35 42 41 41 46 38 33 48 40 49 53 36 39 50 46 51 57 53 36 40 45 50 55