b. Utilizing the worksheet Problem 2b, create/make and locate a line chart in the range E2:J14 using
Fantastic news! We've Found the answer you've been seeking!
Question:
b. Utilizing the worksheet Problem 2b, create/make and locate a line chart in the range E2:J14 using the variables Worldand Month. This line chart will show the number of total complaints over time. Title the chart: Total Complaints: 2014 - 2018. During what time of year are there fewest complaints? Most complaints?
Complaints | ||||||
Month | World | NA | SA | Eur | Pac | China |
Jan-14 | 169 | 102 | 12 | 52 | 3 | |
Feb-14 | 187 | 115 | 13 | 55 | 4 | |
Mar-14 | 210 | 128 | 15 | 61 | 6 | |
Apr-14 | 226 | 136 | 16 | 67 | 7 | |
May-14 | 232 | 137 | 17 | 73 | 5 | |
Jun-14 | 261 | 151 | 19 | 82 | 9 | |
Jul-14 | 245 | 140 | 18 | 80 | 7 | |
Aug-14 | 223 | 128 | 16 | 76 | 3 | |
Sep-14 | 195 | 103 | 15 | 73 | 4 | |
Oct-14 | 174 | 96 | 14 | 62 | 2 | |
Nov-14 | 154 | 84 | 11 | 59 | 0 | |
Dec-14 | 163 | 99 | 9 | 54 | 1 | |
Jan-15 | 195 | 123 | 10 | 59 | 3 | |
Feb-15 | 221 | 141 | 13 | 62 | 5 | |
Mar-15 | 240 | 152 | 16 | 66 | 6 | |
Apr-15 | 264 | 163 | 20 | 70 | 11 | |
May-15 | 283 | 178 | 22 | 75 | 8 | |
Jun-15 | 296 | 170 | 28 | 86 | 12 | |
Jul-15 | 269 | 153 | 25 | 81 | 10 | |
Aug-15 | 256 | 146 | 23 | 79 | 8 | |
Sep-15 | 231 | 131 | 20 | 73 | 7 | |
Oct-15 | 214 | 125 | 16 | 68 | 5 | |
Nov-15 | 201 | 118 | 13 | 66 | 4 | |
Dec-15 | 171 | 96 | 11 | 61 | 3 | |
Jan-16 | 200 | 112 | 15 | 66 | 4 | 3 |
Feb-16 | 216 | 117 | 18 | 71 | 6 | 4 |
Mar-16 | 234 | 126 | 20 | 76 | 9 | 3 |
Apr-16 | 253 | 138 | 23 | 79 | 11 | 2 |
May-16 | 282 | 152 | 26 | 85 | 14 | 5 |
Jun-16 | 305 | 163 | 30 | 91 | 15 | 6 |
Jul-16 | 296 | 156 | 28 | 89 | 18 | 5 |
Aug-16 | 279 | 148 | 26 | 86 | 15 | 4 |
Sep-16 | 266 | 143 | 24 | 82 | 13 | 4 |
Oct-16 | 243 | 131 | 21 | 76 | 12 | 3 |
Nov-16 | 232 | 128 | 18 | 73 | 10 | 3 |
Dec-16 | 203 | 107 | 15 | 70 | 7 | 4 |
Jan-17 | 216 | 110 | 19 | 74 | 8 | 5 |
Feb-17 | 239 | 123 | 23 | 79 | 10 | 4 |
Mar-17 | 266 | 138 | 26 | 83 | 13 | 6 |
Apr-17 | 284 | 150 | 30 | 88 | 11 | 5 |
May-17 | 315 | 169 | 33 | 91 | 15 | 7 |
Jun-17 | 340 | 181 | 37 | 95 | 19 | 8 |
Jul-17 | 319 | 169 | 34 | 92 | 17 | 7 |
Aug-17 | 304 | 160 | 32 | 90 | 15 | 7 |
Sep-17 | 277 | 141 | 29 | 87 | 14 | 6 |
Oct-17 | 250 | 123 | 26 | 83 | 12 | 6 |
Nov-17 | 228 | 112 | 24 | 77 | 10 | 5 |
Dec-17 | 213 | 105 | 23 | 74 | 7 | 4 |
Jan-18 | 240 | 121 | 26 | 80 | 8 | 5 |
Feb-18 | 251 | 126 | 28 | 82 | 10 | 5 |
Mar-18 | 281 | 148 | 31 | 85 | 12 | 5 |
Apr-18 | 298 | 155 | 35 | 89 | 13 | 6 |
May-18 | 322 | 168 | 39 | 95 | 12 | 8 |
Jun-18 | 350 | 183 | 43 | 98 | 15 | 11 |
Jul-18 | 330 | 170 | 41 | 95 | 14 | 10 |
Aug-18 | 311 | 158 | 38 | 93 | 13 | 9 |
Sep-18 | 289 | 149 | 33 | 89 | 11 | 7 |
Oct-18 | 265 | 136 | 30 | 85 | 8 | 6 |
Nov-18 | 239 | 121 | 26 | 80 | 7 | 5 |
Dec-18 | 219 | 108 | 23 | 76 | 7 | 5 |
Posted Date: