3.10 The following data give the 2014 profits (in millions of dollars) of the top 10 companies listed in the 2014 Fortune 500 (source: www.fortune.com). 2014 Profits Company Wal-Mart Stores Exxon Mobil Chevron Berkshire Hathaway Apple Phillips 66 General Motors Ford Motor General Electric Valero Energy (millions of dollars) 16,022 32,580 21,423 19,476 37,037 3726 5346 7155 13,057 2720 Find the mean and median for these data. Do these data have a mode? Explain
putting above data in ascending order:
| s. no | x |
| 1 | 2720 |
| 2 | 3726 |
| 3 | 5346 |
| 4 | 7155 |
| 5 | 13057 |
| 6 | 16022 |
| 7 | 19476 |
| 8 | 21423 |
| 9 | 32580 |
| 10 | 37037 |
mean =total/n= 158542/10=15854.2
median =middle value =(13057+16022)/2=14539.5
there is no mode as all values appears only once; therefore there is no value is most frequent,
3.10 The following data give the 2014 profits (in millions of dollars) of the top 10...
Revenues for the top Global 500 companies in 2014 Revenues Company Name Wal-Mart Stores Sinopec Group Revenues (Sb) 181.2 172.3 Company Name 485.7 McKesson 446.8 Daimler 431.3 ndustrial Commercial Bank o Royal Dutch Shell China National Petroleunm ExxonMobil BP State Grid Volkswagen Toyota Motor Glencore Total Chevron Samsung Electronics 195.8 Berkshire Hathaway Apple 163.2 China 428.6 Exor Group 382.6 AXA 58.7 General Motors 339.4 E.On 268.6 Phillips 66 247.7 General Electric 221.0 ENI 212.0 Gazprom 203.8 Ford Motor 162.1 161.2...
Rank
Company Name
Return
1
Apple
14.8
2
Amazon.com
29.8
3
Google
49.3
4
Berkshire Hathaway
11.7
5
Starbucks
27.1
6
Coca-Cola
1.4
7
Walt Disney
33.8
8
FedEx
24.4
9
Southwest Airlines
84.5
10
General Electric
12.3
11
American Express
39.6
12
Costco Wholesale
8.1
13
Nike
32.8
14
BMW
15.1
15
Procter & Gamble
4.1
16
IBM
-12.4
17
Nordstrom
5.8
18
Singapore Airlines
-13.9
19
Johnson & Johnson
20.5
20
Whole Foods Market
13
21
Samsung Electronics...
1. Calculate the mean and standard deviation for each variable
using formulas or functions. 2. Calculate descriptive statistics
for each variable using the Analysis Toolpak. 3. Calculate the
coefficient of variation for each variable. What general
interpretation can you make from these values? 4. Calculate the
correlation between Revenue and Employees using a formula.
Calculate the coefficient of determination. 5. Create a correlation
matrix for the eight numerical variables. Note any relationship of
interest
Rank
COMPANY NAME
City
State
Revenue...