4 00:14:12 Freight car loadings during an 18-week period at a port are: Week 1 2 3 4 5 6 7 8 9 Y = 10 11 12 13. 14 15 16 17 18 Number 223 239 280 263 291 316 346 369 398 381 428 441 462 478 505 511 529 548 a. Compute a linear trend line for freight car loadings. (Use of Excel's Trendline, with display Equation on chart option recommended). (Round the final answers to 3 decimal places.) mx X + b b. Use the trend equation to predict loadings for weeks 19 and 20. (Round the final answers to 2 decimal places.) Loadings for week 19 Loadings for week 20 c. The manager intends to install new equipment when the volume reaches 690 loadings per week. Assuming the cu continues, the loading volume will reach that level in approximately what week? (Round the final answer to the near. Approximate week to reach level

Freight car loadings during an 18 -week period at a port are: a. Compute a linear trend line for freight car loadings. (Use of Excel's Trendline, with display Equation on chart optio recommended). (Round the final answers to 3 decimal places.) Y= x+ b. Use the trend equation to predict loadings for weeks 19 and 20 . (Round the final answers to 2 decimal places.) c. The manager intends to install new equipment when the volume reaches 690 loadings per week. Assuming the c continues, the loading volume will reach that level in approximately what week? (Round the final answer to the near Approximate week to reach level