Explore BrainMass
Share

Explore BrainMass

    Calculating forecast based on trend equation

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

    Excel was used to obtain the following quadratic trend equation:

    Sales = 100 - 10X + 15X2

    The data used was form 1989 through 1998, coded 0 to 9. The forecast for 199 is_________

    A. 1,225
    B. 980
    C. 1,500
    D. 1,600

    © BrainMass Inc. brainmass.com October 9, 2019, 6:30 pm ad1c9bdddf
    https://brainmass.com/statistics/multivariate-time-series-and-survival-analysis/calculating-forecast-based-trend-equation-90094

    Attachments

    Solution Preview

    Please see the attached file.

    Excel was used to obtain the following quadratic trend ...

    Solution Summary

    This posting contains a question on calculating forecast based on given trend equation.

    $2.19