Question
Nilo

Transcribed Image Text:Freight car loadings during an 18-week period at a port are:
Week
1
2
3
4
Y =
6
7
8
9
- 10 11 12 13 14 15 16 17 18
16
Number
221
242
276
268
293
312
344
360
405
371
428
443
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.)
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
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 4 steps with 1 images

Knowledge Booster
Similar questions
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios