Question
Date Fraser Interior Northern Vancouver Coastal Vancouver Island ####### 340 60 89 89 19 ####### 231 46 35 86 13 ####### 275 84 27 134
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)?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started