# A. Bộ dữ liệu Financial Sample.

1.Ta có bộ dữ liệu Fainancial Sample với 1006 quan sát và 9 biến với:

Country: Quốc gia nơi sản phẩm được bán ( Canada, France, Germany, Mexico, United States of America).

Product: Tên của sản phẩm ( Amarilla, Carretera, Montana, Paseo, Velo, VTT).

Units.Sold: Số lượng sản phẩm được bán.

Manufacturing.Price: Giá sản xuất của sản phẩm.

Sale.Price: Giá bán của sản phẩm cho khách hàng cuối cùng.

Gross.Sales: Tổng doanh số bán hàng trước khi áp dụng chiết khấu hoặc thuế.

Discounts: Tổng số tiền chiết khấu được áp dụng cho các đơn hàng.

COGS: Chi phí của hàng hóa được bán.

Profit: Lợi nhuận gộp từ việc bán hàng (tổng doanh số bán hàng trừ đi chi phí sản xuất và các chi phí liên quan khác).

library(xlsx)
nv5 <- read.xlsx("C:/Users/PC/Downloads/Financial Sample (1).xlsx", sheetIndex = 1, header = T)
table <- knitr::kable(nv5,format = "markdown")
table
Country Product Units.Sold Manufacturing.Price Sale.Price Gross.Sales Discounts COGS Profit
Canada Carretera 1618.5 3 20 32370.0 0.000 16185.0 16185.000
Germany Carretera 1321.0 3 20 26420.0 0.000 13210.0 13210.000
France Carretera 2178.0 3 15 32670.0 0.000 21780.0 10890.000
Germany Carretera 888.0 3 15 13320.0 0.000 8880.0 4440.000
Mexico Carretera 2470.0 3 15 37050.0 0.000 24700.0 12350.000
Germany Carretera 1513.0 3 350 529550.0 0.000 393380.0 136170.000
Germany Montana 921.0 5 15 13815.0 0.000 9210.0 4605.000
Canada Montana 2518.0 5 12 30216.0 0.000 7554.0 22662.000
France Montana 1899.0 5 20 37980.0 0.000 18990.0 18990.000
Germany Montana 1545.0 5 12 18540.0 0.000 4635.0 13905.000
Mexico Montana 2470.0 5 15 37050.0 0.000 24700.0 12350.000
Canada Montana 2665.5 5 125 333187.5 0.000 319860.0 13327.500
Mexico Montana 958.0 5 300 287400.0 0.000 239500.0 47900.000
Germany Montana 2146.0 5 7 15022.0 0.000 10730.0 4292.000
Canada Montana 345.0 5 125 43125.0 0.000 41400.0 1725.000
United States of America Montana 615.0 5 15 9225.0 0.000 6150.0 3075.000
Canada Paseo 292.0 10 20 5840.0 0.000 2920.0 2920.000
Mexico Paseo 974.0 10 15 14610.0 0.000 9740.0 4870.000
Canada Paseo 2518.0 10 12 30216.0 0.000 7554.0 22662.000
Germany Paseo 1006.0 10 350 352100.0 0.000 261560.0 90540.000
Germany Paseo 367.0 10 12 4404.0 0.000 1101.0 3303.000
Mexico Paseo 883.0 10 7 6181.0 0.000 4415.0 1766.000
France Paseo 549.0 10 15 8235.0 0.000 5490.0 2745.000
Mexico Paseo 788.0 10 300 236400.0 0.000 197000.0 39400.000
Mexico Paseo 2472.0 10 15 37080.0 0.000 24720.0 12360.000
United States of America Paseo 1143.0 10 7 8001.0 0.000 5715.0 2286.000
Canada Paseo 1725.0 10 350 603750.0 0.000 448500.0 155250.000
United States of America Paseo 912.0 10 12 10944.0 0.000 2736.0 8208.000
Canada Paseo 2152.0 10 15 32280.0 0.000 21520.0 10760.000
Canada Paseo 1817.0 10 20 36340.0 0.000 18170.0 18170.000
Germany Paseo 1513.0 10 350 529550.0 0.000 393380.0 136170.000
Mexico Velo 1493.0 120 7 10451.0 0.000 7465.0 2986.000
France Velo 1804.0 120 125 225500.0 0.000 216480.0 9020.000
Germany Velo 2161.0 120 12 25932.0 0.000 6483.0 19449.000
Germany Velo 1006.0 120 350 352100.0 0.000 261560.0 90540.000
Germany Velo 1545.0 120 12 18540.0 0.000 4635.0 13905.000
United States of America Velo 2821.0 120 125 352625.0 0.000 338520.0 14105.000
Canada Velo 345.0 120 125 43125.0 0.000 41400.0 1725.000
Canada VTT 2001.0 250 300 600300.0 0.000 500250.0 100050.000
Germany VTT 2838.0 250 12 34056.0 0.000 8514.0 25542.000
France VTT 2178.0 250 15 32670.0 0.000 21780.0 10890.000
Germany VTT 888.0 250 15 13320.0 0.000 8880.0 4440.000
France VTT 1527.0 250 350 534450.0 0.000 397020.0 137430.000
France VTT 2151.0 250 300 645300.0 0.000 537750.0 107550.000
Canada VTT 1817.0 250 20 36340.0 0.000 18170.0 18170.000
France Amarilla 2750.0 260 350 962500.0 0.000 715000.0 247500.000
United States of America Amarilla 1953.0 260 12 23436.0 0.000 5859.0 17577.000
Germany Amarilla 4219.5 260 125 527437.5 0.000 506340.0 21097.500
France Amarilla 1899.0 260 20 37980.0 0.000 18990.0 18990.000
Germany Amarilla 1686.0 260 7 11802.0 0.000 8430.0 3372.000
United States of America Amarilla 2141.0 260 12 25692.0 0.000 6423.0 19269.000
United States of America Amarilla 1143.0 260 7 8001.0 0.000 5715.0 2286.000
United States of America Amarilla 615.0 260 15 9225.0 0.000 6150.0 3075.000
France Paseo 3945.0 10 7 27615.0 276.150 19725.0 7613.850
France Paseo 2296.0 10 15 34440.0 344.400 22960.0 11135.600
France Paseo 1030.0 10 7 7210.0 72.100 5150.0 1987.900
France Velo 639.0 120 7 4473.0 44.730 3195.0 1233.270
Canada VTT 1326.0 250 7 9282.0 92.820 6630.0 2559.180
United States of America Carretera 1858.0 3 12 22296.0 222.960 5574.0 16499.040
Mexico Carretera 1210.0 3 350 423500.0 4235.000 314600.0 104665.000
United States of America Carretera 2529.0 3 7 17703.0 177.030 12645.0 4880.970
Canada Carretera 1445.0 3 12 17340.0 173.400 4335.0 12831.600
United States of America Carretera 330.0 3 125 41250.0 412.500 39600.0 1237.500
France Carretera 2671.0 3 12 32052.0 320.520 8013.0 23718.480
Germany Carretera 766.0 3 12 9192.0 91.920 2298.0 6802.080
Mexico Carretera 494.0 3 300 148200.0 1482.000 123500.0 23218.000
Mexico Carretera 1397.0 3 350 488950.0 4889.500 363220.0 120840.500
France Carretera 2155.0 3 350 754250.0 7542.500 560300.0 186407.500
Mexico Montana 2214.0 5 15 33210.0 332.100 22140.0 10737.900
United States of America Montana 2301.0 5 300 690300.0 6903.000 575250.0 108147.000
France Montana 1375.5 5 20 27510.0 275.100 13755.0 13479.900
Canada Montana 1830.0 5 7 12810.0 128.100 9150.0 3531.900
United States of America Montana 2498.0 5 300 749400.0 7494.000 624500.0 117406.000
United States of America Montana 663.0 5 125 82875.0 828.750 79560.0 2486.250
United States of America Paseo 1514.0 10 15 22710.0 227.100 15140.0 7342.900
United States of America Paseo 4492.5 10 7 31447.5 314.475 22462.5 8670.525
United States of America Paseo 727.0 10 125 90875.0 908.750 87240.0 2726.250
France Paseo 787.0 10 125 98375.0 983.750 94440.0 2951.250
Mexico Paseo 1823.0 10 125 227875.0 2278.750 218760.0 6836.250
Germany Paseo 747.0 10 15 11205.0 112.050 7470.0 3622.950
Germany Paseo 766.0 10 12 9192.0 91.920 2298.0 6802.080
United States of America Paseo 2905.0 10 300 871500.0 8715.000 726250.0 136535.000
France Paseo 2155.0 10 350 754250.0 7542.500 560300.0 186407.500
France Velo 3864.0 120 20 77280.0 772.800 38640.0 37867.200
Mexico Velo 362.0 120 7 2534.0 25.340 1810.0 698.660
Canada Velo 923.0 120 125 115375.0 1153.750 110760.0 3461.250
United States of America Velo 663.0 120 125 82875.0 828.750 79560.0 2486.250
Canada Velo 2092.0 120 7 14644.0 146.440 10460.0 4037.560
Germany VTT 263.0 250 7 1841.0 18.410 1315.0 507.590
Canada VTT 943.5 250 350 330225.0 3302.250 245310.0 81612.750
United States of America VTT 727.0 250 125 90875.0 908.750 87240.0 2726.250
France VTT 787.0 250 125 98375.0 983.750 94440.0 2951.250
Germany VTT 986.0 250 300 295800.0 2958.000 246500.0 46342.000
Mexico VTT 494.0 250 300 148200.0 1482.000 123500.0 23218.000
Mexico VTT 1397.0 250 350 488950.0 4889.500 363220.0 120840.500
France VTT 1744.0 250 125 218000.0 2180.000 209280.0 6540.000
United States of America Amarilla 1989.0 260 12 23868.0 238.680 5967.0 17662.320
France Amarilla 321.0 260 15 4815.0 48.150 3210.0 1556.850
Canada Carretera 742.5 3 125 92812.5 1856.250 89100.0 1856.250
Canada Carretera 1295.0 3 12 15540.0 310.800 3885.0 11344.200
Germany Carretera 214.0 3 300 64200.0 1284.000 53500.0 9416.000
France Carretera 2145.0 3 7 15015.0 300.300 10725.0 3989.700
Canada Carretera 2852.0 3 350 998200.0 19964.000 741520.0 236716.000
United States of America Montana 1142.0 5 12 13704.0 274.080 3426.0 10003.920
United States of America Montana 1566.0 5 20 31320.0 626.400 15660.0 15033.600
Mexico Montana 690.0 5 12 8280.0 165.600 2070.0 6044.400
Mexico Montana 1660.0 5 125 207500.0 4150.000 199200.0 4150.000
Canada Paseo 2363.0 10 15 35445.0 708.900 23630.0 11106.100
France Paseo 918.0 10 300 275400.0 5508.000 229500.0 40392.000
Germany Paseo 1728.0 10 300 518400.0 10368.000 432000.0 76032.000
United States of America Paseo 1142.0 10 12 13704.0 274.080 3426.0 10003.920
Mexico Paseo 662.0 10 125 82750.0 1655.000 79440.0 1655.000
Canada Paseo 1295.0 10 12 15540.0 310.800 3885.0 11344.200
Germany Paseo 809.0 10 125 101125.0 2022.500 97080.0 2022.500
Mexico Paseo 2145.0 10 125 268125.0 5362.500 257400.0 5362.500
France Paseo 1785.0 10 12 21420.0 428.400 5355.0 15636.600
Canada Paseo 1916.0 10 300 574800.0 11496.000 479000.0 84304.000
Canada Paseo 2852.0 10 350 998200.0 19964.000 741520.0 236716.000
Canada Paseo 2729.0 10 125 341125.0 6822.500 327480.0 6822.500
United States of America Paseo 1925.0 10 15 28875.0 577.500 19250.0 9047.500
United States of America Paseo 2013.0 10 7 14091.0 281.820 10065.0 3744.180
France Paseo 1055.0 10 12 12660.0 253.200 3165.0 9241.800
Mexico Paseo 1084.0 10 12 13008.0 260.160 3252.0 9495.840
United States of America Velo 1566.0 120 20 31320.0 626.400 15660.0 15033.600
Germany Velo 2966.0 120 350 1038100.0 20762.000 771160.0 246178.000
Germany Velo 2877.0 120 350 1006950.0 20139.000 748020.0 238791.000
Germany Velo 809.0 120 125 101125.0 2022.500 97080.0 2022.500
Mexico Velo 2145.0 120 125 268125.0 5362.500 257400.0 5362.500
France Velo 1055.0 120 12 12660.0 253.200 3165.0 9241.800
Mexico Velo 544.0 120 20 10880.0 217.600 5440.0 5222.400
Mexico Velo 1084.0 120 12 13008.0 260.160 3252.0 9495.840
Mexico VTT 662.0 250 125 82750.0 1655.000 79440.0 1655.000
Germany VTT 214.0 250 300 64200.0 1284.000 53500.0 9416.000
Germany VTT 2877.0 250 350 1006950.0 20139.000 748020.0 238791.000
Canada VTT 2729.0 250 125 341125.0 6822.500 327480.0 6822.500
United States of America VTT 266.0 250 350 93100.0 1862.000 69160.0 22078.000
Mexico VTT 1940.0 250 350 679000.0 13580.000 504400.0 161020.000
Germany Amarilla 259.0 260 300 77700.0 1554.000 64750.0 11396.000
Mexico Amarilla 1101.0 260 300 330300.0 6606.000 275250.0 48444.000
Germany Amarilla 2276.0 260 125 284500.0 5690.000 273120.0 5690.000
Germany Amarilla 2966.0 260 350 1038100.0 20762.000 771160.0 246178.000
United States of America Amarilla 1236.0 260 20 24720.0 494.400 12360.0 11865.600
France Amarilla 941.0 260 20 18820.0 376.400 9410.0 9033.600
Canada Amarilla 1916.0 260 300 574800.0 11496.000 479000.0 84304.000
France Carretera 4243.5 3 125 530437.5 15913.125 509220.0 5304.375
Germany Carretera 2580.0 3 20 51600.0 1548.000 25800.0 24252.000
Germany Carretera 689.0 3 300 206700.0 6201.000 172250.0 28249.000
United States of America Carretera 1947.0 3 12 23364.0 700.920 5841.0 16822.080
Canada Carretera 908.0 3 12 10896.0 326.880 2724.0 7845.120
Germany Montana 1958.0 5 7 13706.0 411.180 9790.0 3504.820
France Montana 1901.0 5 12 22812.0 684.360 5703.0 16424.640
France Montana 544.0 5 7 3808.0 114.240 2720.0 973.760
Germany Montana 1797.0 5 350 628950.0 18868.500 467220.0 142861.500
France Montana 1287.0 5 125 160875.0 4826.250 154440.0 1608.750
Germany Montana 1706.0 5 125 213250.0 6397.500 204720.0 2132.500
France Paseo 2434.5 10 300 730350.0 21910.500 608625.0 99814.500
Canada Paseo 1774.0 10 125 221750.0 6652.500 212880.0 2217.500
France Paseo 1901.0 10 12 22812.0 684.360 5703.0 16424.640
Germany Paseo 689.0 10 300 206700.0 6201.000 172250.0 28249.000
Germany Paseo 1570.0 10 125 196250.0 5887.500 188400.0 1962.500
United States of America Paseo 1369.5 10 12 16434.0 493.020 4108.5 11832.480
Canada Paseo 2009.0 10 125 251125.0 7533.750 241080.0 2511.250
Germany Paseo 1945.0 10 15 29175.0 875.250 19450.0 8849.750
France Paseo 1287.0 10 125 160875.0 4826.250 154440.0 1608.750
Germany Paseo 1706.0 10 125 213250.0 6397.500 204720.0 2132.500
Canada Velo 2009.0 120 125 251125.0 7533.750 241080.0 2511.250
United States of America VTT 2844.0 250 300 853200.0 25596.000 711000.0 116604.000
Mexico VTT 1916.0 250 12 22992.0 689.760 5748.0 16554.240
Germany VTT 1570.0 250 125 196250.0 5887.500 188400.0 1962.500
Canada VTT 1874.0 250 300 562200.0 16866.000 468500.0 76834.000
Mexico VTT 1642.0 250 350 574700.0 17241.000 426920.0 130539.000
Germany VTT 1945.0 250 15 29175.0 875.250 19450.0 8849.750
Canada Carretera 831.0 3 20 16620.0 498.600 8310.0 7811.400
Mexico Paseo 1760.0 10 7 12320.0 369.600 8800.0 3150.400
Canada Velo 3850.5 120 20 77010.0 2310.300 38505.0 36194.700
Germany VTT 2479.0 250 12 29748.0 892.440 7437.0 21418.560
Mexico Montana 2031.0 5 15 30465.0 1218.600 20310.0 8936.400
Mexico Paseo 2031.0 10 15 30465.0 1218.600 20310.0 8936.400
France Paseo 2261.0 10 15 33915.0 1356.600 22610.0 9948.400
United States of America Velo 736.0 120 20 14720.0 588.800 7360.0 6771.200
Canada Carretera 2851.0 3 7 19957.0 798.280 14255.0 4903.720
Germany Carretera 2021.0 3 300 606300.0 24252.000 505250.0 76798.000
United States of America Carretera 274.0 3 350 95900.0 3836.000 71240.0 20824.000
Canada Montana 1967.0 5 15 29505.0 1180.200 19670.0 8654.800
Germany Montana 1859.0 5 300 557700.0 22308.000 464750.0 70642.000
Canada Montana 2851.0 5 7 19957.0 798.280 14255.0 4903.720
Germany Montana 2021.0 5 300 606300.0 24252.000 505250.0 76798.000
Mexico Montana 1138.0 5 125 142250.0 5690.000 136560.0 0.000
Canada Paseo 4251.0 10 7 29757.0 1190.280 21255.0 7311.720
Germany Paseo 795.0 10 125 99375.0 3975.000 95400.0 0.000
Germany Paseo 1414.5 10 300 424350.0 16974.000 353625.0 53751.000
United States of America Paseo 2918.0 10 300 875400.0 35016.000 729500.0 110884.000
United States of America Paseo 3450.0 10 350 1207500.0 48300.000 897000.0 262200.000
France Paseo 2988.0 10 125 373500.0 14940.000 358560.0 0.000
Canada Paseo 218.0 10 15 3270.0 130.800 2180.0 959.200
Canada Paseo 2074.0 10 20 41480.0 1659.200 20740.0 19080.800
United States of America Paseo 1056.0 10 20 21120.0 844.800 10560.0 9715.200
United States of America Paseo 671.0 10 15 10065.0 402.600 6710.0 2952.400
Mexico Paseo 1514.0 10 15 22710.0 908.400 15140.0 6661.600
United States of America Paseo 274.0 10 350 95900.0 3836.000 71240.0 20824.000
Mexico Paseo 1138.0 10 125 142250.0 5690.000 136560.0 0.000
United States of America Velo 1465.0 120 12 17580.0 703.200 4395.0 12481.800
Canada Velo 2646.0 120 20 52920.0 2116.800 26460.0 24343.200
France Velo 2177.0 120 350 761950.0 30478.000 566020.0 165452.000
France VTT 866.0 250 12 10392.0 415.680 2598.0 7378.320
United States of America VTT 349.0 250 350 122150.0 4886.000 90740.0 26524.000
France VTT 2177.0 250 350 761950.0 30478.000 566020.0 165452.000
Mexico VTT 1514.0 250 15 22710.0 908.400 15140.0 6661.600
Mexico Amarilla 1865.0 260 350 652750.0 26110.000 484900.0 141740.000
Mexico Amarilla 1074.0 260 125 134250.0 5370.000 128880.0 0.000
Germany Amarilla 1907.0 260 350 667450.0 26698.000 495820.0 144932.000
United States of America Amarilla 671.0 260 15 10065.0 402.600 6710.0 2952.400
Canada Amarilla 1778.0 260 350 622300.0 24892.000 462280.0 135128.000
Germany Montana 1159.0 5 7 8113.0 405.650 5795.0 1912.350
Germany Paseo 1372.0 10 7 9604.0 480.200 6860.0 2263.800
Canada Paseo 2349.0 10 7 16443.0 822.150 11745.0 3875.850
Mexico Paseo 2689.0 10 7 18823.0 941.150 13445.0 4436.850
Canada Paseo 2431.0 10 12 29172.0 1458.600 7293.0 20420.400
Canada Velo 2431.0 120 12 29172.0 1458.600 7293.0 20420.400
Mexico VTT 2689.0 250 7 18823.0 941.150 13445.0 4436.850
Mexico Amarilla 1683.0 260 7 11781.0 589.050 8415.0 2776.950
Mexico Amarilla 1123.0 260 12 13476.0 673.800 3369.0 9433.200
Germany Amarilla 1159.0 260 7 8113.0 405.650 5795.0 1912.350
France Carretera 1865.0 3 12 22380.0 1119.000 5595.0 15666.000
Germany Carretera 1116.0 3 12 13392.0 669.600 3348.0 9374.400
France Carretera 1563.0 3 20 31260.0 1563.000 15630.0 14067.000
United States of America Carretera 991.0 3 300 297300.0 14865.000 247750.0 34685.000
Germany Carretera 1016.0 3 7 7112.0 355.600 5080.0 1676.400
Mexico Carretera 2791.0 3 15 41865.0 2093.250 27910.0 11861.750
United States of America Carretera 570.0 3 7 3990.0 199.500 2850.0 940.500
France Carretera 2487.0 3 7 17409.0 870.450 12435.0 4103.550
France Montana 1384.5 5 350 484575.0 24228.750 359970.0 100376.250
United States of America Montana 3627.0 5 125 453375.0 22668.750 435240.0 -4533.750
Mexico Montana 720.0 5 350 252000.0 12600.000 187200.0 52200.000
Germany Montana 2342.0 5 12 28104.0 1405.200 7026.0 19672.800
Mexico Montana 1100.0 5 300 330000.0 16500.000 275000.0 38500.000
France Paseo 1303.0 10 20 26060.0 1303.000 13030.0 11727.000
United States of America Paseo 2992.0 10 125 374000.0 18700.000 359040.0 -3740.000
France Paseo 2385.0 10 125 298125.0 14906.250 286200.0 -2981.250
Mexico Paseo 1607.0 10 300 482100.0 24105.000 401750.0 56245.000
United States of America Paseo 2327.0 10 7 16289.0 814.450 11635.0 3839.550
United States of America Paseo 991.0 10 300 297300.0 14865.000 247750.0 34685.000
United States of America Paseo 602.0 10 350 210700.0 10535.000 156520.0 43645.000
France Paseo 2620.0 10 15 39300.0 1965.000 26200.0 11135.000
Canada Paseo 1228.0 10 350 429800.0 21490.000 319280.0 89030.000
Canada Paseo 1389.0 10 20 27780.0 1389.000 13890.0 12501.000
United States of America Paseo 861.0 10 125 107625.0 5381.250 103320.0 -1076.250
France Paseo 704.0 10 125 88000.0 4400.000 84480.0 -880.000
Canada Paseo 1802.0 10 20 36040.0 1802.000 18020.0 16218.000
United States of America Paseo 2663.0 10 20 53260.0 2663.000 26630.0 23967.000
France Paseo 2136.0 10 7 14952.0 747.600 10680.0 3524.400
Germany Paseo 2116.0 10 15 31740.0 1587.000 21160.0 8993.000
United States of America Velo 555.0 120 15 8325.0 416.250 5550.0 2358.750
Mexico Velo 2861.0 120 15 42915.0 2145.750 28610.0 12159.250
Germany Velo 807.0 120 125 100875.0 5043.750 96840.0 -1008.750
United States of America Velo 602.0 120 350 210700.0 10535.000 156520.0 43645.000
United States of America Velo 2832.0 120 20 56640.0 2832.000 28320.0 25488.000
France Velo 1579.0 120 20 31580.0 1579.000 15790.0 14211.000
United States of America Velo 861.0 120 125 107625.0 5381.250 103320.0 -1076.250
France Velo 704.0 120 125 88000.0 4400.000 84480.0 -880.000
France Velo 1033.0 120 20 20660.0 1033.000 10330.0 9297.000
Germany Velo 1250.0 120 300 375000.0 18750.000 312500.0 43750.000
Canada VTT 1389.0 250 20 27780.0 1389.000 13890.0 12501.000
United States of America VTT 1265.0 250 20 25300.0 1265.000 12650.0 11385.000
Germany VTT 2297.0 250 20 45940.0 2297.000 22970.0 20673.000
United States of America VTT 2663.0 250 20 53260.0 2663.000 26630.0 23967.000
United States of America VTT 570.0 250 7 3990.0 199.500 2850.0 940.500
France VTT 2487.0 250 7 17409.0 870.450 12435.0 4103.550
Germany Amarilla 1350.0 260 350 472500.0 23625.000 351000.0 97875.000
Canada Amarilla 552.0 260 350 193200.0 9660.000 143520.0 40020.000
Canada Amarilla 1228.0 260 350 429800.0 21490.000 319280.0 89030.000
Germany Amarilla 1250.0 260 300 375000.0 18750.000 312500.0 43750.000
France Paseo 3801.0 10 15 57015.0 3420.900 38010.0 15584.100
United States of America Carretera 1117.5 3 20 22350.0 1341.000 11175.0 9834.000
Canada Carretera 2844.0 3 15 42660.0 2559.600 28440.0 11660.400
Mexico Carretera 562.0 3 12 6744.0 404.640 1686.0 4653.360
Canada Carretera 2299.0 3 12 27588.0 1655.280 6897.0 19035.720
United States of America Carretera 2030.0 3 15 30450.0 1827.000 20300.0 8323.000
United States of America Carretera 263.0 3 7 1841.0 110.460 1315.0 415.540
Germany Carretera 887.0 3 125 110875.0 6652.500 106440.0 -2217.500
Mexico Montana 980.0 5 350 343000.0 20580.000 254800.0 67620.000
Germany Montana 1460.0 5 350 511000.0 30660.000 379600.0 100740.000
France Montana 1403.0 5 7 9821.0 589.260 7015.0 2216.740
United States of America Montana 2723.0 5 12 32676.0 1960.560 8169.0 22546.440
France Paseo 1496.0 10 350 523600.0 31416.000 388960.0 103224.000
Canada Paseo 2299.0 10 12 27588.0 1655.280 6897.0 19035.720
United States of America Paseo 727.0 10 350 254450.0 15267.000 189020.0 50163.000
Canada Velo 952.0 120 125 119000.0 7140.000 114240.0 -2380.000
United States of America Velo 2755.0 120 125 344375.0 20662.500 330600.0 -6887.500
Germany Velo 1530.0 120 15 22950.0 1377.000 15300.0 6273.000
France Velo 1496.0 120 350 523600.0 31416.000 388960.0 103224.000
Mexico Velo 1498.0 120 7 10486.0 629.160 7490.0 2366.840
France Velo 1221.0 120 300 366300.0 21978.000 305250.0 39072.000
France Velo 2076.0 120 350 726600.0 43596.000 539760.0 143244.000
Canada VTT 2844.0 250 15 42660.0 2559.600 28440.0 11660.400
Mexico VTT 1498.0 250 7 10486.0 629.160 7490.0 2366.840
France VTT 1221.0 250 300 366300.0 21978.000 305250.0 39072.000
Mexico VTT 1123.0 250 20 22460.0 1347.600 11230.0 9882.400
Canada VTT 2436.0 250 300 730800.0 43848.000 609000.0 77952.000
France Amarilla 1987.5 260 125 248437.5 14906.250 238500.0 -4968.750
Mexico Amarilla 1679.0 260 350 587650.0 35259.000 436540.0 115851.000
United States of America Amarilla 727.0 260 350 254450.0 15267.000 189020.0 50163.000
France Amarilla 1403.0 260 7 9821.0 589.260 7015.0 2216.740
France Amarilla 2076.0 260 350 726600.0 43596.000 539760.0 143244.000
France Montana 1757.0 5 20 35140.0 2108.400 17570.0 15461.600
United States of America Paseo 2198.0 10 15 32970.0 1978.200 21980.0 9011.800
Germany Paseo 1743.0 10 15 26145.0 1568.700 17430.0 7146.300
United States of America Paseo 1153.0 10 15 17295.0 1037.700 11530.0 4727.300
France Paseo 1757.0 10 20 35140.0 2108.400 17570.0 15461.600
Germany Velo 1001.0 120 20 20020.0 1201.200 10010.0 8808.800
Mexico Velo 1333.0 120 7 9331.0 559.860 6665.0 2106.140
United States of America VTT 1153.0 250 15 17295.0 1037.700 11530.0 4727.300
Mexico Carretera 727.0 3 12 8724.0 610.680 2181.0 5932.320
Canada Carretera 1884.0 3 12 22608.0 1582.560 5652.0 15373.440
Mexico Carretera 1834.0 3 20 36680.0 2567.600 18340.0 15772.400
Mexico Montana 2340.0 5 12 28080.0 1965.600 7020.0 19094.400
France Montana 2342.0 5 12 28104.0 1967.280 7026.0 19110.720
France Paseo 1031.0 10 7 7217.0 505.190 5155.0 1556.810
Canada Velo 1262.0 120 15 18930.0 1325.100 12620.0 4984.900
Canada Velo 1135.0 120 7 7945.0 556.150 5675.0 1713.850
United States of America Velo 547.0 120 7 3829.0 268.030 2735.0 825.970
Canada Velo 1582.0 120 7 11074.0 775.180 7910.0 2388.820
France VTT 1738.5 250 12 20862.0 1460.340 5215.5 14186.160
Germany VTT 2215.0 250 12 26580.0 1860.600 6645.0 18074.400
Canada VTT 1582.0 250 7 11074.0 775.180 7910.0 2388.820
Canada Amarilla 1135.0 260 7 7945.0 556.150 5675.0 1713.850
United States of America Carretera 1761.0 3 350 616350.0 43144.500 457860.0 115345.500
France Carretera 448.0 3 300 134400.0 9408.000 112000.0 12992.000
France Carretera 2181.0 3 300 654300.0 45801.000 545250.0 63249.000
France Montana 1976.0 5 20 39520.0 2766.400 19760.0 16993.600
France Montana 2181.0 5 300 654300.0 45801.000 545250.0 63249.000
Germany Montana 2500.0 5 125 312500.0 21875.000 300000.0 -9375.000
Canada Paseo 1702.0 10 300 510600.0 35742.000 425500.0 49358.000
France Paseo 448.0 10 300 134400.0 9408.000 112000.0 12992.000
Germany Paseo 3513.0 10 125 439125.0 30738.750 421560.0 -13173.750
France Paseo 2101.0 10 15 31515.0 2206.050 21010.0 8298.950
United States of America Paseo 2931.0 10 15 43965.0 3077.550 29310.0 11577.450
France Paseo 1535.0 10 20 30700.0 2149.000 15350.0 13201.000
Germany Paseo 1123.0 10 300 336900.0 23583.000 280750.0 32567.000
Canada Paseo 1404.0 10 300 421200.0 29484.000 351000.0 40716.000
Mexico Paseo 2763.0 10 12 33156.0 2320.920 8289.0 22546.080
Germany Paseo 2125.0 10 7 14875.0 1041.250 10625.0 3208.750
France Velo 1659.0 120 300 497700.0 34839.000 414750.0 48111.000
Mexico Velo 609.0 120 20 12180.0 852.600 6090.0 5237.400
Germany Velo 2087.0 120 125 260875.0 18261.250 250440.0 -7826.250
France Velo 1976.0 120 20 39520.0 2766.400 19760.0 16993.600
United States of America Velo 1421.0 120 20 28420.0 1989.400 14210.0 12220.600
United States of America Velo 1372.0 120 300 411600.0 28812.000 343000.0 39788.000
Germany Velo 588.0 120 20 11760.0 823.200 5880.0 5056.800
Canada VTT 3244.5 250 12 38934.0 2725.380 9733.5 26475.120
France VTT 959.0 250 300 287700.0 20139.000 239750.0 27811.000
Mexico VTT 2747.0 250 300 824100.0 57687.000 686750.0 79663.000
Canada Amarilla 1645.0 260 125 205625.0 14393.750 197400.0 -6168.750
France Amarilla 2876.0 260 350 1006600.0 70462.000 747760.0 188378.000
Germany Amarilla 994.0 260 125 124250.0 8697.500 119280.0 -3727.500
Canada Amarilla 1118.0 260 20 22360.0 1565.200 11180.0 9614.800
United States of America Amarilla 1372.0 260 300 411600.0 28812.000 343000.0 39788.000
Canada Montana 488.0 5 7 3416.0 273.280 2440.0 702.720
United States of America Montana 1282.0 5 20 25640.0 2051.200 12820.0 10768.800
Canada Paseo 257.0 10 7 1799.0 143.920 1285.0 370.080
United States of America Amarilla 1282.0 260 20 25640.0 2051.200 12820.0 10768.800
Mexico Carretera 1540.0 3 125 192500.0 15400.000 184800.0 -7700.000
France Carretera 490.0 3 15 7350.0 588.000 4900.0 1862.000
Mexico Carretera 1362.0 3 350 476700.0 38136.000 354120.0 84444.000
France Montana 2501.0 5 15 37515.0 3001.200 25010.0 9503.800
Canada Montana 708.0 5 20 14160.0 1132.800 7080.0 5947.200
Germany Montana 645.0 5 20 12900.0 1032.000 6450.0 5418.000
France Montana 1562.0 5 300 468600.0 37488.000 390500.0 40612.000
Canada Montana 1283.0 5 300 384900.0 30792.000 320750.0 33358.000
Germany Montana 711.0 5 15 10665.0 853.200 7110.0 2701.800
Mexico Paseo 1114.0 10 125 139250.0 11140.000 133680.0 -5570.000
Germany Paseo 1259.0 10 7 8813.0 705.040 6295.0 1812.960
Germany Paseo 1095.0 10 7 7665.0 613.200 5475.0 1576.800
Germany Paseo 1366.0 10 20 27320.0 2185.600 13660.0 11474.400
Mexico Paseo 2460.0 10 300 738000.0 59040.000 615000.0 63960.000
United States of America Paseo 678.0 10 7 4746.0 379.680 3390.0 976.320
Germany Paseo 1598.0 10 7 11186.0 894.880 7990.0 2301.120
Germany Paseo 2409.0 10 7 16863.0 1349.040 12045.0 3468.960
Germany Paseo 1934.0 10 20 38680.0 3094.400 19340.0 16245.600
Mexico Paseo 2993.0 10 20 59860.0 4788.800 29930.0 25141.200
Germany Paseo 2146.0 10 350 751100.0 60088.000 557960.0 133052.000
Mexico Paseo 1946.0 10 7 13622.0 1089.760 9730.0 2802.240
Mexico Paseo 1362.0 10 350 476700.0 38136.000 354120.0 84444.000
Canada Velo 598.0 120 12 7176.0 574.080 1794.0 4807.920
United States of America Velo 2907.0 120 7 20349.0 1627.920 14535.0 4186.080
Germany Velo 2338.0 120 7 16366.0 1309.280 11690.0 3366.720
France Velo 386.0 120 300 115800.0 9264.000 96500.0 10036.000
Mexico Velo 635.0 120 300 190500.0 15240.000 158750.0 16510.000
France VTT 574.5 250 350 201075.0 16086.000 149370.0 35619.000
Germany VTT 2338.0 250 7 16366.0 1309.280 11690.0 3366.720
France VTT 381.0 250 350 133350.0 10668.000 99060.0 23622.000
Germany VTT 422.0 250 350 147700.0 11816.000 109720.0 26164.000
Canada VTT 2134.0 250 300 640200.0 51216.000 533500.0 55484.000
United States of America VTT 808.0 250 300 242400.0 19392.000 202000.0 21008.000
Canada Amarilla 708.0 260 20 14160.0 1132.800 7080.0 5947.200
United States of America Amarilla 2907.0 260 7 20349.0 1627.920 14535.0 4186.080
Germany Amarilla 1366.0 260 20 27320.0 2185.600 13660.0 11474.400
Mexico Amarilla 2460.0 260 300 738000.0 59040.000 615000.0 63960.000
Germany Amarilla 1520.0 260 20 30400.0 2432.000 15200.0 12768.000
Germany Amarilla 711.0 260 15 10665.0 853.200 7110.0 2701.800
Mexico Amarilla 1375.0 260 12 16500.0 1320.000 4125.0 11055.000
Mexico Amarilla 635.0 260 300 190500.0 15240.000 158750.0 16510.000
United States of America VTT 436.5 250 20 8730.0 698.400 4365.0 3666.600
Canada Carretera 1094.0 3 300 328200.0 29538.000 273500.0 25162.000
Mexico Carretera 367.0 3 12 4404.0 396.360 1101.0 2906.640
Canada Montana 3802.5 5 300 1140750.0 102667.500 950625.0 87457.500
France Montana 1666.0 5 350 583100.0 52479.000 433160.0 97461.000
France Montana 322.0 5 300 96600.0 8694.000 80500.0 7406.000
Canada Montana 2321.0 5 12 27852.0 2506.680 6963.0 18382.320
France Montana 1857.0 5 125 232125.0 20891.250 222840.0 -11606.250
Canada Montana 1611.0 5 7 11277.0 1014.930 8055.0 2207.070
United States of America Montana 2797.0 5 125 349625.0 31466.250 335640.0 -17481.250
Germany Montana 334.0 5 300 100200.0 9018.000 83500.0 7682.000
Mexico Paseo 2565.0 10 300 769500.0 69255.000 641250.0 58995.000
Mexico Paseo 2417.0 10 350 845950.0 76135.500 628420.0 141394.500
United States of America Paseo 3675.0 10 15 55125.0 4961.250 36750.0 13413.750
Canada Paseo 1094.0 10 300 328200.0 29538.000 273500.0 25162.000
France Paseo 1227.0 10 15 18405.0 1656.450 12270.0 4478.550
Mexico Paseo 367.0 10 12 4404.0 396.360 1101.0 2906.640
France Paseo 1324.0 10 300 397200.0 35748.000 331000.0 30452.000
Germany Paseo 1775.0 10 12 21300.0 1917.000 5325.0 14058.000
United States of America Paseo 2797.0 10 125 349625.0 31466.250 335640.0 -17481.250
Mexico Velo 245.0 120 15 3675.0 330.750 2450.0 894.250
Canada Velo 3793.5 120 300 1138050.0 102424.500 948375.0 87250.500
Germany Velo 1307.0 120 350 457450.0 41170.500 339820.0 76459.500
Canada Velo 567.0 120 125 70875.0 6378.750 68040.0 -3543.750
Mexico Velo 2110.0 120 125 263750.0 23737.500 253200.0 -13187.500
Canada Velo 1269.0 120 350 444150.0 39973.500 329940.0 74236.500
United States of America VTT 1956.0 250 12 23472.0 2112.480 5868.0 15491.520
Germany VTT 2659.0 250 300 797700.0 71793.000 664750.0 61157.000
United States of America VTT 1351.5 250 350 473025.0 42572.250 351390.0 79062.750
Germany VTT 880.0 250 12 10560.0 950.400 2640.0 6969.600
United States of America VTT 1867.0 250 300 560100.0 50409.000 466750.0 42941.000
France VTT 2234.0 250 12 26808.0 2412.720 6702.0 17693.280
France VTT 1227.0 250 15 18405.0 1656.450 12270.0 4478.550
Mexico VTT 877.0 250 125 109625.0 9866.250 105240.0 -5481.250
United States of America Amarilla 2071.0 260 350 724850.0 65236.500 538460.0 121153.500
Canada Amarilla 1269.0 260 350 444150.0 39973.500 329940.0 74236.500
Germany Amarilla 970.0 260 15 14550.0 1309.500 9700.0 3540.500
Mexico Amarilla 1694.0 260 20 33880.0 3049.200 16940.0 13890.800
Germany Carretera 663.0 3 20 13260.0 1193.400 6630.0 5436.600
Canada Carretera 819.0 3 7 5733.0 515.970 4095.0 1122.030
Germany Carretera 1580.0 3 12 18960.0 1706.400 4740.0 12513.600
Mexico Carretera 521.0 3 7 3647.0 328.230 2605.0 713.770
United States of America Paseo 973.0 10 20 19460.0 1751.400 9730.0 7978.600
Mexico Paseo 1038.0 10 20 20760.0 1868.400 10380.0 8511.600
Germany Paseo 360.0 10 7 2520.0 226.800 1800.0 493.200
France Velo 1967.0 120 12 23604.0 2124.360 5901.0 15578.640
Mexico Velo 2628.0 120 15 39420.0 3547.800 26280.0 9592.200
Germany VTT 360.0 250 7 2520.0 226.800 1800.0 493.200
France VTT 2682.0 250 20 53640.0 4827.600 26820.0 21992.400
Mexico VTT 521.0 250 7 3647.0 328.230 2605.0 713.770
Mexico Amarilla 1038.0 260 20 20760.0 1868.400 10380.0 8511.600
Canada Amarilla 1630.5 260 15 24457.5 2201.175 16305.0 5951.325
France Amarilla 306.0 260 12 3672.0 330.480 918.0 2423.520
United States of America Carretera 386.0 3 12 4632.0 463.200 1158.0 3010.800
United States of America Montana 2328.0 5 7 16296.0 1629.600 11640.0 3026.400
United States of America Paseo 386.0 10 12 4632.0 463.200 1158.0 3010.800
United States of America Carretera 3445.5 3 125 430687.5 43068.750 413460.0 -25841.250
France Carretera 1482.0 3 125 185250.0 18525.000 177840.0 -11115.000
United States of America Montana 2313.0 5 350 809550.0 80955.000 601380.0 127215.000
United States of America Montana 1804.0 5 125 225500.0 22550.000 216480.0 -13530.000
France Montana 2072.0 5 15 31080.0 3108.000 20720.0 7252.000
France Paseo 1954.0 10 20 39080.0 3908.000 19540.0 15632.000
Mexico Paseo 591.0 10 300 177300.0 17730.000 147750.0 11820.000
France Paseo 2167.0 10 15 32505.0 3250.500 21670.0 7584.500
Germany Paseo 241.0 10 20 4820.0 482.000 2410.0 1928.000
Germany Velo 681.0 120 15 10215.0 1021.500 6810.0 2383.500
Germany Velo 510.0 120 15 7650.0 765.000 5100.0 1785.000
United States of America Velo 790.0 120 15 11850.0 1185.000 7900.0 2765.000
France Velo 639.0 120 350 223650.0 22365.000 166140.0 35145.000
United States of America Velo 1596.0 120 125 199500.0 19950.000 191520.0 -11970.000
United States of America Velo 2294.0 120 300 688200.0 68820.000 573500.0 45880.000
Germany Velo 241.0 120 20 4820.0 482.000 2410.0 1928.000
Germany Velo 2665.0 120 7 18655.0 1865.500 13325.0 3464.500
Canada Velo 1916.0 120 125 239500.0 23950.000 229920.0 -14370.000
France Velo 853.0 120 300 255900.0 25590.000 213250.0 17060.000
Mexico VTT 341.0 250 125 42625.0 4262.500 40920.0 -2557.500
Mexico VTT 641.0 250 15 9615.0 961.500 6410.0 2243.500
United States of America VTT 2807.0 250 350 982450.0 98245.000 729820.0 154385.000
Mexico VTT 432.0 250 300 129600.0 12960.000 108000.0 8640.000
United States of America VTT 2294.0 250 300 688200.0 68820.000 573500.0 45880.000
France VTT 2167.0 250 15 32505.0 3250.500 21670.0 7584.500
Canada VTT 2529.0 250 125 316125.0 31612.500 303480.0 -18967.500
Germany VTT 1870.0 250 350 654500.0 65450.000 486200.0 102850.000
United States of America Amarilla 579.0 260 125 72375.0 7237.500 69480.0 -4342.500
Canada Amarilla 2240.0 260 350 784000.0 78400.000 582400.0 123200.000
United States of America Amarilla 2993.0 260 300 897900.0 89790.000 748250.0 59860.000
Canada Amarilla 3520.5 260 12 42246.0 4224.600 10561.5 27459.900
Mexico Amarilla 2039.0 260 20 40780.0 4078.000 20390.0 16312.000
Germany Amarilla 2574.0 260 12 30888.0 3088.800 7722.0 20077.200
Canada Amarilla 707.0 260 350 247450.0 24745.000 183820.0 38885.000
France Amarilla 2072.0 260 15 31080.0 3108.000 20720.0 7252.000
France Amarilla 853.0 260 300 255900.0 25590.000 213250.0 17060.000
France Carretera 1198.0 3 12 14376.0 1581.360 3594.0 9200.640
France Paseo 2532.0 10 7 17724.0 1949.640 12660.0 3114.360
France Paseo 1198.0 10 12 14376.0 1581.360 3594.0 9200.640
Canada Velo 384.0 120 15 5760.0 633.600 3840.0 1286.400
Germany Velo 472.0 120 12 5664.0 623.040 1416.0 3624.960
United States of America VTT 1579.0 250 7 11053.0 1215.830 7895.0 1942.170
Mexico VTT 1005.0 250 12 12060.0 1326.600 3015.0 7718.400
United States of America Amarilla 3199.5 260 15 47992.5 5279.175 31995.0 10718.325
Germany Amarilla 472.0 260 12 5664.0 623.040 1416.0 3624.960
Canada Carretera 1937.0 3 12 23244.0 2556.840 5811.0 14876.160
Germany Carretera 792.0 3 350 277200.0 30492.000 205920.0 40788.000
Germany Carretera 2811.0 3 300 843300.0 92763.000 702750.0 47787.000
France Carretera 2441.0 3 125 305125.0 33563.750 292920.0 -21358.750
Canada Carretera 1560.0 3 15 23400.0 2574.000 15600.0 5226.000
Mexico Carretera 2706.0 3 7 18942.0 2083.620 13530.0 3328.380
Germany Montana 766.0 5 350 268100.0 29491.000 199160.0 39449.000
Germany Montana 2992.0 5 20 59840.0 6582.400 29920.0 23337.600
Mexico Montana 2157.0 5 15 32355.0 3559.050 21570.0 7225.950
Canada Paseo 873.0 10 300 261900.0 28809.000 218250.0 14841.000
Mexico Paseo 1122.0 10 20 22440.0 2468.400 11220.0 8751.600
Canada Paseo 2104.5 10 350 736575.0 81023.250 547170.0 108381.750
Canada Paseo 4026.0 10 12 48312.0 5314.320 12078.0 30919.680
France Paseo 2425.5 10 12 29106.0 3201.660 7276.5 18627.840
Canada Paseo 2394.0 10 20 47880.0 5266.800 23940.0 18673.200
Mexico Paseo 1984.0 10 15 29760.0 3273.600 19840.0 6646.400
France Paseo 2441.0 10 125 305125.0 33563.750 292920.0 -21358.750
Germany Paseo 2992.0 10 20 59840.0 6582.400 29920.0 23337.600
Canada Paseo 1366.0 10 300 409800.0 45078.000 341500.0 23222.000
France Velo 2805.0 120 20 56100.0 6171.000 28050.0 21879.000
Mexico Velo 655.0 120 15 9825.0 1080.750 6550.0 2194.250
Mexico Velo 344.0 120 350 120400.0 13244.000 89440.0 17716.000
Canada Velo 1808.0 120 7 12656.0 1392.160 9040.0 2223.840
France VTT 1734.0 250 12 20808.0 2288.880 5202.0 13317.120
Mexico VTT 554.0 250 125 69250.0 7617.500 66480.0 -4847.500
Canada VTT 2935.0 250 20 58700.0 6457.000 29350.0 22893.000
Germany Amarilla 3165.0 260 125 395625.0 43518.750 379800.0 -27693.750
Mexico Amarilla 2629.0 260 20 52580.0 5783.800 26290.0 20506.200
France Amarilla 1433.0 260 125 179125.0 19703.750 171960.0 -12538.750
Mexico Amarilla 947.0 260 125 118375.0 13021.250 113640.0 -8286.250
Mexico Amarilla 344.0 260 350 120400.0 13244.000 89440.0 17716.000
Mexico Amarilla 2157.0 260 15 32355.0 3559.050 21570.0 7225.950
United States of America Paseo 380.0 10 7 2660.0 292.600 1900.0 467.400
Mexico Carretera 886.0 3 350 310100.0 37212.000 230360.0 42528.000
Canada Carretera 2416.0 3 125 302000.0 36240.000 289920.0 -24160.000
Mexico Carretera 2156.0 3 125 269500.0 32340.000 258720.0 -21560.000
Canada Carretera 2689.0 3 15 40335.0 4840.200 26890.0 8604.800
United States of America Montana 677.0 5 15 10155.0 1218.600 6770.0 2166.400
France Montana 1773.0 5 300 531900.0 63828.000 443250.0 24822.000
Mexico Montana 2420.0 5 7 16940.0 2032.800 12100.0 2807.200
Canada Montana 2734.0 5 7 19138.0 2296.560 13670.0 3171.440
Mexico Montana 1715.0 5 20 34300.0 4116.000 17150.0 13034.000
France Montana 1186.0 5 300 355800.0 42696.000 296500.0 16604.000
United States of America Paseo 3495.0 10 300 1048500.0 125820.000 873750.0 48930.000
Mexico Paseo 886.0 10 350 310100.0 37212.000 230360.0 42528.000
Mexico Paseo 2156.0 10 125 269500.0 32340.000 258720.0 -21560.000
Mexico Paseo 905.0 10 20 18100.0 2172.000 9050.0 6878.000
Mexico Paseo 1715.0 10 20 34300.0 4116.000 17150.0 13034.000
France Paseo 1594.0 10 350 557900.0 66948.000 414440.0 76512.000
Germany Paseo 1359.0 10 300 407700.0 48924.000 339750.0 19026.000
Mexico Paseo 2150.0 10 300 645000.0 77400.000 537500.0 30100.000
Mexico Paseo 1197.0 10 350 418950.0 50274.000 311220.0 57456.000
Mexico Paseo 380.0 10 15 5700.0 684.000 3800.0 1216.000
Mexico Paseo 1233.0 10 20 24660.0 2959.200 12330.0 9370.800
Mexico Velo 1395.0 120 350 488250.0 58590.000 362700.0 66960.000
United States of America Velo 986.0 120 350 345100.0 41412.000 256360.0 47328.000
Mexico Velo 905.0 120 20 18100.0 2172.000 9050.0 6878.000
Canada VTT 2109.0 250 12 25308.0 3036.960 6327.0 15944.040
France VTT 3874.5 250 15 58117.5 6974.100 38745.0 12398.400
Canada VTT 623.0 250 350 218050.0 26166.000 161980.0 29904.000
United States of America VTT 986.0 250 350 345100.0 41412.000 256360.0 47328.000
United States of America VTT 2387.0 250 125 298375.0 35805.000 286440.0 -23870.000
Mexico VTT 1233.0 250 20 24660.0 2959.200 12330.0 9370.800
United States of America Amarilla 270.0 260 350 94500.0 11340.000 70200.0 12960.000
France Amarilla 3421.5 260 7 23950.5 2874.060 17107.5 3968.940
Canada Amarilla 2734.0 260 7 19138.0 2296.560 13670.0 3171.440
United States of America Amarilla 2548.0 260 15 38220.0 4586.400 25480.0 8153.600
France Carretera 2521.5 3 20 50430.0 6051.600 25215.0 19163.400
Mexico Montana 2661.0 5 12 31932.0 3831.840 7983.0 20117.160
Germany Paseo 1531.0 10 20 30620.0 3674.400 15310.0 11635.600
France VTT 1491.0 250 7 10437.0 1252.440 7455.0 1729.560
Germany VTT 1531.0 250 20 30620.0 3674.400 15310.0 11635.600
Canada Amarilla 2761.0 260 12 33132.0 3975.840 8283.0 20873.160
United States of America Carretera 2567.0 3 15 38505.0 5005.650 25670.0 7829.350
United States of America VTT 2567.0 250 15 38505.0 5005.650 25670.0 7829.350
Canada Carretera 923.0 3 350 323050.0 41996.500 239980.0 41073.500
France Carretera 1790.0 3 350 626500.0 81445.000 465400.0 79655.000
Germany Carretera 442.0 3 20 8840.0 1149.200 4420.0 3270.800
United States of America Montana 982.5 5 350 343875.0 44703.750 255450.0 43721.250
United States of America Montana 1298.0 5 7 9086.0 1181.180 6490.0 1414.820
Mexico Montana 604.0 5 12 7248.0 942.240 1812.0 4493.760
Mexico Montana 2255.0 5 20 45100.0 5863.000 22550.0 16687.000
Canada Montana 1249.0 5 20 24980.0 3247.400 12490.0 9242.600
United States of America Paseo 1438.5 10 7 10069.5 1309.035 7192.5 1567.965
Germany Paseo 807.0 10 300 242100.0 31473.000 201750.0 8877.000
United States of America Paseo 2641.0 10 20 52820.0 6866.600 26410.0 19543.400
Germany Paseo 2708.0 10 20 54160.0 7040.800 27080.0 20039.200
Canada Paseo 2632.0 10 350 921200.0 119756.000 684320.0 117124.000
Canada Paseo 1583.0 10 125 197875.0 25723.750 189960.0 -17808.750
Mexico Paseo 571.0 10 12 6852.0 890.760 1713.0 4248.240
France Paseo 2696.0 10 7 18872.0 2453.360 13480.0 2938.640
Canada Paseo 1565.0 10 15 23475.0 3051.750 15650.0 4773.250
Canada Paseo 1249.0 10 20 24980.0 3247.400 12490.0 9242.600
Germany Paseo 357.0 10 350 124950.0 16243.500 92820.0 15886.500
Germany Paseo 1013.0 10 12 12156.0 1580.280 3039.0 7536.720
France Velo 3997.5 120 15 59962.5 7795.125 39975.0 12192.375
Canada Velo 2632.0 120 350 921200.0 119756.000 684320.0 117124.000
France Velo 1190.0 120 7 8330.0 1082.900 5950.0 1297.100
Mexico Velo 604.0 120 12 7248.0 942.240 1812.0 4493.760
Germany Velo 660.0 120 15 9900.0 1287.000 6600.0 2013.000
Mexico Velo 410.0 120 12 4920.0 639.600 1230.0 3050.400
Mexico Velo 2605.0 120 300 781500.0 101595.000 651250.0 28655.000
Germany Velo 1013.0 120 12 12156.0 1580.280 3039.0 7536.720
Canada VTT 1583.0 250 125 197875.0 25723.750 189960.0 -17808.750
Canada VTT 1565.0 250 15 23475.0 3051.750 15650.0 4773.250
Canada Amarilla 1659.0 260 125 207375.0 26958.750 199080.0 -18663.750
France Amarilla 1190.0 260 7 8330.0 1082.900 5950.0 1297.100
Mexico Amarilla 410.0 260 12 4920.0 639.600 1230.0 3050.400
Germany Amarilla 1770.0 260 12 21240.0 2761.200 5310.0 13168.800
Mexico Carretera 2579.0 3 20 51580.0 7221.200 25790.0 18568.800
United States of America Carretera 1743.0 3 20 34860.0 4880.400 17430.0 12549.600
United States of America Carretera 2996.0 3 7 20972.0 2936.080 14980.0 3055.920
Germany Carretera 280.0 3 7 1960.0 274.400 1400.0 285.600
France Montana 293.0 5 7 2051.0 287.140 1465.0 298.860
United States of America Montana 2996.0 5 7 20972.0 2936.080 14980.0 3055.920
Germany Paseo 278.0 10 15 4170.0 583.800 2780.0 806.200
Canada Paseo 2428.0 10 20 48560.0 6798.400 24280.0 17481.600
United States of America Paseo 1767.0 10 15 26505.0 3710.700 17670.0 5124.300
France Paseo 1393.0 10 12 16716.0 2340.240 4179.0 10196.760
Germany VTT 280.0 250 7 1960.0 274.400 1400.0 285.600
France Amarilla 1393.0 260 12 16716.0 2340.240 4179.0 10196.760
United States of America Amarilla 2015.0 260 12 24180.0 3385.200 6045.0 14749.800
Mexico Carretera 801.0 3 300 240300.0 33642.000 200250.0 6408.000
France Carretera 1023.0 3 125 127875.0 17902.500 122760.0 -12787.500
Canada Carretera 1496.0 3 300 448800.0 62832.000 374000.0 11968.000
United States of America Carretera 1010.0 3 300 303000.0 42420.000 252500.0 8080.000
Germany Carretera 1513.0 3 15 22695.0 3177.300 15130.0 4387.700
Canada Carretera 2300.0 3 15 34500.0 4830.000 23000.0 6670.000
Mexico Carretera 2821.0 3 125 352625.0 49367.500 338520.0 -35262.500
Canada Montana 2227.5 5 350 779625.0 109147.500 579150.0 91327.500
Germany Montana 1199.0 5 350 419650.0 58751.000 311740.0 49159.000
Canada Montana 200.0 5 350 70000.0 9800.000 52000.0 8200.000
Canada Montana 388.0 5 7 2716.0 380.240 1940.0 395.760
Mexico Montana 1727.0 5 7 12089.0 1692.460 8635.0 1761.540
Canada Montana 2300.0 5 15 34500.0 4830.000 23000.0 6670.000
Mexico Paseo 260.0 10 20 5200.0 728.000 2600.0 1872.000
Canada Paseo 2470.0 10 15 37050.0 5187.000 24700.0 7163.000
Canada Paseo 1743.0 10 15 26145.0 3660.300 17430.0 5054.700
United States of America Paseo 2914.0 10 12 34968.0 4895.520 8742.0 21330.480
France Paseo 1731.0 10 7 12117.0 1696.380 8655.0 1765.620
Canada Paseo 700.0 10 350 245000.0 34300.000 182000.0 28700.000
Canada Paseo 2222.0 10 12 26664.0 3732.960 6666.0 16265.040
United States of America Paseo 1177.0 10 350 411950.0 57673.000 306020.0 48257.000
France Paseo 1922.0 10 350 672700.0 94178.000 499720.0 78802.000
Mexico Velo 1575.0 120 125 196875.0 27562.500 189000.0 -19687.500
United States of America Velo 606.0 120 20 12120.0 1696.800 6060.0 4363.200
United States of America Velo 2460.0 120 300 738000.0 103320.000 615000.0 19680.000
Canada Velo 269.0 120 300 80700.0 11298.000 67250.0 2152.000
Germany Velo 2536.0 120 300 760800.0 106512.000 634000.0 20288.000
Mexico VTT 2903.0 250 7 20321.0 2844.940 14515.0 2961.060
United States of America VTT 2541.0 250 300 762300.0 106722.000 635250.0 20328.000
Canada VTT 269.0 250 300 80700.0 11298.000 67250.0 2152.000
Canada VTT 1496.0 250 300 448800.0 62832.000 374000.0 11968.000
United States of America VTT 1010.0 250 300 303000.0 42420.000 252500.0 8080.000
France VTT 1281.0 250 350 448350.0 62769.000 333060.0 52521.000
Canada Amarilla 888.0 260 300 266400.0 37296.000 222000.0 7104.000
United States of America Amarilla 2844.0 260 125 355500.0 49770.000 341280.0 -35550.000
France Amarilla 2475.0 260 12 29700.0 4158.000 7425.0 18117.000
Canada Amarilla 1743.0 260 15 26145.0 3660.300 17430.0 5054.700
United States of America Amarilla 2914.0 260 12 34968.0 4895.520 8742.0 21330.480
France Amarilla 1731.0 260 7 12117.0 1696.380 8655.0 1765.620
Mexico Amarilla 1727.0 260 7 12089.0 1692.460 8635.0 1761.540
Mexico Amarilla 1870.0 260 15 28050.0 3927.000 18700.0 5423.000
France Carretera 1174.0 3 125 146750.0 22012.500 140880.0 -16142.500
Germany Carretera 2767.0 3 125 345875.0 51881.250 332040.0 -38046.250
Germany Carretera 1085.0 3 125 135625.0 20343.750 130200.0 -14918.750
Mexico Montana 546.0 5 300 163800.0 24570.000 136500.0 2730.000
Germany Paseo 1158.0 10 20 23160.0 3474.000 11580.0 8106.000
Canada Paseo 1614.0 10 15 24210.0 3631.500 16140.0 4438.500
Mexico Paseo 2535.0 10 7 17745.0 2661.750 12675.0 2408.250
Mexico Paseo 2851.0 10 350 997850.0 149677.500 741260.0 106912.500
Canada Paseo 2559.0 10 15 38385.0 5757.750 25590.0 7037.250
United States of America Paseo 267.0 10 20 5340.0 801.000 2670.0 1869.000
Germany Paseo 1085.0 10 125 135625.0 20343.750 130200.0 -14918.750
Germany Paseo 1175.0 10 15 17625.0 2643.750 11750.0 3231.250
United States of America Paseo 2007.0 10 350 702450.0 105367.500 521820.0 75262.500
Mexico Paseo 2151.0 10 350 752850.0 112927.500 559260.0 80662.500
United States of America Paseo 914.0 10 12 10968.0 1645.200 2742.0 6580.800
France Paseo 293.0 10 20 5860.0 879.000 2930.0 2051.000
Mexico Velo 500.0 120 12 6000.0 900.000 1500.0 3600.000
France Velo 2826.0 120 15 42390.0 6358.500 28260.0 7771.500
France Velo 663.0 120 125 82875.0 12431.250 79560.0 -9116.250
United States of America Velo 2574.0 120 300 772200.0 115830.000 643500.0 12870.000
United States of America Velo 2438.0 120 125 304750.0 45712.500 292560.0 -33522.500
United States of America Velo 914.0 120 12 10968.0 1645.200 2742.0 6580.800
Canada VTT 865.5 250 20 17310.0 2596.500 8655.0 6058.500
Germany VTT 492.0 250 15 7380.0 1107.000 4920.0 1353.000
United States of America VTT 267.0 250 20 5340.0 801.000 2670.0 1869.000
Germany VTT 1175.0 250 15 17625.0 2643.750 11750.0 3231.250
Canada VTT 2954.0 250 125 369250.0 55387.500 354480.0 -40617.500
Germany VTT 552.0 250 125 69000.0 10350.000 66240.0 -7590.000
France VTT 293.0 250 20 5860.0 879.000 2930.0 2051.000
France Amarilla 2475.0 260 300 742500.0 111375.000 618750.0 12375.000
Mexico Amarilla 546.0 260 300 163800.0 24570.000 136500.0 2730.000
Mexico Montana 1368.0 5 7 9576.0 1436.400 6840.0 1299.600
Canada Paseo 723.0 10 7 5061.0 759.150 3615.0 686.850
United States of America VTT 1806.0 250 12 21672.0 3250.800 5418.0 13003.200
France Paseo 1954.0 10 20 39080.0 3908.000 19540.0 15632.000
Mexico Paseo 591.0 10 300 177300.0 17730.000 147750.0 11820.000
France Paseo 2167.0 10 15 32505.0 3250.500 21670.0 7584.500
Germany Paseo 241.0 10 20 4820.0 482.000 2410.0 1928.000
Germany Velo 681.0 120 15 10215.0 1021.500 6810.0 2383.500
Germany Velo 510.0 120 15 7650.0 765.000 5100.0 1785.000
United States of America Velo 790.0 120 15 11850.0 1185.000 7900.0 2765.000
France Velo 639.0 120 350 223650.0 22365.000 166140.0 35145.000
United States of America Velo 1596.0 120 125 199500.0 19950.000 191520.0 -11970.000
United States of America Velo 2294.0 120 300 688200.0 68820.000 573500.0 45880.000
Germany Velo 241.0 120 20 4820.0 482.000 2410.0 1928.000
Germany Velo 2665.0 120 7 18655.0 1865.500 13325.0 3464.500
Canada Velo 1916.0 120 125 239500.0 23950.000 229920.0 -14370.000
France Velo 853.0 120 300 255900.0 25590.000 213250.0 17060.000
Mexico VTT 341.0 250 125 42625.0 4262.500 40920.0 -2557.500
Mexico VTT 641.0 250 15 9615.0 961.500 6410.0 2243.500
United States of America VTT 2807.0 250 350 982450.0 98245.000 729820.0 154385.000
Mexico VTT 432.0 250 300 129600.0 12960.000 108000.0 8640.000
United States of America VTT 2294.0 250 300 688200.0 68820.000 573500.0 45880.000
France VTT 2167.0 250 15 32505.0 3250.500 21670.0 7584.500
Canada VTT 2529.0 250 125 316125.0 31612.500 303480.0 -18967.500
Germany VTT 1870.0 250 350 654500.0 65450.000 486200.0 102850.000
United States of America Amarilla 579.0 260 125 72375.0 7237.500 69480.0 -4342.500
Canada Amarilla 2240.0 260 350 784000.0 78400.000 582400.0 123200.000
United States of America Amarilla 2993.0 260 300 897900.0 89790.000 748250.0 59860.000
Canada Amarilla 3520.5 260 12 42246.0 4224.600 10561.5 27459.900
Mexico Amarilla 2039.0 260 20 40780.0 4078.000 20390.0 16312.000
Germany Amarilla 2574.0 260 12 30888.0 3088.800 7722.0 20077.200
Canada Amarilla 707.0 260 350 247450.0 24745.000 183820.0 38885.000
France Amarilla 2072.0 260 15 31080.0 3108.000 20720.0 7252.000
France Amarilla 853.0 260 300 255900.0 25590.000 213250.0 17060.000
France Carretera 1198.0 3 12 14376.0 1581.360 3594.0 9200.640
France Paseo 2532.0 10 7 17724.0 1949.640 12660.0 3114.360
France Paseo 1198.0 10 12 14376.0 1581.360 3594.0 9200.640
Canada Velo 384.0 120 15 5760.0 633.600 3840.0 1286.400
Germany Velo 472.0 120 12 5664.0 623.040 1416.0 3624.960
United States of America VTT 1579.0 250 7 11053.0 1215.830 7895.0 1942.170
Mexico VTT 1005.0 250 12 12060.0 1326.600 3015.0 7718.400
United States of America Amarilla 3199.5 260 15 47992.5 5279.175 31995.0 10718.325
Germany Amarilla 472.0 260 12 5664.0 623.040 1416.0 3624.960
Canada Carretera 1937.0 3 12 23244.0 2556.840 5811.0 14876.160
Germany Carretera 792.0 3 350 277200.0 30492.000 205920.0 40788.000
Germany Carretera 2811.0 3 300 843300.0 92763.000 702750.0 47787.000
France Carretera 2441.0 3 125 305125.0 33563.750 292920.0 -21358.750
Canada Carretera 1560.0 3 15 23400.0 2574.000 15600.0 5226.000
Mexico Carretera 2706.0 3 7 18942.0 2083.620 13530.0 3328.380
Germany Montana 766.0 5 350 268100.0 29491.000 199160.0 39449.000
Germany Montana 2992.0 5 20 59840.0 6582.400 29920.0 23337.600
Mexico Montana 2157.0 5 15 32355.0 3559.050 21570.0 7225.950
Canada Paseo 873.0 10 300 261900.0 28809.000 218250.0 14841.000
Mexico Paseo 1122.0 10 20 22440.0 2468.400 11220.0 8751.600
Canada Paseo 2104.5 10 350 736575.0 81023.250 547170.0 108381.750
Canada Paseo 4026.0 10 12 48312.0 5314.320 12078.0 30919.680
France Paseo 2425.5 10 12 29106.0 3201.660 7276.5 18627.840
Canada Paseo 2394.0 10 20 47880.0 5266.800 23940.0 18673.200
Mexico Paseo 1984.0 10 15 29760.0 3273.600 19840.0 6646.400
France Paseo 2441.0 10 125 305125.0 33563.750 292920.0 -21358.750
Germany Paseo 2992.0 10 20 59840.0 6582.400 29920.0 23337.600
Canada Paseo 1366.0 10 300 409800.0 45078.000 341500.0 23222.000
France Velo 2805.0 120 20 56100.0 6171.000 28050.0 21879.000
Mexico Velo 655.0 120 15 9825.0 1080.750 6550.0 2194.250
Mexico Velo 344.0 120 350 120400.0 13244.000 89440.0 17716.000
Canada Velo 1808.0 120 7 12656.0 1392.160 9040.0 2223.840
France VTT 1734.0 250 12 20808.0 2288.880 5202.0 13317.120
Mexico VTT 554.0 250 125 69250.0 7617.500 66480.0 -4847.500
Canada VTT 2935.0 250 20 58700.0 6457.000 29350.0 22893.000
Germany Amarilla 3165.0 260 125 395625.0 43518.750 379800.0 -27693.750
Mexico Amarilla 2629.0 260 20 52580.0 5783.800 26290.0 20506.200
France Amarilla 1433.0 260 125 179125.0 19703.750 171960.0 -12538.750
Mexico Amarilla 947.0 260 125 118375.0 13021.250 113640.0 -8286.250
Mexico Amarilla 344.0 260 350 120400.0 13244.000 89440.0 17716.000
Mexico Amarilla 2157.0 260 15 32355.0 3559.050 21570.0 7225.950
United States of America Paseo 380.0 10 7 2660.0 292.600 1900.0 467.400
Mexico Carretera 886.0 3 350 310100.0 37212.000 230360.0 42528.000
Canada Carretera 2416.0 3 125 302000.0 36240.000 289920.0 -24160.000
Mexico Carretera 2156.0 3 125 269500.0 32340.000 258720.0 -21560.000
Canada Carretera 2689.0 3 15 40335.0 4840.200 26890.0 8604.800
United States of America Montana 677.0 5 15 10155.0 1218.600 6770.0 2166.400
France Montana 1773.0 5 300 531900.0 63828.000 443250.0 24822.000
Mexico Montana 2420.0 5 7 16940.0 2032.800 12100.0 2807.200
Canada Montana 2734.0 5 7 19138.0 2296.560 13670.0 3171.440
Mexico Montana 1715.0 5 20 34300.0 4116.000 17150.0 13034.000
France Montana 1186.0 5 300 355800.0 42696.000 296500.0 16604.000
United States of America Paseo 3495.0 10 300 1048500.0 125820.000 873750.0 48930.000
Mexico Paseo 886.0 10 350 310100.0 37212.000 230360.0 42528.000
Mexico Paseo 2156.0 10 125 269500.0 32340.000 258720.0 -21560.000
Mexico Paseo 905.0 10 20 18100.0 2172.000 9050.0 6878.000
France VTT 1491.0 250 7 10437.0 1252.440 7455.0 1729.560
Germany VTT 1531.0 250 20 30620.0 3674.400 15310.0 11635.600
Canada Amarilla 2761.0 260 12 33132.0 3975.840 8283.0 20873.160
United States of America Carretera 2567.0 3 15 38505.0 5005.650 25670.0 7829.350
United States of America VTT 2567.0 250 15 38505.0 5005.650 25670.0 7829.350
Canada Carretera 923.0 3 350 323050.0 41996.500 239980.0 41073.500
France Carretera 1790.0 3 350 626500.0 81445.000 465400.0 79655.000
Germany Carretera 442.0 3 20 8840.0 1149.200 4420.0 3270.800
United States of America Montana 982.5 5 350 343875.0 44703.750 255450.0 43721.250
United States of America Montana 1298.0 5 7 9086.0 1181.180 6490.0 1414.820
Mexico Montana 604.0 5 12 7248.0 942.240 1812.0 4493.760
Mexico Montana 2255.0 5 20 45100.0 5863.000 22550.0 16687.000
Canada Montana 1249.0 5 20 24980.0 3247.400 12490.0 9242.600
United States of America Paseo 1438.5 10 7 10069.5 1309.035 7192.5 1567.965
Germany Paseo 807.0 10 300 242100.0 31473.000 201750.0 8877.000
United States of America Paseo 2641.0 10 20 52820.0 6866.600 26410.0 19543.400
Germany Paseo 2708.0 10 20 54160.0 7040.800 27080.0 20039.200
Canada Paseo 2632.0 10 350 921200.0 119756.000 684320.0 117124.000
Canada Paseo 1583.0 10 125 197875.0 25723.750 189960.0 -17808.750
Mexico Paseo 571.0 10 12 6852.0 890.760 1713.0 4248.240
France Paseo 2696.0 10 7 18872.0 2453.360 13480.0 2938.640
Canada Paseo 1565.0 10 15 23475.0 3051.750 15650.0 4773.250
Canada Paseo 1249.0 10 20 24980.0 3247.400 12490.0 9242.600
Germany Paseo 357.0 10 350 124950.0 16243.500 92820.0 15886.500
Germany Paseo 1013.0 10 12 12156.0 1580.280 3039.0 7536.720
France Velo 3997.5 120 15 59962.5 7795.125 39975.0 12192.375
Canada Velo 2632.0 120 350 921200.0 119756.000 684320.0 117124.000
France Velo 1190.0 120 7 8330.0 1082.900 5950.0 1297.100
Mexico Velo 604.0 120 12 7248.0 942.240 1812.0 4493.760
Germany Velo 660.0 120 15 9900.0 1287.000 6600.0 2013.000
Mexico Velo 410.0 120 12 4920.0 639.600 1230.0 3050.400
Mexico Velo 2605.0 120 300 781500.0 101595.000 651250.0 28655.000
Germany Velo 1013.0 120 12 12156.0 1580.280 3039.0 7536.720
Canada VTT 1583.0 250 125 197875.0 25723.750 189960.0 -17808.750
Canada VTT 1565.0 250 15 23475.0 3051.750 15650.0 4773.250
Canada Amarilla 1659.0 260 125 207375.0 26958.750 199080.0 -18663.750
France Amarilla 1190.0 260 7 8330.0 1082.900 5950.0 1297.100
Mexico Amarilla 410.0 260 12 4920.0 639.600 1230.0 3050.400
Germany Amarilla 1770.0 260 12 21240.0 2761.200 5310.0 13168.800
Mexico Carretera 2579.0 3 20 51580.0 7221.200 25790.0 18568.800
United States of America Carretera 1743.0 3 20 34860.0 4880.400 17430.0 12549.600
United States of America Carretera 2996.0 3 7 20972.0 2936.080 14980.0 3055.920
Germany Carretera 280.0 3 7 1960.0 274.400 1400.0 285.600
France Montana 293.0 5 7 2051.0 287.140 1465.0 298.860
United States of America Montana 2996.0 5 7 20972.0 2936.080 14980.0 3055.920
Germany Paseo 278.0 10 15 4170.0 583.800 2780.0 806.200
Canada Paseo 2428.0 10 20 48560.0 6798.400 24280.0 17481.600
United States of America Paseo 1767.0 10 15 26505.0 3710.700 17670.0 5124.300
France Paseo 1393.0 10 12 16716.0 2340.240 4179.0 10196.760
Germany VTT 280.0 250 7 1960.0 274.400 1400.0 285.600
France Amarilla 1393.0 260 12 16716.0 2340.240 4179.0 10196.760
France Velo 2805.0 120 20 56100.0 6171.000 28050.0 21879.000
Mexico Velo 655.0 120 15 9825.0 1080.750 6550.0 2194.250
Mexico Velo 344.0 120 350 120400.0 13244.000 89440.0 17716.000
Canada Velo 1808.0 120 7 12656.0 1392.160 9040.0 2223.840
France VTT 1734.0 250 12 20808.0 2288.880 5202.0 13317.120
Mexico VTT 554.0 250 125 69250.0 7617.500 66480.0 -4847.500
Canada VTT 2935.0 250 20 58700.0 6457.000 29350.0 22893.000
Germany Amarilla 3165.0 260 125 395625.0 43518.750 379800.0 -27693.750
Mexico Amarilla 2629.0 260 20 52580.0 5783.800 26290.0 20506.200
France Amarilla 1433.0 260 125 179125.0 19703.750 171960.0 -12538.750
Mexico Amarilla 947.0 260 125 118375.0 13021.250 113640.0 -8286.250
Mexico Amarilla 344.0 260 350 120400.0 13244.000 89440.0 17716.000
Mexico Amarilla 2157.0 260 15 32355.0 3559.050 21570.0 7225.950
United States of America Paseo 380.0 10 7 2660.0 292.600 1900.0 467.400
Mexico Carretera 886.0 3 350 310100.0 37212.000 230360.0 42528.000
Canada Carretera 2416.0 3 125 302000.0 36240.000 289920.0 -24160.000
Mexico Carretera 2156.0 3 125 269500.0 32340.000 258720.0 -21560.000
Canada Carretera 2689.0 3 15 40335.0 4840.200 26890.0 8604.800
United States of America Montana 677.0 5 15 10155.0 1218.600 6770.0 2166.400
France Montana 1773.0 5 300 531900.0 63828.000 443250.0 24822.000
Mexico Montana 2420.0 5 7 16940.0 2032.800 12100.0 2807.200
Canada Montana 2734.0 5 7 19138.0 2296.560 13670.0 3171.440
Mexico Montana 1715.0 5 20 34300.0 4116.000 17150.0 13034.000
France Montana 1186.0 5 300 355800.0 42696.000 296500.0 16604.000
United States of America Paseo 3495.0 10 300 1048500.0 125820.000 873750.0 48930.000
Mexico Paseo 886.0 10 350 310100.0 37212.000 230360.0 42528.000
Mexico Paseo 2156.0 10 125 269500.0 32340.000 258720.0 -21560.000
Mexico Paseo 905.0 10 20 18100.0 2172.000 9050.0 6878.000
Mexico Paseo 1715.0 10 20 34300.0 4116.000 17150.0 13034.000
France Paseo 1594.0 10 350 557900.0 66948.000 414440.0 76512.000
Germany Paseo 1359.0 10 300 407700.0 48924.000 339750.0 19026.000
Mexico Paseo 2150.0 10 300 645000.0 77400.000 537500.0 30100.000
Mexico Paseo 1197.0 10 350 418950.0 50274.000 311220.0 57456.000
Mexico Paseo 380.0 10 15 5700.0 684.000 3800.0 1216.000
Mexico Paseo 1233.0 10 20 24660.0 2959.200 12330.0 9370.800
Mexico Velo 1395.0 120 350 488250.0 58590.000 362700.0 66960.000
United States of America Velo 986.0 120 350 345100.0 41412.000 256360.0 47328.000
Mexico Velo 905.0 120 20 18100.0 2172.000 9050.0 6878.000
Canada VTT 2109.0 250 12 25308.0 3036.960 6327.0 15944.040
France VTT 3874.5 250 15 58117.5 6974.100 38745.0 12398.400
Canada VTT 623.0 250 350 218050.0 26166.000 161980.0 29904.000
United States of America VTT 986.0 250 350 345100.0 41412.000 256360.0 47328.000
United States of America VTT 2387.0 250 125 298375.0 35805.000 286440.0 -23870.000
Mexico VTT 1233.0 250 20 24660.0 2959.200 12330.0 9370.800
United States of America Amarilla 270.0 260 350 94500.0 11340.000 70200.0 12960.000
France Amarilla 3421.5 260 7 23950.5 2874.060 17107.5 3968.940
Canada Amarilla 2734.0 260 7 19138.0 2296.560 13670.0 3171.440
United States of America Amarilla 2548.0 260 15 38220.0 4586.400 25480.0 8153.600
France Carretera 2521.5 3 20 50430.0 6051.600 25215.0 19163.400
Mexico Montana 2661.0 5 12 31932.0 3831.840 7983.0 20117.160
Germany Paseo 1531.0 10 20 30620.0 3674.400 15310.0 11635.600
France VTT 1491.0 250 7 10437.0 1252.440 7455.0 1729.560
Germany VTT 1531.0 250 20 30620.0 3674.400 15310.0 11635.600
Canada Amarilla 2761.0 260 12 33132.0 3975.840 8283.0 20873.160
United States of America Carretera 2567.0 3 15 38505.0 5005.650 25670.0 7829.350
United States of America VTT 2567.0 250 15 38505.0 5005.650 25670.0 7829.350
France Velo 2805.0 120 20 56100.0 6171.000 28050.0 21879.000
Mexico Velo 655.0 120 15 9825.0 1080.750 6550.0 2194.250
Mexico Velo 344.0 120 350 120400.0 13244.000 89440.0 17716.000
Canada Velo 1808.0 120 7 12656.0 1392.160 9040.0 2223.840
France VTT 1734.0 250 12 20808.0 2288.880 5202.0 13317.120
Mexico VTT 554.0 250 125 69250.0 7617.500 66480.0 -4847.500
Canada VTT 2935.0 250 20 58700.0 6457.000 29350.0 22893.000
Germany Amarilla 3165.0 260 125 395625.0 43518.750 379800.0 -27693.750
Mexico Amarilla 2629.0 260 20 52580.0 5783.800 26290.0 20506.200
France Amarilla 1433.0 260 125 179125.0 19703.750 171960.0 -12538.750
Mexico Amarilla 947.0 260 125 118375.0 13021.250 113640.0 -8286.250
Mexico Amarilla 344.0 260 350 120400.0 13244.000 89440.0 17716.000
Mexico Amarilla 2157.0 260 15 32355.0 3559.050 21570.0 7225.950
United States of America Paseo 380.0 10 7 2660.0 292.600 1900.0 467.400
Mexico Carretera 886.0 3 350 310100.0 37212.000 230360.0 42528.000
Canada Carretera 2416.0 3 125 302000.0 36240.000 289920.0 -24160.000
Mexico Carretera 2156.0 3 125 269500.0 32340.000 258720.0 -21560.000
Canada Carretera 2689.0 3 15 40335.0 4840.200 26890.0 8604.800
United States of America Montana 677.0 5 15 10155.0 1218.600 6770.0 2166.400
France Montana 1773.0 5 300 531900.0 63828.000 443250.0 24822.000
Mexico Montana 2420.0 5 7 16940.0 2032.800 12100.0 2807.200
Canada Montana 2734.0 5 7 19138.0 2296.560 13670.0 3171.440
Mexico Montana 1715.0 5 20 34300.0 4116.000 17150.0 13034.000
France Montana 1186.0 5 300 355800.0 42696.000 296500.0 16604.000
United States of America Paseo 3495.0 10 300 1048500.0 125820.000 873750.0 48930.000
Mexico Paseo 886.0 10 350 310100.0 37212.000 230360.0 42528.000
Mexico Paseo 2156.0 10 125 269500.0 32340.000 258720.0 -21560.000
Mexico Paseo 905.0 10 20 18100.0 2172.000 9050.0 6878.000
Mexico Paseo 1715.0 10 20 34300.0 4116.000 17150.0 13034.000
France Paseo 1594.0 10 350 557900.0 66948.000 414440.0 76512.000
Germany Paseo 1359.0 10 300 407700.0 48924.000 339750.0 19026.000
Mexico Paseo 2150.0 10 300 645000.0 77400.000 537500.0 30100.000
Mexico Paseo 1197.0 10 350 418950.0 50274.000 311220.0 57456.000
Mexico Paseo 380.0 10 15 5700.0 684.000 3800.0 1216.000
Mexico Paseo 1233.0 10 20 24660.0 2959.200 12330.0 9370.800
Mexico Velo 1395.0 120 350 488250.0 58590.000 362700.0 66960.000
United States of America Velo 986.0 120 350 345100.0 41412.000 256360.0 47328.000
Mexico Velo 905.0 120 20 18100.0 2172.000 9050.0 6878.000
Canada VTT 2109.0 250 12 25308.0 3036.960 6327.0 15944.040
France VTT 3874.5 250 15 58117.5 6974.100 38745.0 12398.400
Canada VTT 623.0 250 350 218050.0 26166.000 161980.0 29904.000
United States of America VTT 986.0 250 350 345100.0 41412.000 256360.0 47328.000
United States of America VTT 2387.0 250 125 298375.0 35805.000 286440.0 -23870.000
Mexico VTT 1233.0 250 20 24660.0 2959.200 12330.0 9370.800
United States of America Amarilla 270.0 260 350 94500.0 11340.000 70200.0 12960.000
France Amarilla 3421.5 260 7 23950.5 2874.060 17107.5 3968.940
Canada Amarilla 2734.0 260 7 19138.0 2296.560 13670.0 3171.440
United States of America Amarilla 2548.0 260 15 38220.0 4586.400 25480.0 8153.600
France Carretera 2521.5 3 20 50430.0 6051.600 25215.0 19163.400
Mexico Montana 2661.0 5 12 31932.0 3831.840 7983.0 20117.160
Germany Paseo 1531.0 10 20 30620.0 3674.400 15310.0 11635.600
France VTT 1491.0 250 7 10437.0 1252.440 7455.0 1729.560
Germany VTT 1531.0 250 20 30620.0 3674.400 15310.0 11635.600
Canada Amarilla 2761.0 260 12 33132.0 3975.840 8283.0 20873.160
United States of America Carretera 2567.0 3 15 38505.0 5005.650 25670.0 7829.350
United States of America VTT 2567.0 250 15 38505.0 5005.650 25670.0 7829.350
France Velo 2805.0 120 20 56100.0 6171.000 28050.0 21879.000
Mexico Velo 655.0 120 15 9825.0 1080.750 6550.0 2194.250
Mexico Velo 344.0 120 350 120400.0 13244.000 89440.0 17716.000
Canada Velo 1808.0 120 7 12656.0 1392.160 9040.0 2223.840
France VTT 1734.0 250 12 20808.0 2288.880 5202.0 13317.120
Mexico VTT 554.0 250 125 69250.0 7617.500 66480.0 -4847.500
Canada VTT 2935.0 250 20 58700.0 6457.000 29350.0 22893.000
Germany Amarilla 3165.0 260 125 395625.0 43518.750 379800.0 -27693.750
Mexico Amarilla 2629.0 260 20 52580.0 5783.800 26290.0 20506.200
France Amarilla 1433.0 260 125 179125.0 19703.750 171960.0 -12538.750
Mexico Amarilla 947.0 260 125 118375.0 13021.250 113640.0 -8286.250
Mexico Amarilla 344.0 260 350 120400.0 13244.000 89440.0 17716.000
Mexico Amarilla 2157.0 260 15 32355.0 3559.050 21570.0 7225.950
United States of America Paseo 380.0 10 7 2660.0 292.600 1900.0 467.400
Mexico Carretera 886.0 3 350 310100.0 37212.000 230360.0 42528.000
Canada Carretera 2416.0 3 125 302000.0 36240.000 289920.0 -24160.000
Mexico Carretera 2156.0 3 125 269500.0 32340.000 258720.0 -21560.000
Canada Carretera 2689.0 3 15 40335.0 4840.200 26890.0 8604.800
United States of America Montana 677.0 5 15 10155.0 1218.600 6770.0 2166.400
France Montana 1773.0 5 300 531900.0 63828.000 443250.0 24822.000
Mexico Montana 2420.0 5 7 16940.0 2032.800 12100.0 2807.200
Canada Montana 2734.0 5 7 19138.0 2296.560 13670.0 3171.440
Mexico Montana 1715.0 5 20 34300.0 4116.000 17150.0 13034.000
France Montana 1186.0 5 300 355800.0 42696.000 296500.0 16604.000
United States of America Paseo 3495.0 10 300 1048500.0 125820.000 873750.0 48930.000
Mexico Paseo 886.0 10 350 310100.0 37212.000 230360.0 42528.000
Mexico Paseo 2156.0 10 125 269500.0 32340.000 258720.0 -21560.000
Mexico Paseo 905.0 10 20 18100.0 2172.000 9050.0 6878.000
Mexico Paseo 1715.0 10 20 34300.0 4116.000 17150.0 13034.000
France Paseo 1594.0 10 350 557900.0 66948.000 414440.0 76512.000
Germany Paseo 1359.0 10 300 407700.0 48924.000 339750.0 19026.000
Mexico Paseo 2150.0 10 300 645000.0 77400.000 537500.0 30100.000
Mexico Paseo 1197.0 10 350 418950.0 50274.000 311220.0 57456.000
Mexico Paseo 380.0 10 15 5700.0 684.000 3800.0 1216.000
Mexico Paseo 1233.0 10 20 24660.0 2959.200 12330.0 9370.800
Mexico Velo 1395.0 120 350 488250.0 58590.000 362700.0 66960.000
United States of America Velo 986.0 120 350 345100.0 41412.000 256360.0 47328.000
Mexico Velo 905.0 120 20 18100.0 2172.000 9050.0 6878.000
Canada VTT 2109.0 250 12 25308.0 3036.960 6327.0 15944.040
France VTT 3874.5 250 15 58117.5 6974.100 38745.0 12398.400
Canada VTT 623.0 250 350 218050.0 26166.000 161980.0 29904.000
United States of America VTT 986.0 250 350 345100.0 41412.000 256360.0 47328.000
United States of America VTT 2387.0 250 125 298375.0 35805.000 286440.0 -23870.000
Mexico VTT 1233.0 250 20 24660.0 2959.200 12330.0 9370.800
United States of America Amarilla 270.0 260 350 94500.0 11340.000 70200.0 12960.000
France Amarilla 3421.5 260 7 23950.5 2874.060 17107.5 3968.940
Canada Amarilla 2734.0 260 7 19138.0 2296.560 13670.0 3171.440
United States of America Amarilla 2548.0 260 15 38220.0 4586.400 25480.0 8153.600
France Carretera 2521.5 3 20 50430.0 6051.600 25215.0 19163.400
Mexico Montana 2661.0 5 12 31932.0 3831.840 7983.0 20117.160
Germany Paseo 1531.0 10 20 30620.0 3674.400 15310.0 11635.600
France VTT 1491.0 250 7 10437.0 1252.440 7455.0 1729.560
Germany VTT 1531.0 250 20 30620.0 3674.400 15310.0 11635.600
Canada Amarilla 2761.0 260 12 33132.0 3975.840 8283.0 20873.160
United States of America Carretera 2567.0 3 15 38505.0 5005.650 25670.0 7829.350
United States of America VTT 2567.0 250 15 38505.0 5005.650 25670.0 7829.350 
names(nv5)
## [1] "Country"             "Product"             "Units.Sold"         
## [4] "Manufacturing.Price" "Sale.Price"          "Gross.Sales"        
## [7] "Discounts"           "COGS"                "Profit"

2. Tóm tắt bản dữ liệu Financial Sample

-skim_variable: Tên của biến trong tập dữ liệu.

-n_missing: Số lượng giá trị thiếu (missing values) cho biến đó. Giá trị này cho biết có bao nhiêu quan sát không có giá trị cho biến này.

-complete_rate: Tỷ lệ các quan sát hoàn chỉnh (complete observations) cho biến đó, tức là tỷ lệ giữa số lượng quan sát có giá trị và tổng số quan sát.

-mean: là giá trị trung bình của tất cả các quan sát trong biến.

-sd: cho biết mức độ phân tán của các giá trị xung quanh giá trị trung bình.

-p0: là giá trị nhỏ nhất của biến trong tập dữ liệu.

-p25: là giá trị mà 25% các quan sát nhỏ hơn và 75% các quan sát lớn hơn.

-p50: là giá trị mà 50% các quan sát nhỏ hơn và 50% các quan sát lớn hơn.

-p75: là giá trị mà 75% các quan sát nhỏ hơn và 25% các quan sát lớn hơn.

-p100: là giá trị lớn nhất của biến trong tập dữ liệu.

-hist: Biểu đồ phân phối (histogram) của biến, biểu thị phân phối của các giá trị trong biến .

library(skimr)
skim(nv5)
Data summary
Name nv5
Number of rows 1006
Number of columns 9
_______________________
Column type frequency:
character 2
numeric 7
________________________
Group variables None

Variable type: character

skim_variable n_missing complete_rate min max empty n_unique whitespace
Country 0 1 6 24 0 5 0
Product 0 1 3 9 0 6 0

Variable type: numeric

skim_variable n_missing complete_rate mean sd p0 p25 p50 p75 p100 hist
Units.Sold 0 1 1639.26 885.62 200.0 905.00 1566.00 2339.50 4492.5 ▇▇▇▂▁
Manufacturing.Price 0 1 101.69 110.35 3.0 5.00 10.00 250.00 260.0 ▇▁▂▁▅
Sale.Price 0 1 116.81 136.77 7.0 12.00 20.00 300.00 350.0 ▇▂▁▁▃
Gross.Sales 0 1 175936.31 245508.65 1799.0 18176.25 38592.50 269500.00 1207500.0 ▇▂▁▁▁
Discounts 0 1 14832.22 24110.38 0.0 1132.80 3559.05 19950.00 149677.5 ▇▁▁▁▁
COGS 0 1 139965.38 198115.49 918.0 8083.50 24490.00 236465.00 950625.0 ▇▂▁▁▁
Profit 0 1 21138.70 38428.09 -40617.5 2750.00 9242.60 21272.24 262200.0 ▇▂▁▁▁ 
library(dplyr)

1.Biểu đồ tổng số lượng sản phẩm của Quốc Gia

-Từ biểu đồ ta có thể thấy Canada va France có tổng sản phẩm là 197 sản phẩm, đứng hàng thứ 2 sản xuất sản phẩm. Đứng đầu là Mexico với tổng sản phẩm là 241.Còn lại là United States of Amerrica.

Giải thích: Đầu tiên gọi (group_by) để nhóm dữ liệu cột Contry sau dùng (summarise) để tính tổng Với x là tên Quốc Gia, y là số lượng. Aes(label = freq) xác định rằng nhãn sẽ được lấy từ cột (freq. vjust = 2 ) điều chỉnh vị trí dọc của các nhãn để chúng xuất hiện phía trên cột.

library("ggplot2")
library(tidyverse)
library(scales)
nv5%>%  group_by(Country) %>% summarise(freq= n()) %>%
ggplot(aes(x = Country,y = freq)) +
  geom_col(fill='brown') +
  labs(title="1.Biểu đồ cụ thể 5 quốc gia") +
  geom_text(aes(label =freq),vjust =2, color ='black') +
  labs(x= 'Tên QG', y='Số lượng')

2.Biểu đồ thể hiện sản phẩm.

-Với biểu đồ này ta thấy số phẩn trăm của 6 loại sản phẩm đang được sản suất và bán ra với sự chênh lệch không đáng kể.

Giải thích: Goi (group_by) để nhóm dữ liệu cột Product sau dùng (summarise) để tính tổng Với x là tên mã sản phẩm , y là phần trăm. Aes(label = percent(n/length(nv5$Product) xác định rằng nhãn sẽ được lấy từ cột (freq) và tính số phần trăm của nó.

.

nv5 %>%  group_by(Product) %>% summarise(n= n()) %>%
ggplot(aes(x = Product, y = n)) +
  geom_col(fill='brown') +
  labs(title="2.Biểu đồ thể hiện phần trăm các san phẩm được sản xuất") +
  geom_text(aes(label = percent(n/length(nv5$Product))),vjust =2, color ='black') +
  labs(x= 'Tên sản phẩm', y='Phần trăm')

3. Biểu đồ sản phẩm được bán

  • Aes xác định tính ánh xạ cho biểu đồ (Units.Sold),geom_density() để vẽ một đường mật độ (density plot) dựa trên dữ liệu của cột Units.Sold. fill = ‘brown’ chỉ định màu sắc cho phần dưới của đường mật độ. Facet_wrap(~Product): Chia biểu đồ thành các nhóm nhỏ dựa trên cột Product. Mỗi nhóm sẽ có một đường mật độ riêng, giúp so sánh mật độ của Units.Sold giữa các sản phẩm khác nhau.
nv5 %>% ggplot(aes(x = Units.Sold)) +
  labs(title="3.Biểu đồ số lượng sản phẩm được bán") +
  geom_density(fill = 'brown') +
  facet_wrap(~Product)

4. Biểu đồ Chiết khấu

  • Thêm 1 cột với tên group để biết được sản phẩm có được chiết khấu hay không. sau đó ta vẽ biểu đồ cột để thể hiện dữ liệu vừa tạo.

Giải thích: từ một cột vừa hình thành và và vẽ biểu đồ ta co thể thây được có 953 số sản phẩm được chiết khẩu và 53 sản phẩm không chiếc khấu.

nv5$group <- ifelse(nv5$Discounts > 0, "Có chiết khấu", "Không chiết khấu")
table(nv5$group)
## 
##    Có chiết khấu Không chiết khấu 
##              953               53
nv5 %>% group_by(group) %>% summarise(n = n()) %>%
  ggplot(aes(group,n)) +
    geom_col(fill='brown') +
    geom_text(aes(label = n),vjust = 1, color = 'black') +
    labs(title = "4.Biểồ thể hiện nhóm theo chiết khấu ",x = 'Mức độ', y = 'Số lượng')

5. Biểu đồ tần số

  • Biểu đồ này thể hiện tần số giá được chiết khấu ở Canaada & Mexico.

Giải thích: Filter lọc dữ liệu Country cảu 2 quốc gia. Và thực hiện ánh xạ cho biểu đồ. Với x là doanh thu, y là tần số bán.

nv5 %>% filter(Country== 'Canada' | Country== 'Mexico') %>%
  ggplot(aes(x=Gross.Sales, color=Country)) + 
  geom_freqpoly(linewidth = 1) +
  labs(title = "5.Bểu đồ tần số giá trước chiết khấu ở quốc gia Canada & Mexico")

  labs(x = 'Doanh thu', y= 'Tần số bán')
## $x
## [1] "Doanh thu"
## 
## $y
## [1] "Tần số bán"
## 
## attr(,"class")
## [1] "labels"

6.Biểu đồ chi phí hàng hóa được bán.

nv5 %>% ggplot(aes(x = COGS)) +
  geom_histogram(binwidth =50000, fill = 'brown', color= 'red') +
  labs(title = " 6.Chi phí hàng hóa", x="Chi phí", y="Số lượng ")

7.Biểu đồ thể hiện sản phẩm

-Ggplot(aes(x = ’‘, y = n, fill = Product)): Đây là bước bắt đầu tạo một biểu đồ sử dụng thư viện ggplot2. aes() xác định mapping aesthetics (thuộc tính ánh xạ) cho biểu đồ. Trong trường hợp này, chúng ta đang ánh xạ trống (’’) vào trục x (để tạo ra biểu đồ tròn), số lượng n vào trục y và sử dụng màu sắc (fill) để phân biệt giữa các sản phẩm. -Geom_text(aes(x = 1.3, label = n), position = position_stack(vjust = .5)): Thêm các nhãn văn bản lên trên cột, với giá trị n là số lượng sản phẩm, và vị trí xác định bằng 1.3. position_stack(vjust = .5) xác định vị trí dọc của nhãn -theme_void(): Đặt giao diện của biểu đồ thành giao diện trống, nghĩa là không có các thành phần bổ sung như lưới hoặc trục.

nv5 %>% group_by(Product) %>% summarise(n = n()) %>%
  ggplot(aes(x ='', y = n,fill = Product)) +
    geom_col(color = 'black') +
    labs(title= '7. Biểu đồ thể hiện sản phẩm') +
    coord_polar('y') +
    geom_text(aes(x = 1.3, label = n),position = position_stack(vjust = .5)) +
    theme_void()

8.Mối quan hệ Giá bán và giá sản xuất

-Biểu đồ này có thể thấy giá bán và giá sản xuất tỷ lệ thuận với nhau có xu hướng khá đồng điều.

Giải thích: Với x là giá sản xuất, y là giá bán

nv5 %>% ggplot(aes(x = Manufacturing.Price, y = Sale.Price)) +
  geom_point() +
  xlab('Giá sản xuất sản phẩm') +
  ylab('Giá bán')

9.Biểu đồ thể hiện lợi nhận gộp .

-Ánh xạ của biểu đồ này là cột Profit. Cho thấy Lợi nhuận gộp từ việc bán hàng (tổng doanh số bán hàng trừ đi chi phí sản xuất và các chi phí liên quan khác)của từng mã sản phẩm.

ggplot(nv5, aes(x = Profit)) +
  geom_density(fill = "brown", color = "black") +
  labs(title = "", x = "Lợi nhận của từng mã sp", y = "Lợi nhận gộp") +
  facet_wrap(~ Product)

10.So sánh sản số sản phẩm bán ra ở 2 Quốc gia.

-Lọc dữ liệu của cột Country chỉ lấy dữ liệu của France và Canada để thực hiện phân tích. Xác định ánh xạ (Units.Sold) của biểu đồ và màu sắc để phân biệt 2 quốc gia này.

nv5 %>% filter(Country== 'France' | Country== 'Canada') %>%
  ggplot(aes(x=Units.Sold, fill = Country)) +
  geom_density() +
  labs(title = "Biểu đồ thể hiện số lượng sản phấm của 2 Quốc gia")+ 
  labs(x = 'Sản phẩm', y=' Giá tri')

11. Biểu đồ giá trị trung bình giá bán của 5 quốc gia.

-Gọi group_by(Country) để nhóm dữ liệu theo cột Country, sau đó sử dụng summarise(m = mean(Sale.Price)) để tính giá trị trung bình của cột Sale.Price cho mỗi quốc gia.

-Anh xạ tên quốc gia (Country) vào trục x và giá trung bình (m) vào trục y, position = ‘dodge’ cho biết các cột sẽ được hiển thị cách xa nhau (tránh chồng chéo) trên trục x.

-làm tròn đến 2 chữ số thập phân băng lệnh (round(m, 2)). vjust = 2 chỉ định vị trí dọc của các nhãn

nv5 %>% group_by(Country) %>% summarise(m= mean(Sale.Price)) %>%
  ggplot(aes(x = Country,y = m)) +
    geom_col(position = 'dodge') +
    geom_text(aes(label = round(m,2)), vjust = 2, color = 'brown') +
    labs(x = 'Quốc gia', y= 'Giá bán ')

12.Mối quan hệ giữa Giá sản xuất và Tiền chiết khấu.

-nv5 %>% ggplot(aes(x = Manufacturing.Price, y = Discounts, color = Product)): Đây là bước bắt đầu tạo một biểu đồ sử dụng thư viện ggplot2. aes() xác định mapping aesthetics (thuộc tính ánh xạ) cho biểu đồ. Trong trường hợp này, chúng ta đang ánh xạ giá sản xuất (Manufacturing.Price) vào trục x, số tiền chiết khấu (Discounts) vào trục y, và sử dụng màu sắc (color) để phân biệt giữa các sản phẩm.

-Geom_point(): Thêm một layer với geom_point() để vẽ các điểm trên biểu đồ, mỗi điểm biểu diễn một cặp giá trị của giá sản xuất và tiền chiết khấu.

nv5 %>% ggplot(aes(x = Manufacturing.Price, y = Discounts, color = Product))+
  geom_point() +
  xlab('Giá sản xuất sản phẩm') + 
  ylab('Tiền chiết khấu')

13.Biểu đồ thể hiện sản phẩm.

nv5 %>% group_by(Product) %>% summarise(n = n()) %>%
  ggplot(aes(x = '', y = n, fill = Product)) +
  geom_col() +
  geom_text(aes(label = n), position = position_stack(vjust = 1))

14.Biểu đồ sản số sản phẩm có chiết khấu ở Mexico.

-Với biểu đồ này ta có thể thấy ở Mexico có 8 sản phẩm không có chiết khấu và 233 sản phẩm đã chiết khấu.

n<- nv5%>% filter(Country == 'Mexico')
n %>% group_by(group) %>% summarise(n = n()) %>%
  ggplot(aes(x = '', y = n,fill = group)) +
    geom_col(color = 'black', width = 1) +
    coord_polar('y') +
    geom_text(aes(x = 1.3, label = n),position = position_stack(vjust = .5)) +
    theme_void()

15.Biểu đồ tần số lợi nhuận.

-Lọc dữ liệu cột Product chỉ lấy dữ liệu Paseo và VTT để phân tích lợi nhuận gộp mà nó mang lại. Ánh xạ của biểu đồ này là Profit. Đường tần số (frequency polygon) dựa trên dữ liệu của cột Profit. linewidth = 1 chỉ định độ rộng của đường.

nv5 %>% filter(Product== 'Paseo' |Product== 'VTT') %>%
  ggplot(aes(x=Profit, color=Product)) + 
  geom_freqpoly(linewidth = 1) +
  labs(title = "15.Bểu đồ tần số lợi nhận gộp của Paseo & VTT") +
  labs(x = 'Lợi nhuận', y='Tần số')

LS0tDQp0aXRsZTogIk5oaeG7h21WdTUiDQphdXRob3I6ICJudG50Ig0KZGF0ZTogImByIGZvcm1hdChTeXMudGltZSgpLCAnJUg6JU06JVMsICVkIC0gJW0gLSAlWScpYCINCm91dHB1dDogDQogIGh0bWxfZG9jdW1lbnQ6DQogICBjb2RlX2Rvd25sb2FkOiB0cnVlDQogICBjb2RlX2ZvbGRpbmc6IGhpZGUNCiAgIHRvY19mbG9hdDogdHJ1ZQ0KICAgdG9jOiB0cnVlDQotLS0NCg0KYGBge3Igc2V0dXAsIGluY2x1ZGU9RkFMU0V9DQprbml0cjo6b3B0c19jaHVuayRzZXQoZWNobyA9IFRSVUUsIHdhcm5pbmcgPSBGQUxTRSwgbWVzc2FnZSA9IEZBTFNFKQ0KbGlicmFyeSh0aWR5dmVyc2UpDQpsaWJyYXJ5KGdncGxvdDIpDQpgYGANCg0KDQoNCiMgKipBLiBC4buZIGThu68gbGnhu4d1IEZpbmFuY2lhbCBTYW1wbGUqKi4NCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCg0KKioxLlRhIGPDsyBi4buZIGThu68gbGnhu4d1IEZhaW5hbmNpYWwgU2FtcGxlIHbhu5tpIDEwMDYgcXVhbiBzw6F0IHbDoCA5IGJp4bq/biB24bubaToqKg0KDQogICoqQ291bnRyeSoqOiBRdeG7kWMgZ2lhIG7GoWkgc+G6o24gcGjhuqltIMSRxrDhu6NjIGLDoW4gKCBDYW5hZGEsIEZyYW5jZSwgR2VybWFueSwgTWV4aWNvLCBVbml0ZWQgU3RhdGVzIG9mIEFtZXJpY2EpLg0KDQogICoqUHJvZHVjdCoqOiBUw6puIGPhu6dhIHPhuqNuIHBo4bqpbSAoIEFtYXJpbGxhLCBDYXJyZXRlcmEsIE1vbnRhbmEsIFBhc2VvLCBWZWxvLCBWVFQpLg0KDQogICoqVW5pdHMuU29sZCoqOiBT4buRIGzGsOG7o25nIHPhuqNuIHBo4bqpbSDEkcaw4bujYyBiw6FuLg0KDQogICoqTWFudWZhY3R1cmluZy5QcmljZSoqOiBHacOhIHPhuqNuIHh14bqldCBj4bunYSBz4bqjbiBwaOG6qW0uDQoNCiAgKipTYWxlLlByaWNlKio6IEdpw6EgYsOhbiBj4bunYSBz4bqjbiBwaOG6qW0gY2hvIGtow6FjaCBow6BuZyBjdeG7kWkgY8O5bmcuDQoNCiAgKipHcm9zcy5TYWxlcyoqOiBU4buVbmcgZG9hbmggc+G7kSBiw6FuIGjDoG5nIHRyxrDhu5tjIGtoaSDDoXAgZOG7pW5nIGNoaeG6v3Qga2jhuqV1IGhv4bq3YyB0aHXhur8uDQoNCiAgKipEaXNjb3VudHMqKjogVOG7lW5nIHPhu5EgdGnhu4FuIGNoaeG6v3Qga2jhuqV1IMSRxrDhu6NjIMOhcCBk4bulbmcgY2hvIGPDoWMgxJHGoW4gaMOgbmcuDQoNCiAgKipDT0dTKio6IENoaSBwaMOtIGPhu6dhIGjDoG5nIGjDs2EgxJHGsOG7o2MgYsOhbi4NCiAgDQogICoqUHJvZml0Kio6IEzhu6NpIG5odeG6rW4gZ+G7mXAgdOG7qyB2aeG7h2MgYsOhbiBow6BuZyAodOG7lW5nIGRvYW5oIHPhu5EgYsOhbiBow6BuZyB0cuG7qyDEkWkgY2hpIHBow60gc+G6o24geHXhuqV0IHbDoCBjw6FjIGNoaSBwaMOtIGxpw6puIHF1YW4ga2jDoWMpLg0KDQoNCg0KYGBge3J9DQpsaWJyYXJ5KHhsc3gpDQpudjUgPC0gcmVhZC54bHN4KCJDOi9Vc2Vycy9QQy9Eb3dubG9hZHMvRmluYW5jaWFsIFNhbXBsZSAoMSkueGxzeCIsIHNoZWV0SW5kZXggPSAxLCBoZWFkZXIgPSBUKQ0KdGFibGUgPC0ga25pdHI6OmthYmxlKG52NSxmb3JtYXQgPSAibWFya2Rvd24iKQ0KdGFibGUNCg0KYGBgDQoNCmBgYHtyfQ0KbmFtZXMobnY1KQ0KYGBgDQoNCg0KIyMgKioyLiBUw7NtIHThuq90IGLhuqNuIGThu68gbGnhu4d1IEZpbmFuY2lhbCBTYW1wbGUqKg0KDQotc2tpbV92YXJpYWJsZTogVMOqbiBj4bunYSBiaeG6v24gdHJvbmcgdOG6rXAgZOG7ryBsaeG7h3UuDQoNCi1uX21pc3Npbmc6IFPhu5EgbMaw4bujbmcgZ2nDoSB0cuG7iyB0aGnhur91IChtaXNzaW5nIHZhbHVlcykgY2hvIGJp4bq/biDEkcOzLiBHacOhIHRy4buLIG7DoHkgY2hvIGJp4bq/dCBjw7MgYmFvIG5oacOqdSBxdWFuIHPDoXQga2jDtG5nIGPDsyBnacOhIHRy4buLIGNobyBiaeG6v24gbsOgeS4NCg0KLWNvbXBsZXRlX3JhdGU6IFThu7cgbOG7hyBjw6FjIHF1YW4gc8OhdCBob8OgbiBjaOG7iW5oIChjb21wbGV0ZSBvYnNlcnZhdGlvbnMpIGNobyBiaeG6v24gxJHDsywgdOG7qWMgbMOgIHThu7cgbOG7hyBnaeG7r2Egc+G7kSBsxrDhu6NuZyBxdWFuIHPDoXQgY8OzIGdpw6EgdHLhu4sgdsOgIHThu5VuZyBz4buRIHF1YW4gc8OhdC4NCg0KLW1lYW46IGzDoCBnacOhIHRy4buLIHRydW5nIGLDrG5oIGPhu6dhIHThuqV0IGPhuqMgY8OhYyBxdWFuIHPDoXQgdHJvbmcgYmnhur9uLg0KDQotc2Q6IGNobyBiaeG6v3QgbeG7qWMgxJHhu5kgcGjDom4gdMOhbiBj4bunYSBjw6FjIGdpw6EgdHLhu4sgeHVuZyBxdWFuaCBnacOhIHRy4buLIHRydW5nIGLDrG5oLg0KDQotcDA6IGzDoCBnacOhIHRy4buLIG5o4buPIG5o4bqldCBj4bunYSBiaeG6v24gdHJvbmcgdOG6rXAgZOG7ryBsaeG7h3UuDQoNCi1wMjU6IGzDoCBnacOhIHRy4buLIG3DoCAyNSUgY8OhYyBxdWFuIHPDoXQgbmjhu48gaMahbiB2w6AgNzUlIGPDoWMgcXVhbiBzw6F0IGzhu5tuIGjGoW4uDQoNCi1wNTA6IGzDoCBnacOhIHRy4buLIG3DoCA1MCUgY8OhYyBxdWFuIHPDoXQgbmjhu48gaMahbiB2w6AgNTAlIGPDoWMgcXVhbiBzw6F0IGzhu5tuIGjGoW4uDQoNCi1wNzU6IGzDoCBnacOhIHRy4buLIG3DoCA3NSUgY8OhYyBxdWFuIHPDoXQgbmjhu48gaMahbiB2w6AgMjUlIGPDoWMgcXVhbiBzw6F0IGzhu5tuIGjGoW4uDQoNCi1wMTAwOiBsw6AgZ2nDoSB0cuG7iyBs4bubbiBuaOG6pXQgY+G7p2EgYmnhur9uIHRyb25nIHThuq1wIGThu68gbGnhu4d1Lg0KDQotaGlzdDogQmnhu4N1IMSR4buTIHBow6JuIHBo4buRaSAoaGlzdG9ncmFtKSBj4bunYSBiaeG6v24sIGJp4buDdSB0aOG7iyBwaMOibiBwaOG7kWkgY+G7p2EgY8OhYyBnacOhIHRy4buLIHRyb25nIGJp4bq/biAuDQoNCg0KYGBge3J9DQpsaWJyYXJ5KHNraW1yKQ0Kc2tpbShudjUpDQoNCmBgYA0KDQoNCmBgYHtyfQ0KbGlicmFyeShkcGx5cikNCmBgYA0KDQojIyAxLkJp4buDdSDEkeG7kyB04buVbmcgc+G7kSBsxrDhu6NuZyBz4bqjbiBwaOG6qW0gY+G7p2EgUXXhu5FjIEdpYQ0KLVThu6sgYmnhu4N1IMSR4buTIHRhIGPDsyB0aOG7gyB0aOG6pXkgQ2FuYWRhIHZhIEZyYW5jZSBjw7MgdOG7lW5nIHPhuqNuIHBo4bqpbSBsw6AgMTk3IHPhuqNuIHBo4bqpbSwgxJHhu6luZyBow6BuZyB0aOG7qSAyIHPhuqNuIHh14bqldCBz4bqjbiBwaOG6qW0uIMSQ4bupbmcgxJHhuqd1IGzDoCBNZXhpY28gduG7m2kgdOG7lW5nIHPhuqNuIHBo4bqpbSBsw6AgMjQxLkPDsm4gbOG6oWkgbMOgIFVuaXRlZCBTdGF0ZXMgb2YgQW1lcnJpY2EuDQoNCioqR2nhuqNpIHRow61jaCoqOiDEkOG6p3UgdGnDqm4gZ+G7jWkgKGdyb3VwX2J5KSDEkeG7gyBuaMOzbSBk4buvIGxp4buHdSBj4buZdCBDb250cnkgc2F1IGTDuW5nIChzdW1tYXJpc2UpIMSR4buDIHTDrW5oIHThu5VuZyBW4bubaSB4IGzDoCB0w6puIFF14buRYyBHaWEsIHkgbMOgIHPhu5EgbMaw4bujbmcuIEFlcyhsYWJlbCA9IGZyZXEpIHjDoWMgxJHhu4tuaCBy4bqxbmcgbmjDo24gc+G6vSDEkcaw4bujYyBs4bqleSB04burIGPhu5l0IChmcmVxLiB2anVzdCA9IDIgKSDEkWnhu4F1IGNo4buJbmggduG7iyB0csOtIGThu41jIGPhu6dhIGPDoWMgbmjDo24gxJHhu4MgY2jDum5nIHh14bqldCBoaeG7h24gcGjDrWEgdHLDqm4gY+G7mXQuDQoNCg0KDQpgYGB7cn0NCmxpYnJhcnkoImdncGxvdDIiKQ0KbGlicmFyeSh0aWR5dmVyc2UpDQpsaWJyYXJ5KHNjYWxlcykNCm52NSU+JSAgZ3JvdXBfYnkoQ291bnRyeSkgJT4lIHN1bW1hcmlzZShmcmVxPSBuKCkpICU+JQ0KZ2dwbG90KGFlcyh4ID0gQ291bnRyeSx5ID0gZnJlcSkpICsNCiAgZ2VvbV9jb2woZmlsbD0nYnJvd24nKSArDQogIGxhYnModGl0bGU9IjEuQmnhu4N1IMSR4buTIGPhu6UgdGjhu4MgNSBxdeG7kWMgZ2lhIikgKw0KICBnZW9tX3RleHQoYWVzKGxhYmVsID1mcmVxKSx2anVzdCA9MiwgY29sb3IgPSdibGFjaycpICsNCiAgbGFicyh4PSAnVMOqbiBRRycsIHk9J1Phu5EgbMaw4bujbmcnKQ0KDQpgYGANCg0KDQojIyAyLkJp4buDdSDEkeG7kyB0aOG7gyBoaeG7h24gc+G6o24gcGjhuqltLg0KLVbhu5tpIGJp4buDdSDEkeG7kyBuw6B5IHRhIHRo4bqleSBz4buRIHBo4bqpbiB0csSDbSBj4bunYSA2IGxv4bqhaSBz4bqjbiBwaOG6qW0gxJFhbmcgxJHGsOG7o2Mgc+G6o24gc3XhuqV0IHbDoCBiw6FuIHJhIHbhu5tpIHPhu7EgY2jDqm5oIGzhu4djaCBraMO0bmcgxJHDoW5nIGvhu4MuDQoNCioqR2nhuqNpIHRow61jaCoqOiBHb2kgKGdyb3VwX2J5KSDEkeG7gyBuaMOzbSBk4buvIGxp4buHdSBj4buZdCBQcm9kdWN0IHNhdSBkw7luZyAoc3VtbWFyaXNlKSDEkeG7gyB0w61uaCB04buVbmcgVuG7m2kgeCBsw6AgdMOqbiBtw6Mgc+G6o24gcGjhuqltICwgeSBsw6AgcGjhuqduIHRyxINtLiAgQWVzKGxhYmVsID0gcGVyY2VudChuL2xlbmd0aChudjUkUHJvZHVjdCkgeMOhYyDEkeG7i25oIHLhurFuZyBuaMOjbiBz4bq9IMSRxrDhu6NjIGzhuqV5IHThu6sgY+G7mXQgKGZyZXEpIHbDoCB0w61uaCBz4buRIHBo4bqnbiB0csSDbSBj4bunYSBuw7MuDQoNCi4NCg0KDQpgYGB7cn0NCm52NSAlPiUgIGdyb3VwX2J5KFByb2R1Y3QpICU+JSBzdW1tYXJpc2Uobj0gbigpKSAlPiUNCmdncGxvdChhZXMoeCA9IFByb2R1Y3QsIHkgPSBuKSkgKw0KICBnZW9tX2NvbChmaWxsPSdicm93bicpICsNCiAgbGFicyh0aXRsZT0iMi5CaeG7g3UgxJHhu5MgdGjhu4MgaGnhu4duIHBo4bqnbiB0csSDbSBjw6FjIHNhbiBwaOG6qW0gxJHGsOG7o2Mgc+G6o24geHXhuqV0IikgKw0KICBnZW9tX3RleHQoYWVzKGxhYmVsID0gcGVyY2VudChuL2xlbmd0aChudjUkUHJvZHVjdCkpKSx2anVzdCA9MiwgY29sb3IgPSdibGFjaycpICsNCiAgbGFicyh4PSAnVMOqbiBz4bqjbiBwaOG6qW0nLCB5PSdQaOG6p24gdHLEg20nKQ0KYGBgDQoNCg0KIyMgMy4gQmnhu4N1IMSR4buTIHPhuqNuIHBo4bqpbSDEkcaw4bujYyBiw6FuIA0KLSBBZXMgeMOhYyDEkeG7i25oIHTDrW5oIMOhbmggeOG6oSBjaG8gYmnhu4N1IMSR4buTIChVbml0cy5Tb2xkKSxnZW9tX2RlbnNpdHkoKSDEkeG7gyB24bq9IG3hu5l0IMSRxrDhu51uZyBt4bqtdCDEkeG7mSAoZGVuc2l0eSBwbG90KSBk4buxYSB0csOqbiBk4buvIGxp4buHdSBj4bunYSBj4buZdCBVbml0cy5Tb2xkLiBmaWxsID0gJ2Jyb3duJyBjaOG7iSDEkeG7i25oIG3DoHUgc+G6r2MgY2hvIHBo4bqnbiBkxrDhu5tpIGPhu6dhIMSRxrDhu51uZyBt4bqtdCDEkeG7mS4gRmFjZXRfd3JhcCh+UHJvZHVjdCk6IENoaWEgYmnhu4N1IMSR4buTIHRow6BuaCBjw6FjIG5ow7NtIG5o4buPIGThu7FhIHRyw6puIGPhu5l0IFByb2R1Y3QuIE3hu5dpIG5ow7NtIHPhur0gY8OzIG3hu5l0IMSRxrDhu51uZyBt4bqtdCDEkeG7mSByacOqbmcsIGdpw7pwIHNvIHPDoW5oIG3huq10IMSR4buZIGPhu6dhIFVuaXRzLlNvbGQgZ2nhu69hIGPDoWMgc+G6o24gcGjhuqltIGtow6FjIG5oYXUuDQoNCmBgYHtyfQ0KbnY1ICU+JSBnZ3Bsb3QoYWVzKHggPSBVbml0cy5Tb2xkKSkgKw0KICBsYWJzKHRpdGxlPSIzLkJp4buDdSDEkeG7kyBz4buRIGzGsOG7o25nIHPhuqNuIHBo4bqpbSDEkcaw4bujYyBiw6FuIikgKw0KICBnZW9tX2RlbnNpdHkoZmlsbCA9ICdicm93bicpICsNCiAgZmFjZXRfd3JhcCh+UHJvZHVjdCkNCmBgYA0KDQojIyA0LiBCaeG7g3UgxJHhu5MgQ2hp4bq/dCBraOG6pXUgDQotIFRow6ptIDEgY+G7mXQgduG7m2kgdMOqbiBncm91cCDEkeG7gyBiaeG6v3QgxJHGsOG7o2Mgc+G6o24gcGjhuqltIGPDsyDEkcaw4bujYyBjaGnhur90IGto4bqldSBoYXkga2jDtG5nLiBzYXUgxJHDsyB0YSB24bq9IGJp4buDdSDEkeG7kyANCmPhu5l0IMSR4buDIHRo4buDIGhp4buHbiBk4buvIGxp4buHdSB24burYSB04bqhby4gDQoNCioqR2nhuqNpIHRow61jaCoqOiAgdOG7qyBt4buZdCBj4buZdCB24burYSBow6xuaCB0aMOgbmggdsOgIHbDoCB24bq9IGJp4buDdSDEkeG7kyB0YSBjbyB0aOG7gyB0aMOieSDEkcaw4bujYyBjw7MgOTUzIHPhu5Egc+G6o24gcGjhuqltIMSRxrDhu6NjIGNoaeG6v3Qga2jhuql1IHbDoCA1MyBz4bqjbiBwaOG6qW0ga2jDtG5nIGNoaeG6v2Mga2jhuqV1Lg0KDQoNCmBgYHtyfQ0KbnY1JGdyb3VwIDwtIGlmZWxzZShudjUkRGlzY291bnRzID4gMCwgIkPDsyBjaGnhur90IGto4bqldSIsICJLaMO0bmcgY2hp4bq/dCBraOG6pXUiKQ0KdGFibGUobnY1JGdyb3VwKQ0KYGBgDQoNCmBgYHtyfQ0KbnY1ICU+JSBncm91cF9ieShncm91cCkgJT4lIHN1bW1hcmlzZShuID0gbigpKSAlPiUNCiAgZ2dwbG90KGFlcyhncm91cCxuKSkgKw0KICAgIGdlb21fY29sKGZpbGw9J2Jyb3duJykgKw0KICAgIGdlb21fdGV4dChhZXMobGFiZWwgPSBuKSx2anVzdCA9IDEsIGNvbG9yID0gJ2JsYWNrJykgKw0KICAgIGxhYnModGl0bGUgPSAiNC5CaeG7g+G7kyB0aOG7gyBoaeG7h24gbmjDs20gdGhlbyBjaGnhur90IGto4bqldSAiLHggPSAnTeG7qWMgxJHhu5knLCB5ID0gJ1Phu5EgbMaw4bujbmcnKQ0KYGBgDQoNCg0KIyMgNS4gQmnhu4N1IMSR4buTIHThuqduIHPhu5EgDQotIEJp4buDdSDEkeG7kyBuw6B5IHRo4buDIGhp4buHbiB04bqnbiBz4buRIGdpw6EgxJHGsOG7o2MgY2hp4bq/dCBraOG6pXUg4bufIENhbmFhZGEgJiBNZXhpY28uDQoNCioqR2nhuqNpIHRow61jaCoqOiBGaWx0ZXIgbOG7jWMgZOG7ryBsaeG7h3UgQ291bnRyeSBj4bqjdSAyIHF14buRYyBnaWEuIFbDoCB0aOG7sWMgaGnhu4duIMOhbmggeOG6oSBjaG8gYmnhu4N1IMSR4buTLiBW4bubaSB4IGzDoCBkb2FuaCB0aHUsIHkgbMOgIHThuqduIHPhu5EgYsOhbi4NCg0KYGBge3J9DQpudjUgJT4lIGZpbHRlcihDb3VudHJ5PT0gJ0NhbmFkYScgfCBDb3VudHJ5PT0gJ01leGljbycpICU+JQ0KICBnZ3Bsb3QoYWVzKHg9R3Jvc3MuU2FsZXMsIGNvbG9yPUNvdW50cnkpKSArIA0KICBnZW9tX2ZyZXFwb2x5KGxpbmV3aWR0aCA9IDEpICsNCiAgbGFicyh0aXRsZSA9ICI1LkLhu4N1IMSR4buTIHThuqduIHPhu5EgZ2nDoSB0csaw4bubYyBjaGnhur90IGto4bqldSDhu58gcXXhu5FjIGdpYSBDYW5hZGEgJiBNZXhpY28iKQ0KICBsYWJzKHggPSAnRG9hbmggdGh1JywgeT0gJ1ThuqduIHPhu5EgYsOhbicpDQpgYGANCiMjIDYuQmnhu4N1IMSR4buTIGNoaSBwaMOtIGjDoG5nIGjDs2EgxJHGsOG7o2MgYsOhbi4NCg0KDQpgYGB7cn0NCm52NSAlPiUgZ2dwbG90KGFlcyh4ID0gQ09HUykpICsNCiAgZ2VvbV9oaXN0b2dyYW0oYmlud2lkdGggPTUwMDAwLCBmaWxsID0gJ2Jyb3duJywgY29sb3I9ICdyZWQnKSArDQogIGxhYnModGl0bGUgPSAiIDYuQ2hpIHBow60gaMOgbmcgaMOzYSIsIHg9IkNoaSBwaMOtIiwgeT0iU+G7kSBsxrDhu6NuZyAiKQ0KYGBgDQoNCiMjIDcuQmnhu4N1IMSR4buTIHRo4buDIGhp4buHbiBz4bqjbiBwaOG6qW0gDQotR2dwbG90KGFlcyh4ID0gJycsIHkgPSBuLCBmaWxsID0gUHJvZHVjdCkpOiDEkMOieSBsw6AgYsaw4bubYyBi4bqvdCDEkeG6p3UgdOG6oW8gbeG7mXQgYmnhu4N1IMSR4buTIHPhu60gZOG7pW5nIHRoxrAgdmnhu4duIGdncGxvdDIuIGFlcygpIHjDoWMgxJHhu4tuaCBtYXBwaW5nIGFlc3RoZXRpY3MgKHRodeG7mWMgdMOtbmggw6FuaCB44bqhKSBjaG8gYmnhu4N1IMSR4buTLiBUcm9uZyB0csaw4budbmcgaOG7o3AgbsOgeSwgY2jDum5nIHRhIMSRYW5nIMOhbmggeOG6oSB0cuG7kW5nICgnJykgdsOgbyB0cuG7pWMgeCAoxJHhu4MgdOG6oW8gcmEgYmnhu4N1IMSR4buTIHRyw7JuKSwgc+G7kSBsxrDhu6NuZyBuIHbDoG8gdHLhu6VjIHkgdsOgIHPhu60gZOG7pW5nIG3DoHUgc+G6r2MgKGZpbGwpIMSR4buDIHBow6JuIGJp4buHdCBnaeG7r2EgY8OhYyBz4bqjbiBwaOG6qW0uDQotR2VvbV90ZXh0KGFlcyh4ID0gMS4zLCBsYWJlbCA9IG4pLCBwb3NpdGlvbiA9IHBvc2l0aW9uX3N0YWNrKHZqdXN0ID0gLjUpKTogVGjDqm0gY8OhYyBuaMOjbiB2xINuIGLhuqNuIGzDqm4gdHLDqm4gY+G7mXQsIHbhu5tpIGdpw6EgdHLhu4sgbiBsw6Agc+G7kSBsxrDhu6NuZyBz4bqjbiBwaOG6qW0sIHbDoCB24buLIHRyw60geMOhYyDEkeG7i25oIGLhurFuZyAxLjMuIHBvc2l0aW9uX3N0YWNrKHZqdXN0ID0gLjUpIHjDoWMgxJHhu4tuaCB24buLIHRyw60gZOG7jWMgY+G7p2EgbmjDo24NCi10aGVtZV92b2lkKCk6IMSQ4bq3dCBnaWFvIGRp4buHbiBj4bunYSBiaeG7g3UgxJHhu5MgdGjDoG5oIGdpYW8gZGnhu4duIHRy4buRbmcsIG5naMSpYSBsw6Aga2jDtG5nIGPDsyBjw6FjIHRow6BuaCBwaOG6p24gYuG7lSBzdW5nIG5oxrAgbMaw4bubaSBob+G6t2MgdHLhu6VjLg0KDQpgYGB7cn0NCm52NSAlPiUgZ3JvdXBfYnkoUHJvZHVjdCkgJT4lIHN1bW1hcmlzZShuID0gbigpKSAlPiUNCiAgZ2dwbG90KGFlcyh4ID0nJywgeSA9IG4sZmlsbCA9IFByb2R1Y3QpKSArDQogICAgZ2VvbV9jb2woY29sb3IgPSAnYmxhY2snKSArDQogICAgbGFicyh0aXRsZT0gJzcuIEJp4buDdSDEkeG7kyB0aOG7gyBoaeG7h24gc+G6o24gcGjhuqltJykgKw0KICAgIGNvb3JkX3BvbGFyKCd5JykgKw0KICAgIGdlb21fdGV4dChhZXMoeCA9IDEuMywgbGFiZWwgPSBuKSxwb3NpdGlvbiA9IHBvc2l0aW9uX3N0YWNrKHZqdXN0ID0gLjUpKSArDQogICAgdGhlbWVfdm9pZCgpDQpgYGANCg0KDQojIyA4Lk3hu5FpIHF1YW4gaOG7hyBHacOhIGLDoW4gdsOgIGdpw6Egc+G6o24geHXhuqV0IA0KLUJp4buDdSDEkeG7kyBuw6B5IGPDsyB0aOG7gyB0aOG6pXkgZ2nDoSBiw6FuIHbDoCBnacOhIHPhuqNuIHh14bqldCB04bu3IGzhu4cgdGh14bqtbiB24bubaSBuaGF1IGPDsyB4dSBoxrDhu5tuZyBraMOhIMSR4buTbmcgxJFp4buBdS4NCg0KKipHaeG6o2kgdGjDrWNoKio6IFbhu5tpIHggbMOgIGdpw6Egc+G6o24geHXhuqV0LCB5IGzDoCBnacOhIGLDoW4gDQoNCmBgYHtyfQ0KbnY1ICU+JSBnZ3Bsb3QoYWVzKHggPSBNYW51ZmFjdHVyaW5nLlByaWNlLCB5ID0gU2FsZS5QcmljZSkpICsNCiAgZ2VvbV9wb2ludCgpICsNCiAgeGxhYignR2nDoSBz4bqjbiB4deG6pXQgc+G6o24gcGjhuqltJykgKw0KICB5bGFiKCdHacOhIGLDoW4nKQ0KYGBgDQoNCiMjIDkuQmnhu4N1IMSR4buTIHRo4buDIGhp4buHbiBs4bujaSBuaOG6rW4gZ+G7mXAgLg0KDQotw4FuaCB44bqhIGPhu6dhIGJp4buDdSDEkeG7kyBuw6B5IGzDoCBj4buZdCBQcm9maXQuIENobyB0aOG6pXkgTOG7o2kgbmh14bqtbiBn4buZcCB04burIHZp4buHYyBiw6FuIGjDoG5nICh04buVbmcgZG9hbmggc+G7kSBiw6FuIGjDoG5nIHRy4burIMSRaSBjaGkgcGjDrSBz4bqjbiB4deG6pXQgdsOgIGPDoWMgY2hpIHBow60gbGnDqm4gcXVhbiBraMOhYylj4bunYSB04burbmcgbcOjIHPhuqNuIHBo4bqpbS4NCg0KDQoNCmBgYHtyfQ0KZ2dwbG90KG52NSwgYWVzKHggPSBQcm9maXQpKSArDQogIGdlb21fZGVuc2l0eShmaWxsID0gImJyb3duIiwgY29sb3IgPSAiYmxhY2siKSArDQogIGxhYnModGl0bGUgPSAiIiwgeCA9ICJM4bujaSBuaOG6rW4gY+G7p2EgdOG7q25nIG3DoyBzcCIsIHkgPSAiTOG7o2kgbmjhuq1uIGfhu5lwIikgKw0KICBmYWNldF93cmFwKH4gUHJvZHVjdCkNCg0KYGBgDQoNCiMjIDEwLlNvIHPDoW5oIHPhuqNuIHPhu5Egc+G6o24gcGjhuqltIGLDoW4gcmEg4bufIDIgUXXhu5FjIGdpYS4NCi1M4buNYyBk4buvIGxp4buHdSBj4bunYSBj4buZdCBDb3VudHJ5IGNo4buJIGzhuqV5IGThu68gbGnhu4d1IGPhu6dhIEZyYW5jZSB2w6AgQ2FuYWRhIMSR4buDIHRo4buxYyBoaeG7h24gcGjDom4gdMOtY2guIFjDoWMgxJHhu4tuaCDDoW5oIHjhuqEgKFVuaXRzLlNvbGQpIGPhu6dhIGJp4buDdSDEkeG7kyB2w6AgbcOgdSBz4bqvYyDEkeG7gyBwaMOibiBiaeG7h3QgMiBxdeG7kWMgZ2lhIG7DoHkuDQoNCg0KYGBge3J9DQpudjUgJT4lIGZpbHRlcihDb3VudHJ5PT0gJ0ZyYW5jZScgfCBDb3VudHJ5PT0gJ0NhbmFkYScpICU+JQ0KICBnZ3Bsb3QoYWVzKHg9VW5pdHMuU29sZCwgZmlsbCA9IENvdW50cnkpKSArDQogIGdlb21fZGVuc2l0eSgpICsNCiAgbGFicyh0aXRsZSA9ICJCaeG7g3UgxJHhu5MgdGjhu4MgaGnhu4duIHPhu5EgbMaw4bujbmcgc+G6o24gcGjhuqVtIGPhu6dhIDIgUXXhu5FjIGdpYSIpKyANCiAgbGFicyh4ID0gJ1PhuqNuIHBo4bqpbScsIHk9JyBHacOhIHRyaScpDQpgYGANCg0KIyMgMTEuIEJp4buDdSDEkeG7kyBnacOhIHRy4buLIHRydW5nIGLDrG5oIGdpw6EgYsOhbiBj4bunYSA1IHF14buRYyBnaWEuDQoNCi1H4buNaSBncm91cF9ieShDb3VudHJ5KSDEkeG7gyBuaMOzbSBk4buvIGxp4buHdSB0aGVvIGPhu5l0IENvdW50cnksIHNhdSDEkcOzIHPhu60gZOG7pW5nIHN1bW1hcmlzZShtID0gbWVhbihTYWxlLlByaWNlKSkgxJHhu4MgdMOtbmggZ2nDoSB0cuG7iyB0cnVuZyBiw6xuaCBj4bunYSBj4buZdCBTYWxlLlByaWNlIGNobyBt4buXaSBxdeG7kWMgZ2lhLg0KDQotQW5oIHjhuqEgdMOqbiBxdeG7kWMgZ2lhIChDb3VudHJ5KSB2w6BvIHRy4bulYyB4IHbDoCBnacOhIHRydW5nIGLDrG5oIChtKSB2w6BvIHRy4bulYyB5LCBwb3NpdGlvbiA9ICdkb2RnZScgY2hvIGJp4bq/dCBjw6FjIGPhu5l0IHPhur0gxJHGsOG7o2MgaGnhu4NuIHRo4buLIGPDoWNoIHhhIG5oYXUgKHRyw6FuaCBjaOG7k25nIGNow6lvKSB0csOqbiB0cuG7pWMgeC4NCg0KLWzDoG0gdHLDsm4gxJHhur9uIDIgY2jhu68gc+G7kSB0aOG6rXAgcGjDom4gYsSDbmcgbOG7h25oIChyb3VuZChtLCAyKSkuIHZqdXN0ID0gMiBjaOG7iSDEkeG7i25oIHbhu4sgdHLDrSBk4buNYyBj4bunYSBjw6FjIG5ow6NuDQoNCg0KYGBge3J9DQpudjUgJT4lIGdyb3VwX2J5KENvdW50cnkpICU+JSBzdW1tYXJpc2UobT0gbWVhbihTYWxlLlByaWNlKSkgJT4lDQogIGdncGxvdChhZXMoeCA9IENvdW50cnkseSA9IG0pKSArDQogICAgZ2VvbV9jb2wocG9zaXRpb24gPSAnZG9kZ2UnKSArDQogICAgZ2VvbV90ZXh0KGFlcyhsYWJlbCA9IHJvdW5kKG0sMikpLCB2anVzdCA9IDIsIGNvbG9yID0gJ2Jyb3duJykgKw0KICAgIGxhYnMoeCA9ICdRdeG7kWMgZ2lhJywgeT0gJ0dpw6EgYsOhbiAnKQ0KYGBgDQoNCg0KDQojIyAxMi5N4buRaSBxdWFuIGjhu4cgZ2nhu69hIEdpw6Egc+G6o24geHXhuqV0IHbDoCBUaeG7gW4gY2hp4bq/dCBraOG6pXUuDQoNCi1udjUgJT4lIGdncGxvdChhZXMoeCA9IE1hbnVmYWN0dXJpbmcuUHJpY2UsIHkgPSBEaXNjb3VudHMsIGNvbG9yID0gUHJvZHVjdCkpOiDEkMOieSBsw6AgYsaw4bubYyBi4bqvdCDEkeG6p3UgdOG6oW8gbeG7mXQgYmnhu4N1IMSR4buTIHPhu60gZOG7pW5nIHRoxrAgdmnhu4duIGdncGxvdDIuIGFlcygpIHjDoWMgxJHhu4tuaCBtYXBwaW5nIGFlc3RoZXRpY3MgKHRodeG7mWMgdMOtbmggw6FuaCB44bqhKSBjaG8gYmnhu4N1IMSR4buTLiBUcm9uZyB0csaw4budbmcgaOG7o3AgbsOgeSwgY2jDum5nIHRhIMSRYW5nIMOhbmggeOG6oSBnacOhIHPhuqNuIHh14bqldCAoTWFudWZhY3R1cmluZy5QcmljZSkgdsOgbyB0cuG7pWMgeCwgc+G7kSB0aeG7gW4gY2hp4bq/dCBraOG6pXUgKERpc2NvdW50cykgdsOgbyB0cuG7pWMgeSwgdsOgIHPhu60gZOG7pW5nIG3DoHUgc+G6r2MgKGNvbG9yKSDEkeG7gyBwaMOibiBiaeG7h3QgZ2nhu69hIGPDoWMgc+G6o24gcGjhuqltLg0KDQotR2VvbV9wb2ludCgpOiBUaMOqbSBt4buZdCBsYXllciB24bubaSBnZW9tX3BvaW50KCkgxJHhu4MgduG6vSBjw6FjIMSRaeG7g20gdHLDqm4gYmnhu4N1IMSR4buTLCBt4buXaSDEkWnhu4NtIGJp4buDdSBkaeG7hW4gbeG7mXQgY+G6t3AgZ2nDoSB0cuG7iyBj4bunYSBnacOhIHPhuqNuIHh14bqldCB2w6AgdGnhu4FuIGNoaeG6v3Qga2jhuqV1Lg0KDQpgYGB7cn0NCm52NSAlPiUgZ2dwbG90KGFlcyh4ID0gTWFudWZhY3R1cmluZy5QcmljZSwgeSA9IERpc2NvdW50cywgY29sb3IgPSBQcm9kdWN0KSkrDQogIGdlb21fcG9pbnQoKSArDQogIHhsYWIoJ0dpw6Egc+G6o24geHXhuqV0IHPhuqNuIHBo4bqpbScpICsgDQogIHlsYWIoJ1Rp4buBbiBjaGnhur90IGto4bqldScpDQpgYGANCg0KDQoNCg0KIyMgMTMuQmnhu4N1IMSR4buTIHRo4buDIGhp4buHbiBz4bqjbiBwaOG6qW0uDQoNCmBgYHtyfQ0KbnY1ICU+JSBncm91cF9ieShQcm9kdWN0KSAlPiUgc3VtbWFyaXNlKG4gPSBuKCkpICU+JQ0KICBnZ3Bsb3QoYWVzKHggPSAnJywgeSA9IG4sIGZpbGwgPSBQcm9kdWN0KSkgKw0KICBnZW9tX2NvbCgpICsNCiAgZ2VvbV90ZXh0KGFlcyhsYWJlbCA9IG4pLCBwb3NpdGlvbiA9IHBvc2l0aW9uX3N0YWNrKHZqdXN0ID0gMSkpDQpgYGANCg0KIyMgMTQuQmnhu4N1IMSR4buTIHPhuqNuIHPhu5Egc+G6o24gcGjhuqltIGPDsyBjaGnhur90IGto4bqldSDhu58gTWV4aWNvLg0KDQotVuG7m2kgYmnhu4N1IMSR4buTIG7DoHkgdGEgY8OzIHRo4buDIHRo4bqleSDhu58gTWV4aWNvIGPDsyA4IHPhuqNuIHBo4bqpbSBraMO0bmcgY8OzIGNoaeG6v3Qga2jhuqV1IHbDoCAyMzMgc+G6o24gcGjhuqltIMSRw6MgY2hp4bq/dCBraOG6pXUuDQoNCg0KDQpgYGB7cn0NCm48LSBudjUlPiUgZmlsdGVyKENvdW50cnkgPT0gJ01leGljbycpDQpuICU+JSBncm91cF9ieShncm91cCkgJT4lIHN1bW1hcmlzZShuID0gbigpKSAlPiUNCiAgZ2dwbG90KGFlcyh4ID0gJycsIHkgPSBuLGZpbGwgPSBncm91cCkpICsNCiAgICBnZW9tX2NvbChjb2xvciA9ICdibGFjaycsIHdpZHRoID0gMSkgKw0KICAgIGNvb3JkX3BvbGFyKCd5JykgKw0KICAgIGdlb21fdGV4dChhZXMoeCA9IDEuMywgbGFiZWwgPSBuKSxwb3NpdGlvbiA9IHBvc2l0aW9uX3N0YWNrKHZqdXN0ID0gLjUpKSArDQogICAgdGhlbWVfdm9pZCgpDQpgYGANCg0KIyMgMTUuQmnhu4N1IMSR4buTIHThuqduIHPhu5EgbOG7o2kgbmh14bqtbi4NCg0KDQotTOG7jWMgZOG7ryBsaeG7h3UgY+G7mXQgUHJvZHVjdCBjaOG7iSBs4bqleSBk4buvIGxp4buHdSBQYXNlbyB2w6AgVlRUIMSR4buDIHBow6JuIHTDrWNoIGzhu6NpIG5odeG6rW4gZ+G7mXAgbcOgIG7DsyBtYW5nIGzhuqFpLiDDgW5oIHjhuqEgY+G7p2EgYmnhu4N1IMSR4buTIG7DoHkgbMOgIFByb2ZpdC4gxJDGsOG7nW5nIHThuqduIHPhu5EgKGZyZXF1ZW5jeSBwb2x5Z29uKSBk4buxYSB0csOqbiBk4buvIGxp4buHdSBj4bunYSBj4buZdCBQcm9maXQuIGxpbmV3aWR0aCA9IDEgY2jhu4kgxJHhu4tuaCDEkeG7mSBy4buZbmcgY+G7p2EgxJHGsOG7nW5nLg0KDQpgYGB7cn0NCm52NSAlPiUgZmlsdGVyKFByb2R1Y3Q9PSAnUGFzZW8nIHxQcm9kdWN0PT0gJ1ZUVCcpICU+JQ0KICBnZ3Bsb3QoYWVzKHg9UHJvZml0LCBjb2xvcj1Qcm9kdWN0KSkgKyANCiAgZ2VvbV9mcmVxcG9seShsaW5ld2lkdGggPSAxKSArDQogIGxhYnModGl0bGUgPSAiMTUuQuG7g3UgxJHhu5MgdOG6p24gc+G7kSBs4bujaSBuaOG6rW4gZ+G7mXAgY+G7p2EgUGFzZW8gJiBWVFQiKSArDQogIGxhYnMoeCA9ICdM4bujaSBuaHXhuq1uJywgeT0nVOG6p24gc+G7kScpDQpgYGANCg0KDQoNCg0KDQoNCg0K