310homework4data.xlsx

#3

Observation John Fred
1 66.4 75.6
2 63.8 75.1
3 69.3 74.6
4 64.2 76.1
5 55.7 71.6
6 72.5 73.7
7 66.2 75.8
8 64.0 81.8
9 68.3 73.3
10 66.1 73
11 64.3 77.8
12 67.1 74.8
13 70.1 61.3
14 65.7 69.7
15 63.0 68.7
16 59.0 76.1
17 59.1 77.7
18 65.9 71
19 67.8 71.6
20 77.0 62.3
21 65.4 66.4
22 70.5 78.3
23 65.2 70.9
24 73.3 70
25 63.2 70.9
26 65.6 70
27 63.2 66.5
28 62.7 71.9
29 61.1 67.8
30 65.2 70.1
31 64.6 72.1
32 70.0 70.7
33 65.8 60.3
34 68.2 65.7
35 70.2 68.6
36 68.8 70.4
37 58.5 61.4
38 63.8 62.7
39 64.0 64
40 68.5 69.5
41 69.0 62.3
42 56.8 66.1
43 64.8 62.1
44 60.1 68
45 66.8 60.6
46 73.0 64.7
47 66.0 60.6
48 62.5 62.3
49 69.7 59.1
50 65.8 60.8
51 65.2 68
52 69.6 61.6
53 64.8 58.3
54 70.5 55.8
55 61.3 67.8
56 65.8 64.1
57 67.9 63.9
58 68.8 60.2
59 64.1 62.3
60 60.5 61.1
61 63.6 63.4
62 67.6 64.5
63 66.4 58.5
64 64.1 60.1
65 72.1 62.9
66 66.6 57.2
67 66.0 63.5
68 71.9 65.7
69 65.6 64.7
70 58.8 57.4

This is fictitious data.

#4

Customer Time
1 138.6
2 43.3
3 57.5
4 84.2
5 44.7
6 30.4
7 317.6
8 82.4
9 67.0
10 84.6
11 71.0
12 39.2
13 68.7
14 40.2
15 44.2
16 73.0
17 37.7
18 54.4
19 94.4
20 38.8
21 129.5
22 51.1
23 45.6
24 114.5
25 91.3
26 94.8
27 94.7
28 102.3
29 31.1
30 40.0
31 38.8
32 90.9
33 32.1
34 35.6
35 198.5
36 96.6
37 115.2
38 110.7
39 181.6
40 60.6
41 143.5
42 50.3
43 111.9
44 79.1
45 65.9
46 178.1
47 96.2
48 38.4
49 141.0
50 63.0
51 47.2
52 44.5
53 248.8
54 34.5
55 44.8
56 30.9
57 133.4
58 41.2
59 34.8
60 30.7
61 269.5
62 64.3
63 171.8
64 51.2
65 117.5
66 41.6
67 96.7
68 58.6
69 49.1
70 58.2
71 43.1
72 134.1
73 149.8
74 120.5
75 32.2
76 128.3
77 113.7
78 154.9
79 68.0
80 52.5
81 63.5
82 40.7
83 164.9
84 211.1
85 225.8
86 162.0
87 163.5
88 79.3
89 52.5
90 84.6
91 72.2
92 69.8
93 89.3
94 365.4
95 35.9
96 96.9
97 62.4
98 79.5
99 152.0
100 212.1
101 152.8
102 87.6
103 188.4
104 67.0
105 122.8
106 158.1
107 138.9
108 155.0
109 91.6
110 194.2
111 74.8
112 269.4
113 30.4
114 112.0
115 67.3
116 210.2
117 97.6
118 71.5
119 39.3
120 30.7
121 68.5
122 45.0
123 132.6
124 91.2
125 60.1
126 90.6
127 81.2
128 58.2
129 40.9
130 46.8
131 45.5
132 88.6
133 40.0
134 165.7
135 56.7
136 49.8
137 230.4
138 41.5
139 70.6
140 37.2
141 107.1
142 75.2
143 197.8
144 50.2
145 77.1
146 85.6
147 167.9
148 86.5
149 40.5
150 66.0
151 46.7
152 49.9
153 175.1
154 193.7
155 34.1
156 119.5
157 72.3
158 183.8
159 31.1
160 166.9
161 126.9
162 190.1
163 120.0
164 38.3
165 35.2
166 100.4
167 70.8
168 102.3
169 101.7
170 54.9
171 123.5
172 43.8
173 66.4
174 38.0
175 144.4
176 37.6
177 68.3
178 88.8
179 132.3
180 112.4
181 52.5
182 42.7
183 85.0
184 92.7
185 90.8
186 256.0
187 50.0
188 226.1
189 113.8
190 41.1
191 77.1
192 517.7
193 112.0
194 76.3
195 73.2
196 88.4
197 198.4
198 36.9
199 47.6
200 50.7