Question: a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) b. Use the
a. Determine a linear trend line for expected freight car loadings.(Round your intermediate calculations and final answers to 2 decimal places.)
b. Use the above trend equation to predict expected loadings for Weeks 20 & 21.
Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 360 7 430 13 505 375 8 450 14 515 390 9 470 15 545 375 10 455 16 560 5 390 11 475 17 575 400 12 495 18 590 Click here for the Excel Data File a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) Y b. Use the above trend equation to predict expected loadings for Weeks 20 & 21. (Round your final answers to 2 decimal places.) The forecasted demand for Week 20 is and for Week 21 is
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
