Question: 1. Create a new column for % on-time 2. PLOT 1 line chart for all 5 years for % on-time 3. What is your prediction

1. Create a new column for % on-time

2. PLOT 1 line chart for all 5 years for % on-time

3. What is your prediction for JAN 2019 using trendline?

4. For Dashboard : Line chart from above

Month Number of deliveries Number On Time
Jan-14 1086 1069
Feb-14 1101 1080
Mar-14 1116 1089
Apr-14 1216 1199
May-14 1183 1168
Jun-14 1176 1160
Jul-14 1198 1181
Aug-14 1205 1189
Sep-14 1223 1210
Oct-14 1209 1194
Nov-14 1198 1180
Dec-14 1243 1223
Jan-15 1220 1201
Feb-15 1241 1224
Mar-15 1237 1217
Apr-15 1258 1242
May-15 1262 1246
Jun-15 1227 1212
Jul-15 1243 1227
Aug-15 1281 1264
Sep-15 1272 1254
Oct-15 1295 1278
Nov-15 1298 1281
Dec-15 1318 1296
Jan-16 1281 1264
Feb-16 1320 1304
Mar-16 1352 1334
Apr-16 1336 1320
May-16 1291 1276
Jun-16 1342 1326
Jul-16 1352 1337
Aug-16 1377 1360
Sep-16 1385 1368
Oct-16 1356 1338
Nov-16 1362 1346
Dec-16 1349 1333
Jan-17 1386 1371
Feb-17 1358 1342
Mar-17 1371 1356
Apr-17 1362 1348
May-17 1350 1338
Jun-17 1381 1366
Jul-17 1392 1378
Aug-17 1371 1359
Sep-17 1402 1387
Oct-17 1384 1370
Nov-17 1399 1377
Dec-17 1369 1357
Jan-18 1401 1390
Feb-18 1388 1376
Mar-18 1395 1385
Apr-18 1412 1401
May-18 1403 1392
Jun-18 1415 1402
Jul-18 1426 1415
Aug-18 1431 1420
Sep-18 1445 1426
Oct-18 1425 1414
Nov-18 1413 1403
Dec-18 1456 1427

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 General Management Questions!