Explore BrainMass
Share

Explore BrainMass

    Calculating forecast based on a given trend equation

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

    The manager of a company believed that her company's profits were following an exponential trend. She used Microsoft Excel to obtain a prediction equation for the logarithm (base 10) of profits:

    Log10(Profits) = 2=0.3X

    The data she used were from 1993 through 1998, coded 0 to 5. The forecast for 1999 profits is ________.

    A. 6.309
    B. 3,800
    C. 5,798
    D. Cannot be determined form the information given

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

    Attachments

    Solution Preview

    Please see the attached file.

    The manager of a company believed that her company's profits were following an exponential trend. She used ...

    Solution Summary

    This posting contains calculation of forecast for a period based on given trend equation.

    $2.19