-
Notifications
You must be signed in to change notification settings - Fork 0
/
Description.txt
55 lines (47 loc) · 3.31 KB
/
Description.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
Canada Freight Analysis - Analysis of Mode of Transports between different provinces
in Canada between 2011 - 2017
Findings -
1. Total Number of Shipments each year
2. Most common modes of transportation
3. Commodities shipped most frequently
4. Avg weight of shipments per year
5. Total Revenue generated each year
6. Avg distance travelled by shipments each year
7. Trend between origin city and destination city - year wise
8. Statistical relation between (Distance and Shipment Value), (Shipment and Revenue), Revenue and (Shipment and WeightKg),
Shipment value and (Shipment,WeightKg, Distance, Revenue, TonneKm )
Conclusion -
1. Ontario is the most popular Origin and Destination province in Canada.
2. Trucks are the most common mode of transportation
3. Food, Forest Products, Base metals and articles of base metal are the most common commodities w.r.t total shipments.
4. Shipment vs Revenue ------
The regression analysis suggests that there is a statistically significant positive relationship between shipments and revenue.
On average, an increase in shipments is associated with an increase in revenue.
Correlation coefficient --- 0.64, R Square --- 0.41
5. Distance vs Shipment Value ---
Correlation coefficient --- 0.368, R Square Value - 0.135
The regression analysis suggests that there is a statistically significant positive relationship between distance and shipment value.
On average, an increase in distance is associated with an increase in shipment value.
6. Relation b/w Shipment value and (Shipment,WeightKg, Distance, Revenue, TonneKm )
Correlation coefficient - 0.779, R Square value - 0.60
Coefficients
Intercept 11306730.1
X Variable 1 24169.45141
X Variable 2 -0.559483249
X Variable 3 -11.17552351
X Variable 4 40.89071035
X Variable 5 -0.650916327
X Variable 1 (Shipment): - Indicates that, on average, each additional unit of shipment is associated with an increase in shipment value of approximately
$24,169.45.
X Variable 2 (WeightKg): - suggests that, on average, each additional unit of weight (in kilograms) is associated with a decrease in shipment value by
approximately $0.559.
X Variable 3 (Distance): - suggests that, on average, each additional unit of distance is associated with a decrease in shipment value by approximately
$11.18.
X Variable 4 (Revenue): - indicates that, on average, each additional unit of revenue is associated with an increase in shipment value of approximately
$40.89.
X Variable 5 (TonneKm): suggests that, on average, each additional unit of TonneKm is associated with a decrease in shipment value by approximately
$0.651.
The multiple linear regression model suggests that the combination of Shipment, WeightKg, Distance, Revenue, and TonneKm
significantly predicts shipment value. The model explains a substantial portion (60.7%) of the variability in shipment value.
Each coefficient represents the estimated change in shipment value for a one-unit change in the corresponding independent variable, holding other
variables constant.