Buisness Statistics

profilewinniekay90
black_8e_excel_problem_files_ch13.xlsx
Home>Mathematics homework help>Buisness Statistics

1

Y X1 X2
12 174 3
18 281 9
31 189 4
28 202 8
52 149 9
47 188 12
38 215 5
22 150 11
36 167 8
17 135 5

2

Y X1 X2 X3
114 21 6 5
94 43 25 8
87 56 42 25
98 19 27 9
101 29 20 12
85 34 45 21
94 40 33 14
107 32 14 11
119 16 4 7
93 18 31 16
108 27 12 10
117 31 3 8

5

Per Capita Paper Fish Gasoline
836 1 23 2
3145 85 53 394
21785 204 48 368
37931 250 141 447
276 4 12 16
1913 156 113 477
2195 19 65 43
3154 116 133 257
19539 207 44 460
109521 308 47 1624
622 27 40 528

6

Insider Ownership Debt Ratio Dividend Payout
8.2 14.2 10.4
18.4 20.8 14.3
11.8 18.6 12.1
28 18.5 11.8
7.4 28.2 10.6
15.4 24.7 12.6
15.7 15.6 12.6
18.4 21.7 7.2
13.4 23 11.3
18.1 46.7 4.1
10 35.8 9

11

Y X1 X2 X3
5.3 44 11 401
3.6 24 40 219
5.1 46 13 394
4.9 38 18 362
7 61 3 453
6.4 58 5 468
5.2 47 14 386
4.6 36 24 357
2.9 19 52 206
4 31 29 301
3.8 24 37 243
3.8 27 36 228
4.8 36 21 342
5.4 50 11 421
5.8 55 9 445

12

Y X1 X2
28 12.6 134
43 11.4 126
45 11.5 143
49 11.1 152
57 10.4 143
68 9.6 147
74 9.8 128
81 8.4 119
82 8.8 130
86 8.9 135
101 8.1 141
112 7.6 123
114 7.8 121
119 7.4 129
124 6.4 135

24

X1 X2 Y
29 1.64 198
71 2.81 214
54 2.22 211
73 2.7 219
67 1.57 184
32 1.63 167
47 1.99 201
43 2.14 204
60 2.04 190
32 2.93 222
34 2.15 197

25

Y X1 X2 X3
14 51 16.4 56
17 48 17.1 64
29 29 18.2 53
32 36 17.9 41
54 40 16.5 60
86 27 17.1 55
117 14 17.8 71
120 17 18.2 48
194 16 16.9 60
203 9 18 77
217 14 18.9 90
235 11 18.5 67

26

Gold Copper Silver Aluminum
161.1 64.2 4.4 39.8
308 93.3 11.1 61
613 101.3 20.6 71.6
460 84.2 10.5 76
376 72.8 8 76
424 76.5 11.4 77.8
361 66.8 8.1 81
318 67 6.1 81
368 66.1 5.5 81
448 82.5 7 72.3
438 120.5 6.5 110.1
382.6 130.9 5.5 87.8

27

Employment Naval Vessels Repairs or Conversions
133.4 108 431
177.3 99 1335
143 105 1419
142 111 1631
130.3 100 852
120.6 85 847
120.4 79 806

28

All Food Shelter Apparel Fuel Oil
0.9 1 2 1.6 3.7
0.6 1.3 0.8 0.9 2.7
0.9 0.7 1.6 0.4 2.6
0.9 1.6 1.2 1.3 2.6
1.2 1.3 1.5 0.9 2.1
1.1 2.2 1.9 1.1 2.4
2.6 5 3 2.5 4.4
1.9 0.9 3.6 4.1 7.2
3.5 3.5 4.5 5.3 6
4.7 5.1 8.3 5.8 6.7
4.5 5.7 8.9 4.2 6.6
3.6 3.1 4.2 3.2 6.2
3 4.2 4.6 2 3.3
7.4 14.5 4.7 3.7 4
11.9 14.3 9.6 7.4 9.3
8.8 8.5 9.9 4.5 12
4.3 3 5.5 3.7 9.5
5.8 6.3 6.6 4.5 9.6
7.2 9.9 10.2 3.6 8.4
11.3 11 13.9 4.3 9.2

29

Corn Soybeans Wheat
4152 1127 1352
6639 1798 2381
4175 1636 2420
7672 1861 2595
8876 2099 2424
8226 1940 2091
7131 1938 2108
4929 1549 1812
7525 1924 2037
7933 1922 2739

30

Grocery Items Housing Utilities Transportation Healthcare
108.3 106.8 127.4 89.1 107.5
96.3 105.2 98.8 100.9 102.1
96.2 88.8 115.6 102.3 94
98 83.9 87.7 97.4 94.9
106 114.1 108.1 112.8 111.5
103.1 117.3 127.6 107.8 100.8
94.5 88.5 74.6 93.3 102.4
105.4 98.9 108.9 110 106.8
91.5 108.3 97.2 105.9 114.3
94.3 95.1 111.4 105.7 96.2
102.9 94.6 90.9 104.2 91.4
96 99.7 92.1 102.7 97.4
96.1 90.4 96 106 96.1
89.8 92.4 96.3 95.6 93.6
93.2 88 91.7 91.6 82.3
103.3 211.3 75.6 102.1 128.5
94.6 91 79.4 102.4 88.4
99.1 86.2 91.1 101.1 85.5
100.3 123 125.6 104.3 137.8
92.8 112.3 105.2 106 107.5
99.9 81.1 104.9 102.8 92.2
95.8 107.7 91.6 98.1 90.9
104 83.4 122.2 98.2 87
98.2 79.4 103.4 97.3 97.1
95.7 98.7 96.3 104.6 115.2

31

Y X1 X2 X3
94 21 1 204
97 25 0 198
93 22 1 184
95 27 0 200
90 29 1 182
91 20 1 159
91 18 1 147
94 25 0 196
98 26 0 228
99 24 0 242
90 28 1 162
92 23 1 180
96 25 0 219