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)?