Freight car loadings during an 18-week period at a port are: Week 1 Number 221 242 3 4 276 268 293 312 344 360 405 371 4

[answerhappygod]

Freight Car Loadings During An 18 Week Period At A Port Are Week 1 Number 221 242 3 4 276 268 293 312 344 360 405 371 4 1 (298.21 KiB) Viewed 59 times

Freight car loadings during an 18-week period at a port are: Week 1 Number 221 242 3 4 276 268 293 312 344 360 405 371 428 443 6 7 8 9 10 11 12 13 14 15 16 17 18 wu2BBBB 466 476 495 511 531 541 a. Compute a linear trend line for freight car loadings. (Use of Excel's Trendline, with display Equation on chart option, is 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.) Loadings for week 19 Loadings for week 20 c. The manager intends to install new equipment when the volume reaches 700 loadings per week. Assuming the current trend continues, the loading volume will reach that level in approximately what week? (Round the final answer to the nearest whole week.) Approximate week to reach level