I have no idea on how to solve this question. Any thorough response will be much appreciated.

Exerclse1 (32marks=4+4+14+5+5} A consultant wishes to know whether the proportion of innovative executives depends on whether the executives have a graduate diploma in business administration (GDBA), a master's degree in business administration (MBA), or do not hold any of these degrees in business administration (NODBA). He selects a random sample from each of the three populations of executives and anatyses the performance of every selected executive. 0n the basis of these analyses. the consultant categorizes each executive as innovative or not innovative. The resutls are as follows. Degree h Business Administration? Innovative? NDDBA GDBA MBA Yes 105 120 35 No 145 50 10 (a) There are two variables in this study, the performance of the executives (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 of variables are they and what are their levels of measurement? Explain your answers. (b) Assuming that these data had been generated by a proper multinomial experiment, which test can the consultant use to see whether the three populations of executives categorized by their qualications differ with respect to the proportion of innovative executives? Explain your choice. (c) Perform the test you chose in part {b} manually at the 5% signicance level. State the hypotheses. the decision rule. 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 a3e1' Excel le.1 Evaluate the test using the reported p-value this time. (e) What requirements must be met to validate the test in parts (:3) and (d)? Are they satised? Degree in Business Administration? Innovative? NODBA GDBA MBA Yes 105 120 35 No 145 50 10