Explore BrainMass
Share

Explore BrainMass

    Linear trend estimation

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Please help to build a spreadsheet to figure out the following:

    Freight car loadings over an 18-week period at a busy port are:

    Week Number
    1 220
    2 245
    3 293
    4 275
    5 332
    6 310
    7 350
    8 360
    9 427
    10 380
    11 432
    12 450
    13 477
    14 475
    15 538
    16 510
    17 532
    18 541

    a) Compute a linear trend line for freight car loadings:
    Y=___+___t.

    b) Use the trend equation to predict loadings for weeks 25 and 26:
    The forecasted demand for week 25 and 26 is ____ and ____ respectively.

    c) The manager intends to install new equipment when the volume reaches 829 loadings per week. Assuming the current trend continues, the loading volume will reach that level in approximately what week?
    It would take approximately _15_ more weeks.

    © BrainMass Inc. brainmass.com October 10, 2019, 7:10 am ad1c9bdddf
    https://brainmass.com/business/managerial-statistics/linear-trend-estimation-570326

    Solution Summary

    This posting carries a linear trend estimation problem and the solution outlines the two methods of estimating a linear trend (see attachment).

    $2.19