Please only do 2B

Problem Set #2 (Chapter 3, 10 points): a. Utilizing the worksheet Problem 2a, create and locate a scatter chart in the range E2:H14 that uses the variables Overall Service and Satisfaction Level. Show axes labels and include the title Overall Service and Satisfaction Level Ratings. Do you observe a positive or negative relationship between the two variables? b. Utilizing the worksheet Problem 2b, create 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? D E F J K L M N O P Q 1 Problerh 2b 2 H LOCATE LINE CHART BELOW 3 Answer to Question: 4 5 6 7 8 9 10 11 12 SA 13 14 15 Complaints 16 17 Month World NA 18 Jan-14 169 102 19 Feb-14 187 115 20 Mar-14 210 128 21 Apr-14 226 136 22 May-14 232 137 23 Jun-14 261 151 24 Jul-14 245 140 25 Aug-14 223 128 26 Sep-14 195 103 Oct-14 174 96 28 Nov-14 154 84 29 Dec-14 163 99 30 Jan-15 195 123 31 Feb-15 221 141 32 Mar-15 240 152 33 Apr-15 264 163 34 May-15 283 178 35 Jun-15 296 170 36 Jul-15 269 153 Eur 12 13 15 16 17 19 18 16 15 14 11 9 10 13 16 20 22 28 25 Pac 52 55 61 67 73 82 80 76 73 62 59 54 59 62 66 70 75 86 81 China 3 4 6 7 5 9 7 3 4 2 27 1 3 5 6 11 8 12 10 75 86 81 79 73 68 66 61 66 71 76 79 85 91 89 86 34 May-15 35 Jun-15 36 Jul-15 37 Aug-15 38 Sep-15 39 Oct-15 40 Nov-15 41 Dec-15 42 Jan-16 43 Feb-16 44 Mar-16 45 Apr-16 46 May-16 47 Jun-16 48 Jul-16 49 Aug-16 50 Sep-16 51 Oct-16 52 Nov-16 53 Dec-16 54 Jan-17 55 Feb-17 56 Mar-17 57 Apr-17 58 May-17 59 Jun-17 60 Jul-17 61 Aug 17 62 Sep 17 63 Oct-17 64 Nov-17 65 Dec-17 66 Jan-18 67 Feb-18 68 Mar-18 69 Apr-18 70 May-18 71 Jun-18 72 Jul-18 73 Aug-18 74 Sep-18 75 Oct-18 76 Nov-18 77 Dec-18 78 82 76 73 70 74 79 283 296 269 256 231 214 201 171 200 216 234 253 282 305 296 279 266 243 232 203 216 239 266 284 315 340 319 304 277 250 228 213 240 251 281 298 322 350 330 311 289 265 239 219 178 170 153 146 131 125 118 96 112 117 126 138 152 163 156 148 143 131 128 107 110 123 138 150 169 181 169 160 141 123 112 105 121 126 148 155 168 183 170 158 149 136 121 108 22 28 25 23 20 16 13 11 15 18 20 23 26 30 28 26 24 21 18 15 19 23 26 30 33 37 34 32 29 26 24 23 26 28 31 35 39 43 41 38 8 12 10 8 7 5 4 3 4 6 9 11 14 15 18 15 13 12 10 7 8 10 13 11 15 19 17 15 14 12 10 7 8 10 12 13 12 15 14 13 11 8 7 7 3 4 3 2 5 6 5 4 4 3 3 4 5 4 6 5 7 8 7 7 83 88 91 95 92 90 87 83 77 74 80 82 85 89 95 98 95 93 89 85 80 5 4 5 5 5 6 8 11 10 9 7 6 5 5 33 30 26 23 76 Problem Set #2 (Chapter 3, 10 points): a. Utilizing the worksheet Problem 2a, create and locate a scatter chart in the range E2:H14 that uses the variables Overall Service and Satisfaction Level. Show axes labels and include the title Overall Service and Satisfaction Level Ratings. Do you observe a positive or negative relationship between the two variables? b. Utilizing the worksheet Problem 2b, create 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? D E F J K L M N O P Q 1 Problerh 2b 2 H LOCATE LINE CHART BELOW 3 Answer to Question: 4 5 6 7 8 9 10 11 12 SA 13 14 15 Complaints 16 17 Month World NA 18 Jan-14 169 102 19 Feb-14 187 115 20 Mar-14 210 128 21 Apr-14 226 136 22 May-14 232 137 23 Jun-14 261 151 24 Jul-14 245 140 25 Aug-14 223 128 26 Sep-14 195 103 Oct-14 174 96 28 Nov-14 154 84 29 Dec-14 163 99 30 Jan-15 195 123 31 Feb-15 221 141 32 Mar-15 240 152 33 Apr-15 264 163 34 May-15 283 178 35 Jun-15 296 170 36 Jul-15 269 153 Eur 12 13 15 16 17 19 18 16 15 14 11 9 10 13 16 20 22 28 25 Pac 52 55 61 67 73 82 80 76 73 62 59 54 59 62 66 70 75 86 81 China 3 4 6 7 5 9 7 3 4 2 27 1 3 5 6 11 8 12 10 75 86 81 79 73 68 66 61 66 71 76 79 85 91 89 86 34 May-15 35 Jun-15 36 Jul-15 37 Aug-15 38 Sep-15 39 Oct-15 40 Nov-15 41 Dec-15 42 Jan-16 43 Feb-16 44 Mar-16 45 Apr-16 46 May-16 47 Jun-16 48 Jul-16 49 Aug-16 50 Sep-16 51 Oct-16 52 Nov-16 53 Dec-16 54 Jan-17 55 Feb-17 56 Mar-17 57 Apr-17 58 May-17 59 Jun-17 60 Jul-17 61 Aug 17 62 Sep 17 63 Oct-17 64 Nov-17 65 Dec-17 66 Jan-18 67 Feb-18 68 Mar-18 69 Apr-18 70 May-18 71 Jun-18 72 Jul-18 73 Aug-18 74 Sep-18 75 Oct-18 76 Nov-18 77 Dec-18 78 82 76 73 70 74 79 283 296 269 256 231 214 201 171 200 216 234 253 282 305 296 279 266 243 232 203 216 239 266 284 315 340 319 304 277 250 228 213 240 251 281 298 322 350 330 311 289 265 239 219 178 170 153 146 131 125 118 96 112 117 126 138 152 163 156 148 143 131 128 107 110 123 138 150 169 181 169 160 141 123 112 105 121 126 148 155 168 183 170 158 149 136 121 108 22 28 25 23 20 16 13 11 15 18 20 23 26 30 28 26 24 21 18 15 19 23 26 30 33 37 34 32 29 26 24 23 26 28 31 35 39 43 41 38 8 12 10 8 7 5 4 3 4 6 9 11 14 15 18 15 13 12 10 7 8 10 13 11 15 19 17 15 14 12 10 7 8 10 12 13 12 15 14 13 11 8 7 7 3 4 3 2 5 6 5 4 4 3 3 4 5 4 6 5 7 8 7 7 83 88 91 95 92 90 87 83 77 74 80 82 85 89 95 98 95 93 89 85 80 5 4 5 5 5 6 8 11 10 9 7 6 5 5 33 30 26 23 76