149388_Lazaro_Labrakis_Task_A_4075617_1213448513.docx

72828 727465332 7 340936 6 1000573 9 727364963 3 sep

Info icon This preview shows pages 13–20. Sign up to view the full content.

View Full Document Right Arrow Icon
72828 72746.5332 7 340.936 6 1.000573 9 72736.4963 3 Sep-2012 74289 73194.7897 4 358.927 5 1.012269 1 73837.0288 7 Oct-2012 75028 74554.2342 4 526.652 4 0.982915 2 71001.8590 5 Nov-2012 77797 75256.5112 8 556.093 8 1.029424 7 77045.7164 Dec-2012 76166 75832.7235 5 559.466 4 1.003913 2 76081.8346 5 Jan-2013 68580 76371.8203 9 556.051 7 0.898408 9 68656.3156 4 Feb-2013 70172 75980.2436 6 397.193 0.945255 73970.5020 7 Mar-2013 77812 75182.1520 3 196.817 6 1.066331 8 83242.6467 4 Apr-2013 67228 75215.5695 4 169.425 5 0.897342 67841.0474 1 May-2013 75926 75423.9123 1 175.949 5 1.005718 6 75762.9525 9 Jun-2013 92034 75546.9291 4 167.076 1.219784 92303.4139 9 Jul-2013 71886 75414.7429 4 116.908 2 0.960140 1 73090.3002 5 Aug-2013 75575 75531.6511 4 116.908 2 1.000573 9 75574.9999 9 Sep-2013 73348 74883.4342 2 -11.356 0.998209 9 76576.7013 8 Oct-2013 73197 74775.4563 4 -27.5535 0.981188 8 73592.9049 2 Nov-2013 77978 74988.0746 8 12.7084 5 1.033906 4 76947.3382 7 Dec-2013 76229 75224.1348 3 50.1507 3 1.007964 9 75294.2728 9 Jan-2014 67494 75238.7495 5 44.1935 4 0.897832 1 67627.0890 2 Feb-2014 69518 74865.8415 -25.7286 0.938096 71161.5773
Image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
9 4 9 Mar-2014 77857 74402.0242 5 -99.169 1.057797 1 79804.3941 9 Apr-2014 64377 73688.5192 3 -202.155 0.887172 9 66675.0706 2 May-2014 74549 73639.5884 2 -176.469 1.008563 1 73906.6024 5 Jun-2014 90690 73675.6824 -140.835 1.224567 7 89609.1388 9 Jul-2014 72269 73950.8965 4 -71.0895 0.967482 7 70603.7519 6 Aug-2014 70201 72987.6622 8 -220.647 0.983949 2 73922.2078 7 Sep-2014 75221 73388.0444 2 -116.539 1.009692 2 72636.7571 3 Oct-2014 71961 73288.0865 9 -113.759 0.981490 5 71893.1792 2 Nov-2014 74095 72812.2870 5 -174.451 1.026918 4 75655.4059 8 Dec-2014 75717 73232.9508 6 -74.687 1.019099 1 73216.3919 5 Jan-2015 67478 73637.6293 8 5.67296 2 0.905776 9 65683.8391 5 Feb-2015 72814 74596.9795 6 165.545 7 0.954398 6 69084.5196 5 Mar-2015 83688 75806.6986 8 340.589 1 1.077602 6 79083.5851 5 Apr-2015 64679 75369.4244 2 210.189 5 0.874726 8 67555.8087 9 May-2015 73122 74841.1441 86.3937 0.995035 8 76226.8114 9 Jun-2015 98642 76276.8757 5 312.594 3 1.254013 9 91753.8440 8 Jul-2015 74099 76589.4727 9 312.594 8 0.967482 8 74098.9889 9 Aug-2015 73573 76391.3788 6 226.983 8 0.975007 9 75667.7315 3 Sep-2015 83052 77970.4451 3 453.644 5 1.033492 3 77360.9606 5 Oct-2015 75600 78088.6400 7 397.410 3 0.975759 4 76972.5013 9 Nov-2015 77796 77831.3353 2 287.655 1 1.015176 2 80598.7717 7 Dec-2015 79611 78118.9920 4 287.655 4 1.019099 1 79610.9930 1 Jan-2016 68287 77683.1307 6 166.366 3 0.894309 6 71018.9274 9 Feb-2016 76423 78383.2408 3 255.842 2 0.963232 6 74299.4522 2 Mar-2016 82089 78048.5732 156.850 1.066520 84741.6816
Image of page 14
6 2 1 3 Apr-2016 68454 78217.9352 5 158.947 6 0.874917 68408.3761 May-2016 74452 77524.4706 3 16.0507 5 0.980163 8 77987.8008 3 Jun-2016 99843 78039.0510 8 99.6233 8 1.264903 2 97236.8896 2 Jul-2016 71850 77209.4167 2 -56.1557 0.951654 7 75597.8211 4 Aug-2016 75341 77181.7909 9 -51.373 0.975497 8 75225.0396 8 Sep-2016 81573 77561.9804 7 20.9733 6 1.041309 79713.6960 7 Oct-2016 74259 77228.1302 8 -38.5086 0.969665 4 75702.2932 8 Nov-2016 77388 76959.6889 5 -77.0541 1.011053 3 78361.0644 Dec-2016 77321 76640.1790 6 -117.699 1.014716 7 78351.0263 8 Jan-2017 69047 76686.6961 1 -90.1701 0.896912 7 68434.7865 Feb-2017 70237 75714.1089 7 -238.097 0.947972 9 73780.2719 9 Mar-2017 80496.6833 8 Apr-2017 65826.9272 5 May-2017 73512.1082 5 Jun-2017 94566.3373 8 Jul-2017 70920.7596 3 Aug-2017 72465.3697 3 Sep-2017 77106.2541 1 Oct-2017 71570.3589 5 Nov-2017 74384.4435 1 Dec-2017 74412.3650 9 Jan-2018 65559.8748 5 Feb-2018 69066.4107 9 Mar-2018 77449.4615 1 Apr-2018 63327.1468 2 May-2018 70711.6203 4 Jun-2018 90952.3027 4
Image of page 15

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Jul-2018 68201.7268 4 Aug-2018 69678.2133 5 Sep-2018 74131.0645 1 Oct-2018 68799.8666 6 Nov-2018 71495.6992 4 Dec-2018 71513.1538 3 Jan-2019 62997.2488 7 Feb-2019 66357.8975 7 Mar-2019 74402.2396 5 Apr-2019 60827.3663 8 May-2019 67911.1324 4 Jun-2019 87338.2681 The initial Level value was calculated taking the average of first 12 periods of data; Trend was calculated by Y3-Y1/2 Seasonality was calculated by dividing the level with the relative period level. A:3 Date Motor Vehicle Sales 12MA CentredMA SeasRelativ e SeasIndex Jan-2010 60480 Feb-2010 65902 Mar-2010 75360 Apr-2010 65223 May-2010 70515 Jun-2010 85417 68950.583 3 Jul-2010 66623 68958.166 7 68954.375 0.9661896 0.9540999 5 Aug-2010 65019 68830.583 3 68894.375 0.9437490 4 0.9806490 2 Sep-2010 68447 68658.416 7 68744.5 0.9956723 8 1.0202916 2 Oct-2010 64616 68108.083 3 68383.25 0.9449097 5 0.9775278 6 Nov-2010 70211 67206.666 7 67657.375 1.0377434 8 1.0222722 6 Dec-2010 69594 66408.583 3 66807.625 1.0417074 4 1.0161211
Image of page 16
Jan-2011 60571 66280.333 3 66344.458 3 0.9129775 3 0.9070548 4 Feb-2011 64371 66739.916 7 66510.125 0.9678376 0.9576399 Mar-2011 73294 66742.5 66741.208 3 1.0981821 1.0741556 7 Apr-2011 58619 67019.166 7 66880.833 3 0.8764693 4 0.8729958 7 May-2011 59698 67076.083 3 67047.625 0.8903820 2 0.9776410 1 Jun-2011 75840 66954.166 7 67015.125 1.1316848 2 1.2299970 9 Jul-2011 65084 67296.416 7 67125.291 7 0.9695898 3 Aug-2011 70534 67721.083 3 67508.75 1.0448127 1 Sep-2011 68478 68156.916 7 67939 1.0079335 9 Oct-2011 67936 68466.75 68311.833 3 0.9944982 7 Nov-2011 70894 69767.833 3 69117.291 7 1.0257057 Dec-2011 68131 70869.166 7 70318.5 0.9688915 4 Jan-2012 64678 71045.416 7 70957.291 7 0.9115060 4 Feb-2012 69467 71236.583 3 71141 0.9764692 7 Mar-2012 78524 71720.833 3 71478.708 3 1.0985649 Apr-2012 62337 72311.833 3 72016.333 3 0.8655953 May-2012 75311 72887.083 3 72599.458 3 1.0373493 4 Jun-2012 89056 73556.666 7 73221.875 1.2162485 6 Jul-2012 67199 73881.833 3 73719.25 0.9115529 5 Aug-2012 72828 73940.583 3 73911.208 3 0.9853444 6 Sep-2012 74289 73881.25 73910.916 7 1.0051153 9 Oct-2012 75028 74288.833 3 74085.041 7 1.0127280 5 Nov-2012 77797 74340.083 3 74314.458 3 1.0468622 4 Dec-2012 76166 74588.25 74464.166 1.0228543
Image of page 17

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
7 9 Jan-2013 68580 74978.833 3 74783.541 7 0.9170467 Feb-2013 70172 75207.75 75093.291 7 0.9344643 Mar-2013 77812 75129.333 3 75168.541 7 1.0351670 8 Apr-2013 67228 74976.75 75053.041 7 0.8957398 5 May-2013 75926 74991.833 3 74984.291 7 1.0125587 4 Jun-2013 92034 74997.083 3 74994.458 3 1.2272106 8 Jul-2013 71886 74906.583 3 74951.833 3 0.9590959 5 Aug-2013 75575 74852.083 3 74879.333 3 1.0092905 Sep-2013 73348 74855.833 3 74853.958 3 0.9798813 8 Oct-2013 73197 74618.25 74737.041 7 0.9793938 6 Nov-2013 77978 74503.5 74560.875 1.04583 Dec-2013 76229 74391.5 74447.5 1.0239296 1 Jan-2014 67494 74423.416 7 74407.458 3 0.9070864 9 Feb-2014 69518 73975.583 3 74199.5 0.9369065 8 Mar-2014 77857 74131.666 7 74053.625 1.0513597 4 Apr-2014 64377 74028.666 7 74080.166 7 0.8690180 2 May-2014 74549 73705.083 3 73866.875 1.0092345 2 Jun-2014 90690 73662.416 7 73683.75 1.2308005 5 Jul-2014 72269 73661.083 3 73661.75 0.9810926 3 Aug-2014 70201 73935.75 73798.416 7 0.9512534 7 Sep-2014 75221 74421.666 7 74178.708 3 1.0140510 9 Oct-2014 71961 74446.833 3 74434.25 0.9667726 9 Nov-2014 74095 74327.916 7 74387.375 0.9960695 6 Dec-2014 75717 74990.583 74659.25 1.0141677
Image of page 18
3 Jan-2015 67478 75143.083 3 75066.833 3 0.8989056 4 Feb-2015 72814 75424.083 3 75283.583 3 0.9671962 6 Mar-2015 83688 76076.666 7 75750.375 1.1047866 1 Apr-2015 64679 76379.916 7 76228.291 7 0.8484907 5 May-2015 73122 76688.333 3 76534.125 0.9554169 5 Jun-2015 98642 77012.833 3 76850.583 3 1.2835556 4 Jul-2015 74099 77080.25 77046.541
Image of page 19

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 20
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern