14) Write the Excel functions for the following: (5 Marks each) a. Give the total number of medals for Germany and Great Britain. b. Give the average number of silver medals for a European country, c. Sum the Medals Total for Gold for those countries with less than 20 games involvement. d. Search the database (the whole spreadsheet) to find ‘Italy’ and also the corresponding Medals Total.

The fraction of defective integrated circuits produced in a photolithography process is being studied. a random sample of 300 circuits is tested, revealing 17 defectives. (a) calculate a 95% two-sided confidence interval on the fraction of defective circuits produced by this particular tool. round the answers to 4 decimal places. less-than-or-equal-to p less-than-or-equal-to (b) calculate a 95% upper confidence bound on the fraction of defective circuits. round the answer to 4 decimal places. p less-than-or-equal-to

Which expression is equivalent to 16 in exponential form? a) 4 × 4 b) 8 × 2 c) 23 d) 24

In a singing competition, there are 150 participants. at the end of each round, 40% of the participants are eliminated. how many participants are left after n rounds?