Question

The following table is of​ profit, revenue, and number of employees of 10 companies.

UUWy avie iS vi proImM, Teveliue, anu numibei oi epioyees u u cUMpales. Profit US $ billion Revenuelemployee USS No. of Employees 11.6 Exxon 96,170 122700 Royal Dutch 7.8 74,284 105100 70,856 British Petroleum 4.1 56470 Petrofina SA 2.8 67,393 69062 Texao In 3.1 92,103 29318 Elf Aquitaine 0.97 11,461 83600 ENI 3.2 37,415 80177 Chevron Corp 3.2 84,621 39364 PDVSA 4.7 84,820 56594 SK 0.12 4,086 30596 a) For the 10 companies, the mean profit per company is S (Round answer to one decimal place.) billion US b) The "overall" mean revenue per employee (i.e., for all employees of these firms combined) of the 10 companies is S US (Round answer to nearest whole number.) US/employee c) The "overall" mean profit per employee is $ (Round answer to nearest whole number.)

Answer 1

Page Layout File Formulas Developer Add-ins Help Tell me what you want to do Home Insert Data Review View AutoSum A Cut ab Wrap Text Minion Pro 11 A A General Fill Copy Paste Conditional Insert Delete Format BIU A t & Find & Merge & Center as Clear Format Painte Formatting Iter Select Styles Clipboard Number Styles Editing Font Alignment Cells I18 > H T I A Profit US $ billionRevenue/employee US SNo. of Employees Revnue Revenue/employee US $ No. of Employees Revnue( USS Billion) 2 Company 11800059000-96170 122700 122700 3 11.6 96170 11.8 7,8 74284 105100 7807248400 4 56470 5 4.1 70856 4001238320 4.0 69062 6 2.8 67393 4654295366 4.7 29318 7 3.1 92103 2700275754 2.7 0.97 1146 83600 958139600 .0 80177 3.2 37415 2999822455 3.2 39364 84621 3331021044 4800303080 1 4.7 84820 56594 4 8 30596 0.12 125015256 2 4086 10 0.1 41.6 672981 43177418275 3 43.2 4 5 A) Mean profit -AVERAGE(E3:B12) 6 4.2 -H13 / G13 B) Overall mean revenue 64158.5 C) Overall mean profit Total profit Total= 41.6 billion / 672981 US/employee 61814.5 2