Purchase Solution

Linear Trendline, Trend Equation and Forecast

Not what you're looking for?

Ask Custom Question

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.
(d) Interpret the trend equation. What are its implications for producers?
(e) Make a forecast for 2005.
Note: Time increments are 5 years, so use t = 6 for your 2005 forecast.

U.S. Per Capita Consumption of Commercially Produced Fruits and Vegetables (pounds)
year total
1980 608.0
1985 629.3
1990 659.2
1995 690.0
2000 705.4

Attachments
Purchase this Solution
Solution Summary

This solution discusses linear trendlines, trend equations and forecasts.

Solution Preview

d) The trend equation is given as y=5.11(x)-9510.5, where x represents the year.

e) For the ...

Solution provided by:
Anwesha Ghosh, MSc
Education
  • MSc, Osmania University
  • MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
  • BSc, Banaras Hindu University
Recent Feedback
  • "Very fast turnaround. Excellent communication! Much appreciated!"
  • "excellent"
  • "excellent"
  • "excellent work"
  • "Fantastic..great solution and very well explained!!!!"
Purchase this Solution
Free BrainMass Quizzes
Probability Quiz

Some questions on probability

Exponential Expressions

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

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Multiplying Complex Numbers

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

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

View More Free Quizzes
Related BrainMass Solutions

  • Chart the decay rate of tennis players in a tournament

    [Right click on the chart, select add trendline. Choose from the non-linear trends listed on the top. At the bottom, check the box - add equation on the trendline. Clic ok]. (d) Which trend model is best, and why?

  • find the best prediction model

    [Right click the line chart/line marker, select 'add trendline', default is linear. Check the box 'Display equation on chart'. Repeat the process for other trends after selecting each trend]. (d) Which trend model is best, and why?

  • Quantitative Methods : Linear Trends, Regression and Forecasting

    Does a linear trend appear? B. Develop the equation for the linear trend component for the time series. What is the average cost increase per year? (see attached file label "costperunit.doc") 2.

  • Linear Regression in Excel

    by a non-linear trend (it looks more exponential than linear to me in the graph)

  • Seasonally Adjusted Forecast

    313623 Seasonally Adjusted Forecast From the given data develop a seasonally adjusted forecast for 2006. (Use a linear trend line model to develop a forecast estimate for 2006.)

  • Advantages of Linear Regression in Complex Situations

    Even for complex situations, linear regression provides a single trendline or slope irrespective of the nature of the data, therefore making it easier to estimate the trend associated with the data.

  • Forecasting

    Develop a linear trend line to forecast next year's applicants and percentage of acceptances and use these results to estimate the percentage of offers that Tech should expect to make.

  • XYZ Advertising: Linear Regression Problem

    Choose "add trendline." If they are intended to be linear (which I assume they are supposed to be), then choose "linear" as the Trend/Regression type. I've done this for the first graph. You can do it for the other two. It's kind of fun.

  • Trend Line - Average Annual Hours of Work, Married Couple with Children

    Modifications: In Exercise 14.4 do items (a) for years 1990 through 1995, (b), then change item (c.) to fit only a linear trend, and do the following changes: (d) plot the trendline with the equation added using the options button, (e) predict 1998 and

View More Related Solutions