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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!