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
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