Help

Save & Exit

$\backslash$table$[[$Week$,$Number$],[1,280],[2,295],[3,310],[4,295],[5,310],[6,320],[7,350],[8,400],[9,450],[10,435],[11,485],[12,535],[13,545],[14,555],[15,585],[16,600],[17,615],[18,630]]$

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$(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 $q,$ and for Week $21$ is $$

c$.$ The manager intends to install new equipment when the volume exceeds $860$ 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 $860$ loadings in Week

Help

Save & Exit

$\backslash$table$[[$Week$,$Number$],[1,280],[2,295],[3,310],[4,295],[5,310],[6,320],[7,350],[8,400],[9,450],[10,435],[11,485],[12,535],[13,545],[14,555],[15,585],[16,600],[17,615],[18,630]]$

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$(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 $q,$ and for Week $21$ is $$

c$.$ The manager intends to install new equipment when the volume exceeds $860$ 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 $860$ loadings in Week