please help me do exercise 3.
This is the excel table data
Exercise 3 (45 marks = 6 + 9 + 16 + 12 + 2) Do firms of different asset sizes tend to have different production costs? To answer this question, an economics honours student took a random sample of 24 firms categorized by asset sizes as Small (assets between $10 and $19.9 millions of dollars), Medium (assets between $20 and $49.9 millions of dollars) or Large (assets equal to or above $50 millions of dollars) and recorded their production costs (Cost) per dollar of net sales. These data are saved in the a2e3.x/sx file. (a) (6 marks) On the basis of the research question, the experimental design, the type and the measurement scale of the variable of interest nominate two tests that could be used to find out whether the three types of firms differ in terms of their average or median production costs per dollar of net sales. Explain your choices. (b) (9 marks) What conditions are required to validate the tests you nominated in part (a)? Which of these conditions are likely satisfied this time? Explain your answer. (c) (16 marks) Suppose that you are assured that all the requirements you mentioned in part (b) are satisfied. Which of the two tests do you prefer in this case? Perform it with R/RStudio at the 1% significance level. State the hypotheses, report the observed test statistic, make a statistical decision, and draw a conclusion. (d) (12 marks) Perform the other test you nominated in part (a) with R/RStudio at the 1% significance level. State the hypotheses, report the observed test statistic, make a statistical decision, and draw a conclusion.(e) (2 marks) Compare your conclusions in parts (c) and (d). Does it really matter this time which of the two tests the economics honours student relies on? Explain your answer. Small Medium Large 69 75 83 72 70 77 72 80 80 66 74 74 76 68 86 72 80 75 70 72 85 72 76 80