Question: b. Utilizing the worksheet Problem 2b, create/make and locate a line chart in the range E2:J14 using the variables World and Month . This line
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 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
