In the movie industry, a firm producer wishes to investigate the relationship between the budget spent in making the movie and the amount of ticket sales in theatres. From seven randomly selected movies shown in the last two months at local theatres, their respective budgets (in RM' millions) and revenue (ticket sales) in theatres (in RM' millions) were recorded and indicated in the table below. Movie Movie Budget Ticket sale (RM 'millions) (RM' millions) A 62 65 B 90 64 C 50 48 D 35 57 E 200 600 F 100 146 G 94 47 (ii) Rank the above bivariate data in the same order and then compute Spearman's rank correlation coefficient. [8 marks] Interpret the result obtained. [5 marks] Test whether there is a significant correlation between the movie budget and ticket sales for all movies shown in the two months at local theatres. (Used =0.05) [15 marks] n = 7 observations from movie A to G [ Xi = 62 + 90 + 50 + 35 + 200 + 100 + 94 = 631 Population mean = X _ Exi 631 n 7 X = 90.143 E Yi = 65 + 64 + 48+ 57 + 600 + 146 + 47 = 1027 Population mean = y = Eri 1027 n 7 Y = 146.714 Variance = X = _(Xi-X)2 E(631-90.143)2 E(540.857)2 E 292526.294 n-1 7-1 6 6