Buisness Statistics

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

1

X Y
4 18
6 12
7 13
11 8
14 7
17 7
21 4

2

x y
158 349
296 510
87 301
110 322
436 550

3

Delta Southwest
47.6 15.1
46.3 15.4
50.6 15.9
52.6 15.6
52.4 16.4
52.7 18.1

4

Claims Surplus
1425 277
273 100
915 120
1687 259
234 40
142 25
259 57
258 31
894 141

5

Year 1 Year 2 Year 3
0.46 0.48 0.69
0.52 0.62 0.63
0.9 0.72 0.81
1.5 1.74 2.1
2.89 2.03 2.46
1.8 1.92 2
3.29 3.18 3.17
5.73 4.43 4

6

x y
12 17
21 15
28 22
8 19
20 24

7

X Y
140 25
119 29
103 46
91 70
65 88
29 112
24 128

8

Advertising Sales
12.5 148
3.7 55
21.6 338
60 994
37.6 541
6.1 89
16.8 126
41.2 379

9

Bond Rate Prime Interest Rate
5 16
12 6
9 8
15 4
7 7

10

Bankruptcies Firm Births
34.3 58.1
35 55.4
38.5 57
40.1 58.5
35.5 57.4
37.9 58

11

Number Size
5.65 213
4.65 258
3.96 297
3.36 340
2.95 374
2.52 420
2.44 426
2.29 441
2.15 460
2.07 469
2.17 434
2.1 444
2.19 419

12

Production New Orders
99.9 2.74
97.9 2.87
98.9 2.93
87.9 2.87
92.9 2.98
97.9 3.09
100.6 3.36
104.9 3.61
105.3 3.75
108.6 3.95

13

x y
15 47
8 36
19 56
12 44
5 21

14

x y
12 17
21 15
28 22
8 19
20 24

15

X Y
140 25
119 29
103 46
91 70
65 88
29 112
24 128

16

Advertising Sales
12.5 148
3.7 55
21.6 338
60 994
37.6 541
6.1 89
16.8 126
41.2 379

17

Bond Rate Prime Interest Rate
5 16
12 6
9 8
15 4
7 7

18

Bankruptcies Firm Births
34.3 58.1
35 55.4
38.5 57
40.1 58.5
35.5 57.4
37.9 58

20

Cost Distance
2.64 1245
2.31 425
2.45 1346
2.52 973
2.19 255
2.55 865
2.4 1080
2.37 296

21

X Residual
213 -11
216 -5
227 -2
229 -1
237 6
247 10
263 12

22

X Residual
10 6
11 3
12 -1
13 -11
14 -3
15 2
16 5
17 8

31

Sales Volume
10.5 728.6
48.1 497.9
64.8 439.1
20.1 377.9
11.4 375.5
123.8 363.8
89 276.3

37

CCI Income
116.8 37.415
91.5 36.77
68.5 35.501
61.6 35.047
65.9 34.7
90.6 34.942
100 35.887
104.6 36.306
125.4 37.005

48

Year Fertilizer
2008 32.1
2009 28.6
2010 51.5
2011 52.2
2012 73.5

49

Year Rental and Leasing
2004 5860
2005 6632
2006 7125
2007 6000
2008 4380
2009 3326
2010 2642

50

Year Quarter Sales
2010 1 38.7
2 39.9
3 41.8
4 44.5
2011 1 46.1
2 47.4
3 48.6
4 51.6
2012 1 53.1
2 54.9
3 57

51

X Y
1 8
10 4
9 4
6 5
5 7
3 7
2 9

52

X Y
5 8
7 9
3 11
16 27
12 15
9 13

53

X Y
53 5
47 5
41 7
50 4
58 10
62 12
45 3
60 11

54

X Y
213 76
196 65
184 62
202 68
221 71
247 75

55

X Y
47 14
94 40
68 34
73 31
80 36
49 19
52 20
61 21

56

Year Cost
1 56
2 54
3 49
4 46
5 45

57

Cars Salespeople
79 6
64 6
49 4
23 2
52 3

58

Spending % Purchases
1037 44
976 42
1004 47
942 47
907 50
859 51
431 43
417 36
658 26
646 42
854 40

59

Sales Units
34.2 14.1
11.4 24.7
8.5 5.9
8.4 7.2
6.8 5.7
5.4 7.6
4.5 4.8
4.1 1.6
3.7 3.5
3.4 4.9
3.3 1.5
3 3.5
3 2.2

60

Year Labor Force
2003 64.1
2004 64.02
2005 65.49
2006 66.6
2007 68
2008 69.4
2009 70.86
2010 72.35
2011 73.87
2012 75.42

61

Inflation Rate 30-Year Treasury
1.57 3.05
2.23 3.93
2.17 4.68
4.53 6.57
7.25 8.27
9.25 12.01
5 10.27
4.62 8.45

62

Sales Jobs
20054 122.1
14250 72.3
8026 67
7754 98.4
6564 43.6
5103 41.8
4685 63.3
2278 27.7
1867 22.1
1802 32.8
1743 15.3
1734 31.1
1490 11.1
1351 18.6
1025 9.2

63

Weight Cost
1.897 53.6
3.019 184.9
0.453 6.4
0.988 23.5
1.058 33.4
2.1 110.4
2.387 104.6

64

State Banks All Savings
1342 2330
1864 2667
1912 3054
1847 3764
1641 4423
1405 4837
1147 4694
1046 4407
997 4328
1070 3626
1009 2815
1042 2030
992 1779

65

Advertising Sales
5 82.6
3.1 148.9
2.5 110.9
2.5 55.8
2.4 126.7
2.4 97.2
2.1 136.3
2.1 30
2.1 28.3

66

Water Use Temp
219 103
56 39
107 77
129 78
68 50
184 96
150 90
112 75