Solved

The Total Number of Overtime Hours (In 1000s) Worked in a Large

Question 12

Essay

The total number of overtime hours (in 1000s) worked in a large steel mill was recorded for 16 quarters, as shown below.  Year  Quarter  Overtime hours 2013120230328420201412423432842112820152383314261302016241335428\begin{array} { | c | c | c | } \hline \text { Year } & \text { Quarter } & \text { Overtime hours } \\\hline 2013 & 1 & 20 \\& 2 & 30 \\& 3 & 28 \\& 4 & 20 \\2014 & 1 & 24 \\& 2 & 34 \\& 3 & 28 \\& 4 & 21 \\& 1 & 28 \\2015 & 2 & 38 \\& 3 & 31 \\& 4 & 26 \\& 1 & 30 \\2016 & 2 & 41 \\& 3 & 35 \\& 4 & 28 \\\hline\end{array} a. Use the regression technique to calculate the linear trend line.
b. Calculate the seasonal indexes based on the regression trend line in part (a).
c. What do the seasonal indexes tell us?

Correct Answer:

verifed

Verified

a. ŷt = 23.2 + 0.668t.
b. Use Excel to c...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions