Problem $3-7($Algo$)$

Freight car loadings over an $18-$week period at a busy port are as follows:

Click here for the Excel Data File

a$.$ Determine a linear trend line for expected freight car loadings.

Note: Round your intermediate calculations and final answers to $2$ decimal places.

hat$()=$

a$.$ Determine a linear trend line for expected freight car loadings.

Note: Round your intermediate calculations and final answers to $2$ decimal places.

hat$(Y)=$

b$.$ Use the above trend equation to predict expected loadings for Weeks $20$ & $21.$

Note: Round your final answers to $2$ decimal places.

The forecasted demand for Week $20$ is

and for Week $21$ is

c$.$ The manager intends to install new equipment when the volume exceeds $960$ loadings per week. Assuming the current trend

continues, in which week $($at the earliest$)$ should the loading volume reach that level?

Note: Use the rounded answers, as required, from any previous part of this problem. Do not round any other intermediate

calculations. Round your final answer to $2$ decimal places.

It should reach $960$ loadings in Week

Freight car loadings over an $18-$week period at a busy port are as follows:

a$.$ Determine a linear trend line for expected freight car loadings.

Note: Round your intermediate calculations and final answers to $2$

decimal places.

hat$(y)=$

b$.$ use the above trend equation to predict expected loadings for week $20$&$21$

c$.$ the manager intends to install new equipment when the volume exceeds $960$ loadings per week. Assuming the current trend continues, in which week $($at the earliest$)$ should the loading volume reach that level?