Purchase Solution

find the best prediction model

Not what you're looking for?

Ask Custom Question

Resource: Ch. 12-14 of Applied Statistics in Business and Economics
Prepare answers to the following assignments:
Exercise 14.6 - Time Series Analysis
Given the following data on Asian and European Share of U.S. Light Truck Sales(1990-2003):
Year t Percent
1990 1 16.4
1991 2 17.1
1992 3 14.3
1993 4 13.7
1994 5 14.2
1995 6 13.6
1996 7 13.6
1997 8 15.4
1998 9 16.2
1999 10 18.4
2000 11 21.2
2001 12 23.1
2002 13 23.9
2003 14 26.6
Source: Detroit Free Press, November 19, 2003. p.1A.

(a) Plot the market-share data. [Enter the data in Excel, highlight 'percent' column, click Insert menu, choose Line chart, select Line with Markers]
(b) Describe the trend (if any) and discuss possible causes.
(c) Fit three trends (linear, exponential, quadratic/polynomial). [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? If none is satisfactory, explain.
(e) Make a forecast for 2004 by using a trend model of your choice or a judgment forecast.

Purchase this Solution
Solution Summary

The solution provides detailed explanation how to find out the best prediction model.

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.

Measures of Central Tendency

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

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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

  • Logistic Regression Model

    Find the log-likelihood of the data using the probabilities from your predictions. c. What is the null model prediction? (single prediction for all cases using no predictors) d. What is the likelihood of the data using the null model.

  • Regression analysis

    The variables will be weights of cars (x) and the corresponding braking distances (y). 2. Using the prediction procedure, find the best predicted braking distance for a car that weighs 4000 lbs.

  • Quality and Reliability

    Graves et al. proposed their best model, the weighted time damp model, to predict fault potential by using a sum of contributions from all the changes to the model in its history.

  • 95% Prediction Interval : Regression analysis

    degrees C) when the CO2 concentration is 370.9 parts per million b) Find a 99% prediction interval estimate of the temperature (in degrees C) when the CO2 concentration is 370.9 parts per million.

  • Multivariance analysis question

    Two verities of oranges, Valencia and Navel, in large and small sizes are to be used in the evaluation, The company wants to find the best prediction model relating the mean yield E(y) too the type of orange juice extractor (A or B),.

  • Statistics - Regression Model - Find a Point Prediction

    283200 Statistics Regression Model: find a point prediction for state, police, population, prisoners See attached file. The given describes data for each state of the 50 states.

  • Mathematical Modeling

    The modelling process will find a "best" value for a,b (Note: there are different interpretations for the "best", which may result in different value for a,b). To predict future value, we simply put in future x into this model to get a value for y.

  • Linear Regression and Correlation Analysis

    There are many data points to the left of the graph, so we can find a more accurate prediction.

  • Introduction to Linear Regression and Correlation Analysis.

    There are many data points to the left of the graph, so we can find a more accurate prediction.

View More Related Solutions