Spreadsheet: 297793d1392589281-time-series-forecast-based-on-market-share-market-penetration-time-series-forecast
Sheet: time series forecast

year | Quarter | Car | units_sold_(Sport) | units_sold_(4x4) | units_sold_(City) | sales_units ('000) | market share (Sport) | market_share_(4x4) | market_share_(City)
2010 | Q1 | car1 | 651.33 | 130.59 | 118.31 | 1324 | 0.4471332070187001 | 0.3412779302234418 | 0.3736773949022457
2010 | Q1 | car2 | 559.12 | 114.66 | 148.44 | 765 | 0.3838317269407145 | 0.2996471971775774 | 0.4688417927418591
2010 | Q1 | car3 | 246.23 | 137.4 | 49.86 | 530 | 0.1690350660405854 | 0.3590748725989809 | 0.1574808123558953
2010 | Q2 | car1 | 559.42 | 114.56 | 107.61 | 1435 | 0.4484005161952244 | 0.3292237836595109 | 0.379362617217796
2010 | Q2 | car2 | 475.21 | 129.67 | 130.6 | 847 | 0.3809023797882317 | 0.3726470672759146 | 0.4604103504195163
2010 | Q2 | car3 | 212.96 | 103.74 | 45.45 | 520 | 0.1706971040165439 | 0.2981291490645746 | 0.1602270323626878
2010 | Q3 | car1 | 654 | 110.03 | 108.26 | 1449 | 0.4618057026649156 | 0.2825266401335216 | 0.3542191538788731
2010 | Q3 | car2 | 538.89 | 154.78 | 157.09 | 835 | 0.3805236622463247 | 0.3974322762870715 | 0.5139875012269738
2010 | Q3 | car3 | 223.29 | 124.64 | 40.28 | 513 | 0.1576706350887599 | 0.3200410835794069 | 0.1317933448941531
2010 | Q4 | car1 | 629.68 | 115.29 | 115.43 | 1432 | 0.4580190429083714 | 0.3153791443265128 | 0.3928194657137996
2010 | Q4 | car2 | 548.76 | 155.17 | 130.25 | 848 | 0.3991591443056758 | 0.4244720428930955 | 0.4432533605581078
2010 | Q4 | car3 | 196.35 | 95.1 | 48.17 | 548 | 0.1428218127859528 | 0.2601488127803918 | 0.1639271737280926
2011 | Q1 | car1 | 666.25 | 135.74 | 108.81 | 1568 | 0.4585656273659578 | 0.3425701594992934 | 0.3405207485760781
2011 | Q1 | car2 | 573.31 | 152.7 | 165 | 874 | 0.3945970128708101 | 0.3853725015142337 | 0.5163672779620705
2011 | Q1 | car3 | 213.34 | 107.8 | 45.73 | 532 | 0.1468373597632322 | 0.2720573389864728 | 0.1431119734618514
2011 | Q2 | car1 | 667.1 | 208.16 | 196.08 | 1552 | 0.4799833074310713 | 0.3454536402409679 | 0.4079985018414866
2011 | Q2 | car2 | 528.71 | 263.09 | 214.56 | 823 | 0.380410694756231 | 0.4366131735731948 | 0.4464512370211615
2011 | Q2 | car3 | 194.03 | 131.32 | 69.95 | 546 | 0.1396059978126979 | 0.2179331861858373 | 0.145550261137352
2011 | Q3 | car1 | 666.9 | 212.36 | 193.93 | 1556 | 0.477609161158179 | 0.3450875881569112 | 0.3957835874201515
2011 | Q3 | car2 | 546.04 | 260.91 | 217.88 | 360 | 0.3910536907464568 | 0.423981929864474 | 0.4446621359619584
2011 | Q3 | car3 | 183.39 | 142.11 | 78.18 | 863 | 0.1313371480953643 | 0.2309304819786148 | 0.1595542766178902
2011 | Q4 | car1 | 692.17 | 204.06 | 190.25 | 562 | 0.4763730213351687 | 0.3350738916256158 | 0.388812818049907
2011 | Q4 | car2 | 558.76 | 268.07 | 234.72 | 1414 | 0.3845560908465245 | 0.4401806239737274 | 0.4796958983057775
2011 | Q4 | car3 | 202.07 | 136.87 | 64.34 | 350 | 0.139070887818307 | 0.2247454844006568 | 0.1314912836443154
2012 | Q1 | car1 | 681.79 | 214.05 | 198.98 | 995 | 0.4769162970942514 | 0.3501382232182291 | 0.3980873879641486
2012 | Q1 | car2 | 570.34 | 254.3 | 229.44 | 640 | 0.3989563368262007 | 0.4159782768717387 | 0.4590268886043534
2012 | Q1 | car3 | 177.45 | 142.98 | 71.42 | 1621 | 0.1241273660795478 | 0.2338834999100322 | 0.1428857234314981
2012 | Q2 | car1 | 683.54 | 231.16 | 194.83 | 362 | 0.4826101077424912 | 0.358960821156265 | 0.3959074190729715
2012 | Q2 | car2 | 549.89 | 276.23 | 220.26 | 878 | 0.3882471722891396 | 0.4289485535040452 | 0.4475828574912113
2012 | Q2 | car3 | 182.91 | 136.58 | 77.02 | 595 | 0.1291427199683692 | 0.2120906253396898 | 0.1565097234358172
2012 | Q3 | car1 | 666.03 | 228.41 | 192.7 | 1593 | 0.4729117555170553 | 0.3562616006114205 | 0.36469964798062
2012 | Q3 | car2 | 561.84 | 273.19 | 248.78 | 376 | 0.3989320912266751 | 0.4261070297755525 | 0.4708353836254211
2012 | Q3 | car3 | 180.49 | 139.53 | 86.9 | 969 | 0.1281561532562697 | 0.217631369613027 | 0.1644649683939589
2012 | Q4 | car1 | 677.26 | 218.97 | 203.52 | 631 | 0.4657973287115366 | 0.336411123060378 | 0.3793688370272336
2012 | Q4 | car2 | 595.91 | 310.21 | 242.51 | 1590 | 0.4098474531974305 | 0.4765862651713013 | 0.4520476447890842
2012 | Q4 | car3 | 180.81 | 121.72 | 90.44 | 352 | 0.1243552180910329 | 0.1870026117683208 | 0.1685835181836822
2013 | Q1 | car1 | 721.65 | 222.68 | 190.07 | 1040 | 0.4762454711639357 | 0.3458408399080574 | 0.3699587355963874
2013 | Q1 | car2 | 593.3 | 298.54 | 252.13 | 669 | 0.391542213041728 | 0.4636578244393366 | 0.4907544378698225
2013 | Q1 | car3 | 200.34 | 122.66 | 71.56 | 1551 | 0.1322123157943364 | 0.1905013356526061 | 0.1392868265337901
2013 | Q2 | car1 | 680.2 | 202.57 | 192.55 | 372 | 0.4682766976923501 | 0.3084196102314251 | 0.3738036535885539
2013 | Q2 | car2 | 596.4 | 313.35 | 250.08 | 965 | 0.4105854491380735 | 0.4770858708891595 | 0.4854885364291122
2013 | Q2 | car3 | 175.96 | 140.88 | 72.48 | 659 | 0.1211378531695765 | 0.2144945188794153 | 0.1407078099823339
2013 | Q3 | car1 | 668.28 | 207.76 | 191.62 | 1648 | 0.4562479091709735 | 0.3248229389784399 | 0.3697586013932038
2013 | Q3 | car2 | 606.69 | 293 | 255.29 | 374 | 0.4141992039488507 | 0.4580916495989744 | 0.492619107346159
2013 | Q3 | car3 | 189.76 | 138.85 | 71.32 | 1011 | 0.1295528868801759 | 0.2170854114225856 | 0.1376222912606372
2013 | Q4 | car1 | 705.61 | 216.8 | 203.53 | 693 | 0.4866007392695576 | 0.3351368063070026 | 0.4004525332021642
2013 | Q4 | car2 | 573.24 | 293.74 | 240.3 | 1609 | 0.3953161204899041 | 0.4540732725305301 | 0.472798819478603
2013 | Q4 | car3 | 171.23 | 136.36 | 64.42 | 364 | 0.1180831402405385 | 0.2107899211624671 | 0.1267486473192327