Ive been stuck on this question for some time. Can someone help thanks. Answers will be rated immediately:)

Exercise1 {32mark5=4+4+14+5+5} A consultant wishes to lcnow whether the proportion ot innovative executives depends on whether the executives have a graduate (iploma in business administration {GDBA}, a master's degree in business administration (MBA), or do not hold any of these degrees in business adn'l'nistration {NODBA} He selects a random san'ple from each of the three populations of executives and analyses the performance ot every selected exeurtive. On the basis ot these analyses, the consultant categorizes each executive as innovative or not innovative. The results are as follows. Degree'l'l Business Adrr'misn'atim'.' Innovative? NODBA GDBA MB" YES 105 120 35 N0 145 50 10 {a} There are two variables in this study, the performance of the executive; [innovative or not} and whether an executive has a graduate diploma in business administration, a master's degree in business administration, or none. What type ot variables are they and what are their levels ot measurement? Explain your answers. {b} Assun'l'ng that these data had been generated by a proper multinornial experiment, which test can the consultant use to see whether the three populations of exemtives categorized by their qualications dilfer with respect to the proportion of innovative executives? Explain your choice. (c) PerlonTI the test you chose in part [b] manually at the 5% sig'ii'licance level. State the hypotheses, the decision mle, calculate the test statistic showing the details of your calculations, make a statistical decision with reference to the proper critical value and draw your conclusion. Based on the relevant critical value table, what can you tell about the p-value of your test? (d) Repeat the test you performed in part (c) with R. The contingency table is saved in the 3391 Excel le.' Evaluate the test using the reported pvalue this time. (e) What requirements must be met to validate the test in parts (c) and (d)? Are they satised?