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
Get step-by-step solutions from verified subject matter experts
