Buisness Statistics

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

5

One Two Three
2 5 3
1 3 4
3 6 5
3 4 5
2 5 3
1 5

6

1 2 3 4 5
14 10 11 16 14
13 9 12 17 12
10 12 13 14 13
9 12 16 13
10 17 12
14

7

1 2 3 4
113 120 132 122
121 127 130 118
117 125 129 125
110 129 135 125

8

1 2
27 22
31 27
31 25
29 23
30 26
27 27
28 23

11

Machine 1 Machine 2 Machine 3 Machine 4
4.05 3.99 3.97 4.00
4.01 4.02 3.98 4.02
4.02 4.01 3.97 3.99
4.04 3.99 3.95 4.01
4.00 4.00
4.00

12

South Northeast West
40500 51000 45500
41500 49500 43500
40000 49000 45000
41000 48000 46500
41500 49500 46000

13

High Level Mid Level Low Level
7 8 5
7 9 6
8 8 5
7 10 7
9 9 4
10 8
8

14

Atlanta New York Los Angeles Chicago
850 450 1050 740
680 725 900 650
750 500 1150 875
800 375 980 750
875 700 800 800

28

1 2 3 4
1 23 26 24 24
2 31 35 32 33
3 27 29 26 27
4 21 28 27 22
5 18 25 27 20

29

1 2 3
1 1.28 1.29 1.29
2 1.4 1.36 1.35
3 1.15 1.13 1.19
4 1.22 1.18 1.24

32

Motel 1 Motel 2 Motel 3 Motel 4
1 40 30 55 45
2 65 50 80 70
3 60 55 60 60
4 20 40 55 50
5 50 35 65 60
6 30 30 50 50
7 55 30 60 55
8 70 70 70 70
9 65 60 80 75
10 45 25 45 50

33

Democrat Republican Independent
Upper 11 5 8
Upper Middle 15 9 8
Middle 19 14 15
Lower Middle 16 12 10
Lower 9 8 7

40

A B C
A 23 21 20
25 21 22
B 27 24 26
28 27 27

41

A B
A 1.2 1.9
1.3 1.6
1.3 1.7
1.5 2
B 2.2 2.7
2.1 2.5
2 2.8
2.3 2.8
C 1.7 1.9
1.8 2.2
1.7 1.9
1.6 2
D 2.4 2.8
2.3 2.6
2.5 2.4
2.4 2.8

42

1 2 3 or More
4-5 2 1 1
4 2 1
6-7 5 3 2
4 1 1
8-9 8 4 2
6 5 3
10-12 7 3 4
8 5 3

43

0 1 2 3
Stand-Alone 41 38 59 47
30 31 48 40
45 39 51 39
Mall 25 29 44 43
31 35 48 42
22 30 50 53
Downtown 18 22 29 24
29 17 28 27
33 25 26 32

45

1 2 3
1 6.56 6.38 6.29
6.4 6.19 6.23
2 6.54 6.26 6.19
6.34 6.23 6.33
3 6.58 6.22 6.26
6.44 6.27 6.31
4 6.36 6.29 6.21
6.5 6.19 6.58

47

One Two Three Four
10 9 12 10
12 7 13 10
15 9 14 13
11 6 14 12

50

Treatment 1 Treatment 2 Treatment 3
7 11 8
12 17 6
9 16 10
11 13 9
8 10 11
9 15 7
11 14 10
10 18
7
8

53

A B C D
1 17 10 9 21
2 13 9 8 16
3 20 17 18 22
4 11 6 5 10
5 16 13 14 22
6 23 19 20 28

55

A B C
A 5 2 2
3 4 3
6 4 5
B 11 9 13
8 10 12
12 8 10
C 6 7 4
4 6 6
5 7 8
D 9 8 8
11 12 9
9 9 11

56

SE West MW NE
21-35 3 2 3 2
2 4 3 3
3 3 2 2
36-50 5 4 5 6
5 4 6 4
4 6 5 5
Over 50 3 2 3 3
1 2 2 2
2 3 3 1

57

A B C D
31000 24000 30500 24500
25000 25500 28000 27000
28500 27000 32500 26000
29000 26500 28000 21000
32000 25000 31000 25500
27500 28000 26000
27500

58

Method 1 Method 2 Method 3
1 1310 1080 850
2 1275 1100 1020
3 1280 1050 780
4 1225 1020 870
5 1190 990 805
6 1300 1030 910

59

Bricklaying Iron Working Crane Operation
19.25 26.45 16.2
17.8 21.1 23.3
20.5 16.4 22.9
24.33 22.86 19.5
19.81 25.55 27
22.29 18.5 22.95
21.2 25.52
21.2

60

0-5 6-20 21-100 >100
0-2 2 2 3 3
3 1 4 4
2 2 4 4
2 3 5 3
3-5 2 2 3 3
1 3 2 3
2 2 4 3
3 3 4 4
Over 5 2 2 3 2
1 3 2 3
1 1 3 2
2 2 3 3

61

Mail Typist Recept. Sec. Tele
1 4 5 3 7 6
2 2 4 4 5 4
3 3 3 2 6 7
4 4 4 4 5 4
5 3 5 1 3 5
6 3 4 2 7 7
7 2 2 2 4 4
8 3 4 3 6 6

Sheet1

Sheet2

Sheet3