Purchase Solution

Plotting Data, Fitting a Trend Line and Making Predictions

Not what you're looking for?

Ask Custom Question

Please help with the following problem involving correlation and regression analysis.

The following table reports the earning per share (in dollar) for Heban Lumber Mill from 1997 to 2003.

Year 1997 1998 1999 2000 2001 2002 2003
earning per share
1.56 1.86 2.17 2.41 2.67 2.97 3.40

Please provide answers to the following a through d

a. plot the data on a chart
b.estimate the linear trend equation by drawing a line through the data
c. determine the least square trend equation
d. estimate the earning per share for 2004

Attachments
Purchase this Solution
Solution Summary

This solution helps plotting and data fitting a trend line and making predictions. A Complete, Neat and Step-by-step Solution is provided in the attached Excel file.

Solution Preview

Please see the attached Excel spreadsheet for explanation.

Heban lumber mill

The following table reports the earning per share (in dollar) for Heban Lumber Mill from 1997 to 2003.

Year 1997 1998 1999 2000 2001 2002 2003
Earning per ...

Purchase this Solution
Free BrainMass Quizzes
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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Heart Disease and Cancer : Plotting Graphs Using Excel, Trends and Making Predictions

    51228 Heart Disease and Cancer : Plotting Graphs Using Excel, Trends and Making Predictions You have been invited to present statistical information at a conference.

  • Least squares method

    In fact, if the functional relationship between the two quantities being graphed is known to within additive or multiplicative constants, it is common practice to transform the data in such a way that the resulting line is a straight line, say by plotting

  • Advantages of Linear Regression in Complex Situations

    Unlike other forecast techniques, the data fitting in the least square regression line is unbiased and therefore greatly reduces the chances of error.

  • Heart Disease and Cancer : Plotting Graphs, Trends and Making Predictions

    51208 Heart Disease and Cancer : Plotting Graphs, Trends and Making Predictions You have been invited to present statistical information at a conference. To prepare, you must perform the following tasks: 1.

  • Linear long-term trend.

    125118 Linear long-term trend. If a long-term trend is linear, how can regression analysis be adjusted to make business decisions? Regression analysis fits the least squares line to available data.

  • Least Square, Moving Average, or Weighted Moving Average

    The solution determines which method, Least Square, Moving Average, or Weighted Moving Average, is best for plotting the associated trend line.

  • Plotting Data and Forecasting

    186895 Plotting Data and Forecasting 14.16 (a) Plot the data on U.S. general aviation shipments. (b) Describe the pattern and discuss possible causes. (c) Would a fitted trend be helpful? Explain. (d) Make a similar graph for 1992-2003 only.

  • Time Series and Forecasting

    Of the four components of a time series secular trend represents the long-term direction of the series. Study of secular trend models relies heavily on cause and effect relationships between variables in order to ensure predictions.

  • Trend analysis for U. S. General Aviation shipments

    (d) Make a similar graph for 1992-2003 only. Would a fitted trend be helpful in making a prediction for 2004? (e) Fit a trend model of your choice to the 1992-2003 data.

View More Related Solutions