Question: Freight car loading during an 1 8 week period at a port are Week. Number 1 . 2 3 0 2 . 2 4 0

Freight car loading during an 18 week period at a port are Week. Number1.2302.2403.2904.2665.3056.3157.3468.3659.40010.37811.41812.44613.46814.47715.49916.51717.53518.541A) computer a linear trend line gor frieght car loading .( use of excel trendline . With display equation on chart option , is recommended( round the final answer to 3 decimal places) Y=_______*+_________B) use the trend equation to predict loading for weeks 19 and 20( round the final answer to 2 decimal places)Loading for week 19_________Loading for week 20________C) The managwr intends to install new equipment when the volume reaches 790 loading per week . Assuming the current trend continues, the loading volume will reach that level in approximately what week? ( round the final answer to nearest whole week) Appriximate week to reach level ____

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!