b. Utilizing the worksheet Problem 2b, create/make and locate a…
QuestionAnswered step-by-stepb. Utilizing the worksheet Problem 2b, create/make and locate a…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 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 ChinaJan-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 3Feb-16 216 117 18 71 6 4Mar-16 234 126 20 76 9 3Apr-16 253 138 23 79 11 2May-16 282 152 26 85 14 5Jun-16 305 163 30 91 15 6Jul-16 296 156 28 89 18 5Aug-16 279 148 26 86 15 4Sep-16 266 143 24 82 13 4Oct-16 243 131 21 76 12 3Nov-16 232 128 18 73 10 3Dec-16 203 107 15 70 7 4Jan-17 216 110 19 74 8 5Feb-17 239 123 23 79 10 4Mar-17 266 138 26 83 13 6Apr-17 284 150 30 88 11 5May-17 315 169 33 91 15 7Jun-17 340 181 37 95 19 8Jul-17 319 169 34 92 17 7Aug-17 304 160 32 90 15 7Sep-17 277 141 29 87 14 6Oct-17 250 123 26 83 12 6Nov-17 228 112 24 77 10 5Dec-17 213 105 23 74 7 4Jan-18 240 121 26 80 8 5Feb-18 251 126 28 82 10 5Mar-18 281 148 31 85 12 5Apr-18 298 155 35 89 13 6May-18 322 168 39 95 12 8Jun-18 350 183 43 98 15 11Jul-18 330 170 41 95 14 10Aug-18 311 158 38 93 13 9Sep-18 289 149 33 89 11 7Oct-18 265 136 30 85 8 6Nov-18 239 121 26 80 7 5Dec-18 219 108 23 76 7 5 MathStatistics and ProbabilityBUA 350Share Question


