Purchase Solution

Excel Solver for Trend Equation to Forecast

Not what you're looking for?

Ask Custom Question

Using data below answer questions:

a) Construct time series plot. What pattern exists?
b) Use Excel Solver to make quadratic trend equation to forecast team value.
c) Use Excel Solver to make exponential trend equation to forecast team value.
d) Use Excel Solver to make linear trend equation to forecast team value.

Year Period $ Value
1998 1 227
1999 2 305
2000 3 332
2001 4 367
2002 5 419
2003 6 547
2004 7 609
2005 8 715
2006 9 837
2007 10 911
2008 11 1076

Purchase this Solution
Solution Summary

This solution contains step-by-step calculations to construct time series plot, and uses Excel Solver to solve equations and forecast team value in an Excel file.

Solution provided by:
Gaurav Agarwal, MS
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

View More Free Quizzes
Related BrainMass Solutions

  • Excel 2003 Multiple Choice

    Which of the following functions uses a linear (straight-line) trend equation to predict future values based on existing or historical results? a. FORECAST b. GROWTH c. RSQ d. TREND e. LINEAR Save Answer 10.

  • Forecasting - Management Science

    43468 Quantitative Decison Making for business - Forecasting - Management Science Hi this is a forecasting problem that can be solved using Excel with the solver-add in on it. Please answer all parts to the question .

  • Calculating forecast based on trend equation

    90094 Calculating forecast based on trend equation 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.

  • Calculating forecast based on a given trend equation

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

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

  • Forecasting Corporate Triple A Bond

    Does a linear trend appear? b. Develop the equation for the linear trend component for the time series. c. Use the linear trend developed in part (b) to prepare a forecast for sales in year 8. Please help in excel format.

  • Prediction with linear and quadratic regression line

    Construct a scatter diagram between year (year 1985 is equivalent to x =1) and shipments. Add a linear trend line and a fitted equation to the chart. b.)

  • Forecasting Monthly Sales on a Month by Month Basis

    The result is the monthly forecast for each month for year 7, using both trend projection and the seasonal method.

  • Seasonal Index

    a. 1 b. 2 c. 3 d. 4 a. 1 [Please refer to the EXCEL attachment for calculations]. This solution is comprised of detailed analysis and step-by-step calculations of Seasonal Forecast Indexes in EXCEL.

View More Related Solutions