The owner of anderson belts inc., is studing absenteeism among his employees. Hi

Question

The owner of anderson belts inc., is studing absenteeism among his employees. His workforce is ssmall, consisting of only 5 employees. For the last 3 years, 2014 through 2016, he recorded the following number of employee absences, in days, for each quarter.

4

Answer info for

The seasonal index is

0.4732

Determine the linear trend equation based on the deseasonalized quarterly data for the three years. (round answer to 4 decimal places)

y = _____ + _____t

Year Q1 Q2 Q3 Q4 2014 4 10 7 3 2015 5 12 9 4 2016 6 16 12

4

Explanation / Answer

Solution:

We take x = 1, 2, ... and so on and y = Desentasize column

Using excel, <DATA < DATA ANALYSIS < REGRESSION

The linear trend equation is

Y = 5.1742 + 0.3787t  

SUMMARY OUTPUT Regression Statistics Multiple R 0.924502 R Square 0.854705 Adjusted R Square 0.840175 Standard Error 0.590411 Observations 12 ANOVA df SS MS F Significance F Regression 1 20.50566 20.50566 58.82534 1.7E-05 Residual 10 3.485855 0.348585 Total 11 23.99151 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 5.17415 0.363373 14.23922 5.76E-08 4.364504 5.983796 X Variable 1 0.378677 0.049373 7.669768 1.7E-05 0.268668 0.488686

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.