Purchase Solution

Linear and quadratic trend lines

Not what you're looking for?

Ask Custom Question

From 1997 through 2004, the value of US exports to Mexico was as shown below. Data are in billions of dollars.

Year: 1997 1998 1999 2000
Exports: $71.4 $78.8 $86.9 $111.3

Year: 2001 2002 2003 2004
Exports: $101.3 $97.5 $97.4 $110.8

a. Fit a linear trend equation to the time series. Using this equation, determine the trend estimate for 2012.
b. Fit a quadratic equation to the time series, then use the equation to determine the trend estimate for 2012.
c. Construct a graph of the time series along with the equations fitted in parts (a) and (b). Which equation appears to better fit the data?

Purchase this Solution
Solution Summary

A step by step solution is provided to explain the concept of linear and quadratic trend lines to the time series.

Solution Preview

Solution is attached.

18.8
From 1997 through 2004, the value of U.S. exports to Mexico was as shown below. Data are in billions of dollars.
Year: 1997 1998 1999 2000 2001 202 2003 2004
Exports: $71.4 $78.8 $86.9 $111.3 $101.3 $97.5 $97.4 $110.8
a. Fit a ...

Solution provided by:
Sandhya Sharma, MSc
Education
  • BSc, Meerut University
  • MSc, Meerut University
  • MPhil, Institute of Advanced Studies
  • MSc, AIT
Recent Feedback
  • "Perfect, thank you so much!!! I will definitely request you in the future! You are amazing!"
  • "Thank you. "
  • "Thank you so much I have two more that I need your help with if your available."
  • "Thank you, I was wondering why you rejected me the first time."
  • "Thanks again."
Purchase this Solution
Free BrainMass Quizzes
Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Probability Quiz

Some questions on probability

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

View More Free Quizzes
Related BrainMass Solutions

  • Data forecasting cell phone case study

    Comparing the linear trend equation (a) and quadratic trend equation (b) for the estimate of 2010. The linear trend equation has a value which is increasing and the quadratic equation has a very low value.

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

  • Time Series, Control Charts & Linear and Quadriatic, etc.

    Discuss how you would model no trend, a linear trend and quadratic trend? 5. In general when is it appropriate to use exponential smoothing? Give examples. Interesting and somewhat complex sets of questions, indeed.

  • Excel Problem

    It involves linear trends, quadratic, exponential and auto-regressive.

  • Trend Equations

    a) Linear trend model b) Quadratic trend c) Exponential trend model 5. Using the most appropriate model as selected in 4), forecast the closing value for the DJIA in 2003.

  • Modelling and Drawing Equations from Data

    a) Linear trend model b) Quadratic trend c) Exponential trend model 5. Using the most appropriate model as you selected in 4), forecast the closing value for 2008.

  • Data Analysis on Soft Drink Study

    Help with the following would be appreciated: a) Plot data b) Linear trend line (simple regression) and coefficient significance c) Quadratic trend line (Y=a+bt+ct2) and significance of coefficients d) Estimated exponential trend line .

  • Linear Trend Forecast Analysis

    653185 Linear Trend Forecast Analysis For the time series below a) Develop a linear trend forecast b) Add a quadratic component to the model in part (a) and develop a new forecast c) Now assume a seasonal pattern and add

  • Line Graph, Trends, and Forecasting: Computer Virus Example

    (c) Fit three trends (linear, exponential, quadratic). (d) Which trend model is best, and why? If none is satisfactory, explain. (e) Make a forecast for 2003, using a trend model of your choice or a judgment forecast.

View More Related Solutions