assignment 5.xlsx - Question 6 Year Total Quarter t 2011 1...

This preview shows page 1 - 6 out of 15 pages.

Question 6 Year Quarter t Sales Seasonal Index Deseasonalized 2011 1 1 4.1 0.9562 4.2878 2 2 6.4 1.0811 5.9199 3 3 6.3 1.0045 6.2718 4 4 6.6 0.9582 6.8879 2012 1 5 5.3 0.9562 5.5428 2 6 6.7 1.0811 6.1974 3 7 4.8 1.0045 4.7785 4 8 4.9 0.9582 5.1138 2013 1 9 5.7 0.9562 5.9611 2 10 5.9 1.0811 5.4574 3 11 6.9 1.0045 6.8691 4 12 5.8 0.9582 6.0530 2014 1 13 5.9 0.9562 6.1703 2 14 5.9 1.0811 5.4574 3 15 4.5 1.0045 4.4798 4 16 4 0.9582 4.1745 Total 16 136 89.7 16 89.6224 2015 1 17 5.276 0.9562 5.0449 2 18 5.2377 1.0811 5.6625 3 19 5.1995 1.0045 5.2229 4 20 5.1612 0.9582 4.9455
Image of page 1

Subscribe to view the full document.

tY t^2 4.2878 1 SUMMARY OUTPUT 11.8398 4 18.8153 9 Regression Statistics 27.5517 16 Multiple R 0.2146784 27.7139 25 R Square 0.0460868 37.1843 36 Adjusted R -0.02205 33.4495 49 Standard Er0.8580109 40.9100 64 Observatio 16 53.6499 81 54.5740 100 ANOVA 75.5600 121 df SS MS 72.6362 144 Regression 1 0.4979451 0.4979451 80.2133 169 Residual 14 10.306559 0.7361828 76.4037 196 Total 15 10.804504 67.1976 225 66.7919 256 Coefficients tandard Erro t Stat 748.7789 1496 Intercept 5.9266904 0.4499447 13.172041 X Variable 1 -0.038269 0.0465322 -0.822428
Image of page 2
F Significance F 0.6763879 0.42462 P-value Lower 95% Upper 95%Lower 95.0%Upper 95.0% 2.803E-09 4.961655 6.8917259 4.961655 6.8917259 0.42462 -0.138071 0.0615322 -0.138071 0.0615322
Image of page 3

Subscribe to view the full document.

Year Month Code Production 12 quarter total 12 quarter ma Central 2013Jan 1 7 Feb 2 5 Mar 3 13 85 21.25 Apr 4 9 0 21.5 87 21.75 0 May 5 6 0 22 89 22.25 0 Jun 6 2 0 22.125 88 22 0 Jul 7 2 0 21.75 86 21.5 0 Aug 8 7 0 21.625 87 21.75 0 Sep 9 14 0 21.875 88 22 0 Oct 10 7 0 22.375 91 22.75 0 Nov 11 8 0 21.875 84 21 0 Dec 12 5 0 19.25 70 17.5 0 2014Jan 13 9 0 16.625 63 15.75 0 Feb 14 7 0 14.75 55 13.75 0 Mar 15 12 0 13.125 50 12.5 0 Apr 16 7 0 11.375 41 10.25 0 May 17 7 0 9.375 34 8.5 0 Jun 18 3 0 4.25 22 0 Jul 19 5 0 15 0
Image of page 4
Aug 20 0 8 Sep 21 5
Image of page 5

Subscribe to view the full document.

Image of page 6
  • Fall '19
  • 1981, 1979, 1975, 1973, 1983, 1946

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

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes