Explore BrainMass
Share

# 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

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