Delivery Data Analysis for a small town
The following charts show data compiled from thousands of deliveries in a small town, from 2022 to 2024.
At first glance, it is difficult to determine which data to graph, since there are so many variables that could be paired, but it is this flexibility that makes it interesting to study.
First, I will showcase some aggregate factors, such as age and gender, paired against the total number of deliveries.
The following chart, Figure 1.2, shows a visualization of the age groups from the delivery data shown in Figure 1.1, from 2022 to 2024.
| Age | Orders | % |
| <18 | 5281 | 19.97% |
| 18 -30 | 11899 | 45.01% |
| 31 - 50 | 7926 | 29.98% |
| 51+ | 1333 | 5.04% |
Figure 1.1
Figure 1.2
The following chart, Figure 1.4, shows a visualization of the gender groups from the delivery data shown in Figure 1.3, from 2022 to 2024.
| Gender | Orders | % |
| Male | 10237 | 38.72% |
| Female | 13039 | 49.32% |
| Unknown | 3163 | 11.96% |
Figure 1.3
Figure 1.4
Next, I will show different factors paired against the total cost of a single trip. For example, time of day, day of the week, age, gender, and geographic area. Then, I will show this expenditure data across different time periods, such as day, week, month, year, and total time.
The following graph, Figure 3.2, shows the amount spent on every order during the month of January 2024. During this year, I did not work on Sundays. The total number of orders this month was 813. The average order cost was $217.22, the highest was $2,607 and the lowest was $25. The median was $175. The most orders occurred on Saturday at 20.66%. Figure 3.1 shows the remaining number of orders for the month.
| Day | Orders | % |
| Sunday | 0 | 0.00% |
| Monday | 113 | 13.90% |
| Tuesday | 140 | 17.22% |
| Wednesday | 150 | 18.45% |
| Thursday | 108 | 13.28% |
| Friday | 134 | 16.48% |
| Saturday | 168 | 20.66% |
Figure 3.1
Figure 3.2
Next, I will show this analysis for the rest of the months in 2024.
The following graph, Figure 3.4, shows the amount spent on every order during the month of February 2024. The total number of orders was 763. The average order cost was $218.35, the highest was $1,074 and the lowest was $25. The median was $190. The most orders occurred on Saturday at 20.71%. Figure 3.3 shows the remaining number of orders for the month.
| Day | Orders | % |
| Sunday | 0 | 0.00% |
| Monday | 100 | 13.11% |
| Tuesday | 108 | 14.15% |
| Wednesday | 119 | 15.60% |
| Thursday | 152 | 19.92% |
| Friday | 126 | 16.51% |
| Saturday | 158 | 20.71% |
Figure 3.3
Figure 3.4
The following graph, Figure 3.6, shows the amount spent on every order during the month of March 2024. The total number of orders was 798. The average order cost was $228.41, the highest was $3,300 and the lowest was $25. The median was $185. The most orders occurred on Saturday at 25.44%. Figure 3.5 shows the remaining number of orders for the month.
| Day | Orders | % |
| Sunday | 0 | 0.00% |
| Monday | 97 | 12.16% |
| Tuesday | 99 | 12.41% |
| Wednesday | 120 | 15.04% |
| Thursday | 128 | 16.04% |
| Friday | 151 | 18.92% |
| Saturday | 203 | 25.44% |
Figure 3.5
Figure 3.6
The following graph, Figure 3.8, shows the amount spent on every order during the month of April 2024. The total number of orders was 785. The average order cost was $218.80, the highest was $3,029 and the lowest was $25. The median was $175. The most orders occurred on Monday at 22.55%. Figure 3.7 shows the remaining number of orders for the month.
| Day | Orders | % |
| Sunday | 0 | 0.00% |
| Monday | 177 | 22.55% |
| Tuesday | 135 | 17.20% |
| Wednesday | 116 | 14.78% |
| Thursday | 107 | 13.63% |
| Friday | 105 | 13.38% |
| Saturday | 145 | 18.47% |
Figure 3.7
Figure 3.8
The following graph, Figure 3.10, shows the amount spent on every order during the month of May 2024. The total number of orders was 984. The average order cost was $238.93, the highest was $4,008 and the lowest was $25. The median was $181. The most orders occurred on Thursday at 19.11%. Figure 3.9 shows the remaining number of orders for the month.
| Day | Orders | % |
| Sunday | 0 | 0.00% |
| Monday | 143 | 14.53% |
| Tuesday | 127 | 12.91% |
| Wednesday | 179 | 18.19% |
| Thursday | 188 | 19.11% |
| Friday | 164 | 16.67% |
| Saturday | 182 | 18.50% |
Figure 3.9
Figure 3.10
The following graph, Figure 3.12, shows the amount spent on every order during the month of June 2024. The total number of orders was 897. The average order cost was $233.78, the highest was $7,535 and the lowest was $25. The median was $175. The most orders occurred on Monday at 18.62%. Figure 3.11 shows the remaining number of orders for the month.
| Day | Orders | % |
| Sunday | 0 | 0.00% |
| Monday | 167 | 18.62% |
| Tuesday | 126 | 14.05% |
| Wednesday | 141 | 15.72% |
| Thursday | 138 | 15.38% |
| Friday | 158 | 17.61% |
| Saturday | 166 | 18.51% |
Figure 3.11
Figure 3.12
The following graph, Figure 3.14, shows the amount spent on every order during the month of July 2024. The total number of orders was 1,041. The average order cost was $243.09, the highest was $3,811 and the lowest was $25. The median was $200. The most orders occurred on Wednesday at 19.60%. Figure 3.13 shows the remaining number of orders for the month.
| Day | Orders | % |
| Sunday | 0 | 0.00% |
| Monday | 179 | 17.20% |
| Tuesday | 177 | 17.00% |
| Wednesday | 204 | 19.60% |
| Thursday | 133 | 12.78% |
| Friday | 171 | 16.43% |
| Saturday | 177 | 17.00% |
Figure 3.13
Figure 3.14
The following graph, Figure 3.16, shows the amount spent on every order during the month of August 2024. The total number of orders was 1,032. The average order cost was $237.66, the highest was $1,983 and the lowest was $10. The median was $200. The most orders occurred on Friday at 21.51%. Figure 3.15 shows the remaining number of orders for the month.
| Day | Orders | % |
| Sunday | 0 | 0.00% |
| Monday | 156 | 15.12% |
| Tuesday | 140 | 13.57% |
| Wednesday | 163 | 15.79% |
| Thursday | 145 | 14.05% |
| Friday | 222 | 21.51% |
| Saturday | 205 | 19.86% |
Figure 3.15
Figure 3.16
The following graph, Figure 3.18, shows the amount spent on every order during the month of September 2024. The total number of orders was 821. The average order cost was $243.42, the highest was $3,916 and the lowest was $20. The median was $200. The most orders occurred on Saturday at 21.19%. Figure 3.17 shows the remaining number of orders for the month.
| Day | Orders | % |
| Sunday | 0 | 0.00% |
| Monday | 163 | 19.85% |
| Tuesday | 113 | 13.76% |
| Wednesday | 131 | 15.96% |
| Thursday | 83 | 10.11% |
| Friday | 157 | 19.12% |
| Saturday | 174 | 21.19% |
Figure 3.17
Figure 3.18
The following graph, Figure 3.20, shows the amount spent on every order during the month of October 2024. The total number of orders was 798. The average order cost was $265.92, the highest was $5,100 and the lowest was $35. The median was $203. The most orders occurred on Thursday at 18.55%. Figure 3.19 shows the remaining number of orders for the month.
| Day | Orders | % |
| Sunday | 0 | 0.00% |
| Monday | 110 | 13.78% |
| Tuesday | 145 | 18.17% |
| Wednesday | 118 | 14.79% |
| Thursday | 148 | 18.55% |
| Friday | 138 | 17.29% |
| Saturday | 139 | 17.42% |
Figure 3.19
Figure 3.20
The following graph, Figure 3.22, shows the amount spent on every order during the month of November 2024. The total number of orders was 676. The average order cost was $278.91, the highest was $3,300 and the lowest was $35. The median was $210. The most orders occurred on Saturday at 22.34%. Figure 3.21 shows the remaining number of orders for the month.
| Day | Orders | % |
| Sunday | 0 | 0.00% |
| Monday | 100 | 14.79% |
| Tuesday | 105 | 15.53% |
| Wednesday | 72 | 10.65% |
| Thursday | 111 | 16.42% |
| Friday | 137 | 20.27% |
| Saturday | 151 | 22.34% |
Figure 3.21
Figure 3.22
The following graph, Figure 3.24, shows the amount spent on every order during the month of December 2024. The total number of orders was 513. On this month, I stopped working 10 days before the end of the month. The average order cost was $314.45, the highest was $10,200 and the lowest was $35. The median was $230. The most orders occurred on Thursday at 18.91%. Figure 3.23 shows the remaining number of orders for the month.
| Day | Orders | % |
| Sunday | 0 | 0.00% |
| Monday | 89 | 17.35% |
| Tuesday | 66 | 12.87% |
| Wednesday | 71 | 13.84% |
| Thursday | 97 | 18.91% |
| Friday | 93 | 18.13% |
| Saturday | 97 | 18.91% |
Figure 3.23
Figure 3.24
Next, I will show a combination of all the data. The following graph, Figure 3.26, shows the amount spent on every order during 2024. The total number of orders was 9,921. The average order cost was $242.14, the highest was $10,200 and the lowest was $10. The median was $192. The most orders occurred on Saturday at 19.82%. Figure 3.25 shows the remaining number of orders for the year.
| Day | Orders | % |
| Sunday | 0 | 0.00% |
| Monday | 1595 | 16.08% |
| Tuesday | 1481 | 14.93% |
| Wednesday | 1584 | 15.97% |
| Thursday | 1538 | 15.50% |
| Friday | 1757 | 17.71% |
| Saturday | 1966 | 19.82% |
Figure 3.25
Figure 3.26
Month after month, I noticed that the data became predictable. During the very start, back in 2022, all of the numbers grew very quickly, until they plateaued a couple of months in. This data from 2024 perfectly represents this, because at this point I had been established for a long time, so there were no significant changes. The majority of the orders were below $1,000. It is interesting that every month, the average order cost was very close, despite the many outliers. Every day, I never knew who was going to order, or how many orders I would get, and everything was seemingly random. But all of this chaos was converted into order by the end of every month. Predictable revenue, number of orders, even the percentage of tips.