Purchase Solution

Calculating forecast based on a given trend equation

Not what you're looking for?

Ask Custom Question

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

Attachments
Purchase this Solution
Solution Summary

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

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

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

View More Free Quizzes
Related BrainMass Solutions

  • Calculating forecast based on trend equation

    Sales = 100 - 10*10 + 15 * 10*10 = 1500 This posting contains a question on calculating forecast based on given trend equation.

  • Time series analysis

    d) Prediction Future values of sales can be predicted based on the trend equation Sales = 88741 + 5363*Time. The details are given below.

  • Different Methods for Forecasting Sales

    trend equation, Y = 16.86+0.5*T; a) 5-month moving average; Using the 5-month moving average, the forecast for September 15+20+18+22+20/5 = 19 (in units of thousands) b) Weighted average, where the weights are - 0.60 (August), 0.30 (July)

  • Forecasting Monthly Sales on a Month by Month Basis

    523867 Forecasting Monthly Sales on a Month by Month Basis I am trying to develop a model using Excel (data table perhaps) that can be used to forecast monthly sales on a month-by-month basis based on previous monthly data starting with January of year

  • Predicting forecast based on given trend line equation

    120414 Predicting forecast based on given trend line equation The following time series data represent the yearly amounts spent on advertising (in millions of dollars) by a large toy company: 23.3, 21.7, 22.7, 25.5, 22.7, 25.9 This series of data

  • Forecasting with Linear Trend

    This is a multiple choice question where in you have to develop a trend equation and forecast for the given data and chose the correct answer from the given choices. The attached excel file shows the calculations for this problem.

  • Linear Trendline, Trend Equation and Forecast

    294825 Linear Trendline, Trend Equation and Forecast See data file attached. (a) Plot the data on fruit and vegetable consumption. (b) Discuss the underlying causes that might explain the trend or pattern. (c) Fit a linear trend to the data.

  • Estimate the linear trend equation for the production series

    Based in the trend equation, what is the forecast for the year 2005? (See attached file for full problem description) Please see the attached file.

  • Production & Operations of a Marina

    This method is based on averaging (smoothing) past value of a series in a decreasing manner. The observations are weighted with more weight being given to the more recent observations.

View More Related Solutions