STATS Questions (excel file)

profileStudyLong730
MGMT650Final-Copy2.xlsx
Home>Mathematics homework help>Statistics homework help>STATS Questions (excel file)

q1

q2

q3

Wait Time (minutes)
1.0
5.3
1.1
0.2
0.2
1.8
0.4
1.5
3.5
0.7
3.0
2.5
0.4
1.3
5.7
2.1
0.8
7.6
1.3
1.2
1.3
3.7
4.2
2.1
0.3
3.3
5.8
0.6
2.0
7.5

q4

q5

Wait Time (minutes)
5.1
10.8
6.2
4.3
5.7
7.3
4.7
7.5
8.7
5.5
8.7
7.7
6.5
6.2
11.4
8.1
5.5
12.3
6.4
7.2
7.6
9.2
8.9
6.9
4.8
9.4
11.7
5.6
7.1
13.4

q6

q7

q8

q10

q11

Time Air Quality
0:00:00 1
0:00:30 0
0:01:00 1
0:01:30 1
0:02:00 0
0:02:30 1
0:03:00 1
0:03:30 1
0:04:00 1
0:04:30 1
0:05:00 1
0:05:30 1
0:06:00 1
0:06:30 1
0:07:00 1
0:07:30 1
0:08:00 1
0:08:30 1
0:09:00 0
0:09:30 1
0:10:00 1
0:10:30 1
0:11:00 1
0:11:30 1
0:12:00 1
0:12:30 1
0:13:00 1
0:13:30 1
0:14:00 1
0:14:30 1
0:15:00 1
0:15:30 0
0:16:00 0
0:16:30 0
0:17:00 1
0:17:30 1
0:18:00 1
0:18:30 1
0:19:00 1
0:19:30 1
0:20:00 1
0:20:30 1
0:21:00 1
0:21:30 0
0:22:00 1
0:22:30 0
0:23:00 1
0:23:30 1

q12

Yards
298
273
284
292
275
309
292
302
311
287
279
282
297
283
305
299
294
295
286

q13

Customer Traffic
With Program Without Program
136 140
228 233
111 110
38 42
332 332
132 135
150 151
35 33
189 178
141 147
175 162
253 243
144 149
49 48
356 346

q14

Valley Foothills
109 103
116 182
106 184
157 133
147 243
105 158
173 247
153 221
137 175
110 197

q15

Ovservation Portland Houston Jacksonville
1 85 71 69
2 75 75 74
3 82 73 72
4 76 74 79
5 71 69 85
6 85 82 77

q16

Manufacturer
A B C D
25 23 25 26
23 21 25 27
21 23 25 26
23 24 21 24

q17

Customer # Eye Condition Gender
1 Bifocals Female
2 Bifocals Male
3 Nearsighted Male
4 Nearsighted Female
5 Nearsighted Female
6 Nearsighted Female
7 Bifocals Female
8 Nearsighted Female
9 Bifocals Female
10 Farsighted Male
11 Nearsighted Female
12 Bifocals Male
13 Nearsighted Male
14 Nearsighted Female
15 Nearsighted Male
16 Farsighted Male
17 Nearsighted Female
18 Farsighted Male
19 Farsighted Male
20 Farsighted Male
21 Farsighted Male
22 Bifocals Male
23 Nearsighted Female
24 Bifocals Female
25 Nearsighted Male
26 Bifocals Female
27 Bifocals Female
28 Bifocals Female
29 Nearsighted Male
30 Nearsighted Female
31 Bifocals Male
32 Nearsighted Male
33 Bifocals Female
34 Nearsighted Female
35 Farsighted Male
36 Bifocals Female
37 Bifocals Male
38 Nearsighted Male
39 Nearsighted Male
40 Farsighted Male
41 Bifocals Male
42 Nearsighted Female
43 Farsighted Male
44 Nearsighted Male
45 Nearsighted Female
46 Farsighted Male
47 Bifocals Male
48 Bifocals Female
49 Nearsighted Female
50 Farsighted Male
51 Farsighted Male
52 Bifocals Female
53 Bifocals Female
54 Nearsighted Male
55 Nearsighted Male
56 Nearsighted Female
57 Nearsighted Female
58 Nearsighted Male
59 Farsighted Male
60 Nearsighted Male
61 Nearsighted Male
62 Bifocals Male
63 Nearsighted Female
64 Farsighted Male
65 Nearsighted Male
66 Bifocals Male
67 Bifocals Female
68 Nearsighted Female
69 Nearsighted Female
70 Nearsighted Female
71 Farsighted Male
72 Nearsighted Female
73 Bifocals Male
74 Bifocals Female
75 Bifocals Female
76 Farsighted Female
77 Farsighted Female
78 Farsighted Female
79 Farsighted Female
80 Farsighted Female
81 Farsighted Female
82 Farsighted Female
83 Farsighted Female
84 Farsighted Female

q18

q19

Level of Significance 0.05
Number of Rows 2
Number of Columns 3

q20

Part Quality
Supplier Good Minor Defect Major Defect
A 100 5 8
B 160 10 4
C 150 7 11

q21

Territory
A B C D E
Sales Volume 110 130 100 106 110

q22

variable1 variable2
-8.78162 18.34055
7.39749 2.85607
3.75278 6.23950
-3.91953 13.58786
-7.62142 18.08145
-4.59753 12.85170
-3.41580 13.45867
-0.28752 8.95585
-8.37001 18.84054
6.00523 3.95631
-3.85438 13.08315
-2.86084 13.53479
4.42861 4.86409
-1.24050 9.81458
-4.80313 15.31168
-5.14316 14.74720
-7.41768 17.07810
-5.39179 15.51509
2.34057 8.38950
-8.82911 19.72766
-1.77868 11.60777
-8.99293 18.44845
-7.83663 18.07113
1.56835 7.71226

q23

variable1 variable2
-1.60263 6.66630
5.13511 22.39796
6.36533 48.04439
5.62218 33.73949
-2.19935 13.13368
6.44037 34.07411
7.53576 57.43268
6.84911 46.18391
-0.96507 2.31758
-7.97987 66.45126
7.71148 60.12220
8.00414 69.34776
-1.84249 -8.58487
-6.64529 35.44469
3.52281 15.81326
6.12823 42.51683
-8.02429 63.53322
1.93739 10.39306
1.60250 -1.67370
9.59542 92.44574
0.97873 -2.22144
7.61991 66.59948
6.35683 35.62167
4.60624 15.37388

q24

q25

variable1 variable2
-0.21582 0.89369
0.56997 -0.72620
-0.54850 -0.09185
-0.12385 0.50086
0.06975 -0.73607
0.16327 0.88498
-0.72595 -0.27512
0.22500 0.62647
-0.40463 0.92432
0.67652 0.56368
-0.82322 0.73005
0.06747 -0.74824
0.74055 0.79412
-0.71577 -0.04509
-0.82231 -0.70951
-0.47603 0.01573
0.58094 0.51169
-0.58573 0.10376
0.19003 -0.90089
-0.49528 0.04767
0.93083 -0.16886
0.61389 -0.65529
-0.91742 0.25296
-0.60957 -0.24747

q26

Production Volume (units) Total Cost ($)
400 4384
450 4722
550 5233
600 6091
700 6664
750 6734
425 4423
475 4905
575 5746
625 5709
725 7081
775 7094

q27

Production Volume (units) Total Cost ($)
400 3430
450 4080
550 4878
600 4884
700 5913
750 6402
425 4273
475 4362
575 5089
625 5446
725 6017
775 6591