Explore BrainMass

Explore BrainMass

    Linear trend equation

    Not what you're looking for? Search our solutions OR ask your own Custom question.

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

    ACT Networks, Inc. develops, markets, manufactures, and sells integrated wide-area network access products. The following are annual sales data (in millions of dollars) from 2002 to 2007. Based on this data develop a linear trend equation for this time series. What is the firm's average increase in sales per year? Provide a forecast for sales for 2008.

    Year Sales

    (t) (Y) t2 Y2 tY

    1 5.4 1 29.16 5.4

    2 6.2 4 38.44 12.4

    3 12.7 9 161.29 38.1

    4 20.6 16 424.36 82.4

    5 28.4 25 806.56 142.0

    6 44.9 36 2016.01 269.4

    21 118.2 91 3475.82 549.7

    © BrainMass Inc. brainmass.com March 4, 2021, 8:42 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/linear-trend-equation-188112

    Attachments

    Solution Summary

    The forecasting of a time series data using a linear trend line is discussed in the solution.

    $2.49

    ADVERTISEMENT