Reference no: EM133082873
Problem:
Date
|
Fraser
|
Interior
|
Northern
|
Vancouver Coastal
|
Vancouver Island
|
#######
|
340
|
60
|
89
|
89
|
19
|
#######
|
231
|
46
|
35
|
86
|
13
|
#######
|
275
|
84
|
27
|
134
|
16
|
#######
|
290
|
50
|
49
|
114
|
13
|
#######
|
290
|
72
|
33
|
138
|
32
|
#######
|
332
|
93
|
67
|
102
|
12
|
#######
|
305
|
61
|
48
|
103
|
29
|
#######
|
272
|
93
|
38
|
113
|
10
|
#######
|
276
|
46
|
80
|
97
|
30
|
#######
|
212
|
79
|
57
|
82
|
18
|
#######
|
183
|
67
|
46
|
98
|
13
|
#######
|
231
|
81
|
43
|
116
|
32
|
#######
|
242
|
118
|
52
|
93
|
17
|
#######
|
248
|
88
|
41
|
106
|
13
|
#######
|
231
|
125
|
77
|
105
|
34
|
#######
|
209
|
70
|
63
|
101
|
17
|
#######
|
137
|
58
|
34
|
70
|
16
|
#######
|
202
|
58
|
23
|
72
|
24
|
#######
|
217
|
94
|
39
|
136
|
25
|
#######
|
242
|
92
|
72
|
107
|
45
|
#######
|
256
|
73
|
57
|
122
|
13
|
#######
|
199
|
103
|
39
|
115
|
28
|
#######
|
204
|
87
|
42
|
138
|
23
|
#######
|
188
|
52
|
32
|
68
|
19
|
#######
|
139
|
51
|
19
|
107
|
18
|
#######
|
198
|
104
|
35
|
155
|
45
|
#######
|
229
|
55
|
53
|
133
|
30
|
#######
|
216
|
66
|
53
|
157
|
30
|
#######
|
191
|
59
|
36
|
112
|
20
|
#######
|
193
|
96
|
36
|
122
|
31
|
#######
|
132
|
43
|
32
|
58
|
30
|
#######
|
187
|
48
|
29
|
104
|
29
|
#######
|
182
|
61
|
31
|
105
|
23
|
#######
|
226
|
60
|
60
|
97
|
29
|
#######
|
207
|
59
|
70
|
111
|
28
|
#######
|
196
|
85
|
27
|
98
|
38
|
#######
|
235
|
51
|
75
|
98
|
23
|
#######
|
191
|
23
|
34
|
73
|
25
|
#######
|
216
|
46
|
28
|
79
|
24
|
#######
|
247
|
47
|
52
|
103
|
25
|
#######
|
238
|
52
|
41
|
100
|
16
|
#######
|
224
|
40
|
23
|
131
|
15
|
#######
|
232
|
42
|
63
|
97
|
17
|
#######
|
238
|
35
|
47
|
112
|
15
|
#######
|
209
|
12
|
27
|
99
|
13
|
#######
|
196
|
15
|
10
|
81
|
20
|
#######
|
196
|
39
|
15
|
121
|
20
|
#######
|
342
|
18
|
95
|
140
|
21
|
#######
|
289
|
61
|
37
|
125
|
19
|
#######
|
283
|
21
|
49
|
130
|
46
|
#######
|
276
|
19
|
33
|
133
|
30
|
#######
|
278
|
28
|
26
|
97
|
25
|
#######
|
245
|
40
|
54
|
121
|
38
|
#######
|
287
|
33
|
28
|
136
|
35
|
#######
|
262
|
24
|
40
|
137
|
43
|
#######
|
346
|
50
|
31
|
135
|
31
|
#######
|
287
|
30
|
57
|
105
|
37
|
#######
|
299
|
25
|
38
|
104
|
27
|
#######
|
269
|
23
|
22
|
112
|
24
|
#######
|
260
|
15
|
20
|
139
|
23
|
#######
|
298
|
47
|
49
|
135
|
28
|
#######
|
289
|
28
|
43
|
167
|
36
|
#######
|
355
|
37
|
57
|
151
|
26
|
#######
|
280
|
34
|
61
|
144
|
28
|
#######
|
309
|
31
|
34
|
153
|
29
|
#######
|
265
|
18
|
5
|
98
|
13
|
#######
|
266
|
30
|
52
|
141
|
8
|
#######
|
293
|
39
|
31
|
146
|
19
|
#######
|
322
|
24
|
61
|
131
|
42
|
#######
|
369
|
45
|
58
|
153
|
34
|
#######
|
299
|
28
|
44
|
141
|
38
|
#######
|
311
|
28
|
35
|
132
|
19
|
#######
|
262
|
22
|
58
|
121
|
20
|
#######
|
281
|
15
|
25
|
138
|
23
|
#######
|
306
|
30
|
34
|
128
|
13
|
#######
|
303
|
30
|
56
|
175
|
33
|
#######
|
425
|
33
|
67
|
174
|
36
|
#######
|
294
|
23
|
60
|
172
|
28
|
#######
|
356
|
29
|
58
|
151
|
19
|
#######
|
408
|
36
|
30
|
152
|
33
|
#######
|
294
|
34
|
20
|
216
|
19
|
#######
|
377
|
35
|
45
|
237
|
26
|
#######
|
391
|
48
|
62
|
263
|
40
|
#######
|
487
|
48
|
92
|
304
|
57
|
#######
|
430
|
67
|
47
|
279
|
62
|
#######
|
443
|
43
|
34
|
278
|
28
|
#######
|
414
|
52
|
39
|
247
|
50
|
#######
|
383
|
58
|
32
|
266
|
45
|
#######
|
475
|
64
|
52
|
378
|
53
|
#######
|
403
|
60
|
50
|
310
|
57
|
#######
|
480
|
86
|
66
|
365
|
76
|
#######
|
581
|
80
|
40
|
338
|
66
|
#######
|
526
|
71
|
61
|
312
|
57
|
#######
|
477
|
63
|
39
|
285
|
48
|
#######
|
451
|
91
|
33
|
300
|
53
|
#######
|
470
|
100
|
34
|
367
|
65
|
#######
|
669
|
101
|
55
|
423
|
66
|
#######
|
623
|
109
|
67
|
367
|
52
|
#######
|
765
|
99
|
62
|
294
|
80
|
#######
|
617
|
125
|
24
|
251
|
46
|
#######
|
650
|
93
|
36
|
210
|
51
|
#######
|
523
|
86
|
30
|
261
|
40
|
#######
|
544
|
89
|
46
|
274
|
51
|
#######
|
733
|
91
|
57
|
300
|
43
|
#######
|
518
|
93
|
35
|
238
|
45
|
#######
|
667
|
102
|
19
|
269
|
29
|
#######
|
604
|
63
|
37
|
220
|
42
|
#######
|
627
|
68
|
46
|
243
|
35
|
#######
|
421
|
40
|
31
|
226
|
28
|
#######
|
591
|
90
|
23
|
199
|
26
|
#######
|
575
|
74
|
49
|
221
|
41
|
#######
|
653
|
71
|
37
|
227
|
24
|
#######
|
563
|
81
|
32
|
179
|
36
|
#######
|
611
|
80
|
17
|
133
|
31
|
#######
|
484
|
59
|
48
|
156
|
17
|
#######
|
515
|
68
|
12
|
153
|
27
|
#######
|
512
|
69
|
23
|
158
|
35
|
#######
|
585
|
51
|
23
|
182
|
30
|
#######
|
457
|
73
|
26
|
159
|
31
|
#######
|
606
|
63
|
15
|
182
|
26
|
#######
|
490
|
33
|
22
|
123
|
21
|
#######
|
434
|
35
|
22
|
139
|
15
|
#######
|
372
|
36
|
11
|
132
|
17
|
#######
|
410
|
61
|
13
|
126
|
20
|
#######
|
474
|
45
|
29
|
147
|
16
|
#######
|
452
|
41
|
19
|
121
|
17
|
#######
|
430
|
48
|
18
|
98
|
23
|
#######
|
408
|
58
|
25
|
115
|
17
|
#######
|
410
|
39
|
10
|
97
|
13
|
#######
|
300
|
60
|
17
|
127
|
12
|
#######
|
372
|
42
|
6
|
144
|
10
|
#######
|
376
|
61
|
18
|
129
|
19
|
#######
|
309
|
32
|
22
|
109
|
8
|
#######
|
282
|
41
|
15
|
96
|
18
|
#######
|
307
|
52
|
13
|
105
|
8
|
#######
|
301
|
40
|
18
|
69
|
13
|
#######
|
249
|
55
|
8
|
74
|
11
|
#######
|
336
|
67
|
30
|
73
|
17
|
#######
|
226
|
35
|
23
|
79
|
11
|
#######
|
248
|
59
|
32
|
87
|
7
|
#######
|
207
|
43
|
20
|
68
|
16
|
#######
|
210
|
37
|
17
|
66
|
4
|
#######
|
190
|
37
|
8
|
60
|
7
|
#######
|
156
|
30
|
4
|
57
|
5
|
#######
|
126
|
41
|
10
|
68
|
9
|
#######
|
196
|
71
|
18
|
94
|
13
|
#######
|
163
|
62
|
16
|
71
|
3
|
#######
|
130
|
38
|
16
|
56
|
11
|
#######
|
159
|
37
|
13
|
31
|
5
|
#######
|
110
|
38
|
10
|
59
|
1
|
#######
|
100
|
11
|
2
|
41
|
0
|
#######
|
119
|
34
|
4
|
39
|
2
|
#######
|
96
|
33
|
6
|
62
|
2
|
#######
|
100
|
29
|
7
|
39
|
3
|
#######
|
125
|
59
|
7
|
35
|
1
|
#######
|
83
|
30
|
1
|
19
|
5
|
#######
|
87
|
17
|
9
|
18
|
3
|
#######
|
71
|
36
|
7
|
29
|
11
|
#######
|
86
|
32
|
7
|
31
|
13
|
#######
|
75
|
41
|
9
|
20
|
11
|
#######
|
69
|
31
|
10
|
27
|
8
|
#######
|
45
|
29
|
15
|
16
|
4
|
#######
|
66
|
25
|
3
|
19
|
5
|
#######
|
41
|
16
|
0
|
12
|
2
|
#######
|
49
|
23
|
1
|
29
|
4
|
#######
|
56
|
32
|
0
|
16
|
5
|
#######
|
52
|
38
|
4
|
26
|
4
|
#######
|
65
|
24
|
6
|
16
|
4
|
#######
|
37
|
20
|
9
|
23
|
1
|
#######
|
43
|
29
|
2
|
14
|
2
|
#######
|
16
|
14
|
1
|
12
|
2
|
#######
|
15
|
23
|
4
|
11
|
4
|
#######
|
50
|
16
|
0
|
13
|
4
|
#######
|
43
|
11
|
2
|
14
|
4
|
#######
|
34
|
10
|
1
|
14
|
4
|
#######
|
30
|
13
|
0
|
9
|
2
|
#######
|
25
|
14
|
0
|
13
|
0
|
#######
|
19
|
12
|
0
|
7
|
1
|
#######
|
9
|
13
|
1
|
6
|
3
|
#######
|
22
|
12
|
1
|
10
|
1
|
#######
|
18
|
24
|
2
|
4
|
0
|
#######
|
16
|
6
|
0
|
10
|
0
|
#######
|
11
|
14
|
2
|
3
|
1
|
#######
|
13
|
21
|
0
|
3
|
0
|
#######
|
13
|
9
|
0
|
1
|
1
|
#######
|
17
|
13
|
2
|
12
|
0
|
#######
|
13
|
15
|
0
|
15
|
2
|
#######
|
22
|
22
|
1
|
8
|
7
|
#######
|
16
|
16
|
1
|
12
|
6
|
#######
|
16
|
14
|
0
|
16
|
5
|
#######
|
17
|
15
|
0
|
6
|
0
|
#######
|
6
|
10
|
0
|
13
|
0
|
#######
|
15
|
13
|
0
|
13
|
1
|
#######
|
11
|
13
|
1
|
5
|
1
|
#######
|
22
|
18
|
1
|
9
|
6
|
#######
|
14
|
22
|
1
|
8
|
2
|
#######
|
19
|
21
|
0
|
12
|
2
|
#######
|
26
|
27
|
3
|
7
|
1
|
#######
|
24
|
12
|
0
|
11
|
1
|
#######
|
14
|
33
|
2
|
12
|
4
|
#######
|
24
|
32
|
0
|
22
|
1
|
#######
|
34
|
39
|
1
|
19
|
4
|
#######
|
25
|
69
|
4
|
9
|
6
|
#######
|
15
|
46
|
1
|
23
|
5
|
#######
|
12
|
57
|
2
|
11
|
5
|
#######
|
21
|
60
|
2
|
11
|
2
|
#######
|
29
|
85
|
2
|
11
|
5
|
#######
|
39
|
115
|
4
|
29
|
9
|
#######
|
52
|
109
|
4
|
27
|
11
|
#######
|
57
|
131
|
5
|
30
|
15
|
#######
|
45
|
74
|
2
|
36
|
19
|
#######
|
37
|
121
|
4
|
36
|
8
|
#######
|
43
|
120
|
2
|
18
|
12
|
#######
|
57
|
98
|
14
|
35
|
10
|
#######
|
57
|
153
|
13
|
40
|
26
|
#######
|
70
|
219
|
16
|
52
|
22
|
#######
|
73
|
288
|
24
|
57
|
32
|
#######
|
106
|
230
|
6
|
65
|
22
|
#######
|
86
|
217
|
9
|
60
|
18
|
#######
|
78
|
156
|
18
|
27
|
22
|
#######
|
86
|
186
|
10
|
51
|
30
|
#######
|
127
|
258
|
23
|
103
|
25
|
#######
|
123
|
280
|
9
|
97
|
31
|
#######
|
141
|
365
|
63
|
96
|
41
|
#######
|
101
|
292
|
28
|
87
|
41
|
#######
|
110
|
190
|
32
|
61
|
33
|
#######
|
120
|
212
|
14
|
64
|
39
|
#######
|
121
|
143
|
28
|
73
|
27
|
#######
|
155
|
300
|
33
|
101
|
31
|
#######
|
217
|
348
|
24
|
120
|
56
|
#######
|
168
|
270
|
39
|
137
|
52
|
#######
|
150
|
329
|
57
|
117
|
43
|
#######
|
153
|
231
|
39
|
102
|
46
|
#######
|
113
|
213
|
12
|
89
|
35
|
#######
|
140
|
231
|
35
|
102
|
55
|
#######
|
209
|
255
|
46
|
128
|
69
|
#######
|
176
|
273
|
67
|
138
|
65
|
#######
|
232
|
353
|
63
|
176
|
64
|
#######
|
205
|
314
|
78
|
113
|
69
|
#######
|
173
|
234
|
58
|
102
|
44
|
#######
|
157
|
177
|
13
|
90
|
70
|
#######
|
180
|
197
|
54
|
94
|
65
|
#######
|
235
|
286
|
96
|
103
|
65
|
(a) Read the file and print the first seven and last seven observations.
(b) Create new variable named "BC" to show the number of daily reported cases in the whole BC each day. Print first seven and last seven observations.
(c) Calculate the mean and standard deviation for each region and the whole BC.
(d) Create two Pie Chart diagrams to show each regions' percentages on Jan 1 and Aug 31.
(e) Create Line Chart diagram to show each region's number of daily reported cases during the sample period. [Hint: five lines in one diagram]
(f) Calculate the total number of reported cases for each region and the whole BC during the sample period.
(g) Create Bar Chart to show each region's total number of reported cases during the sample period.
(h) Create Scatter Diagram with Fraser on the vertical axis and Vancouver Coastal on the horizontal axis.
(i) Calculate the coefficient of correlation between Fraser and Vancouver Coastal.
(j) What can you conclude from the result in (i) and the diagram in (h)?