Purchase Solution

Linear Trend Model-Regression analysis

Not what you're looking for?

Ask Custom Question

Rubax, a U.S. manufacturer of athletic shoes, estimates the following linear trend model for shoe sales :
Qt = a + bt + c1D1 + c2D2 + c3D3
Where
Qt= sales of athletic shoes in the tth quarter
T = 1,2, â?¦.,28 [2004(I), 2004(II), â?¦., 2010(IV)]
D1 = 1 if t is quarter I (winter); 0 otherwise
D2= 1 if it is t quarter II (spring); 0 otherwise
D3= 1 if t is quarter III (summer) 0 otherwise

The regression analysis produces the following results
Dependent Variable QT R-Square F-Ratio P-Value on F
Observations 28 0.9651 159.01 0.0001
Variable Parameter Estimate Standard Error T-Ratio P-Value
Intercept 184500 10310 17.9 0.0001
T 2100 340 6.18 0.0001
D1 3280 1510 2.17 0.0404
D2 6250 2220 2.82 0.0098
D3 7010 1580 4.44 0.0002

a) is there sufficient statistical evidence of an upward trend in shoe sales?
b) Do these data indicate a statistically significant seasonal pattern of sales of Rubax shoes? If so, what is the seasonal pattern exhibited by the data?
c) Using the estimated forecast equation, forecast sales of Rubax shoes for 2011 (III) and 2012 (II).
d) how might you improve this forecast equation?

Attachments
Purchase this Solution
Solution Summary

A Complete, Neat and Step-by-step Solution is provided in the attached file.

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

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

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.

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

  • Regression Analysis And Curve Fitting

    Interpretation of the trend may show that a linear relationship exists, so the best fit is done based upon a linear equation to model the trend.

  • Examples of regression analysis

    293943 Statistics: Example of regression analysis in your work. Give the model Once we start to think about it, regression is useful in many different situations. Give an example of how you might use regression analysis in your work.

  • Forecasting the Demand - Moving Average and Trend Analysis

    So we have to find X6 (see attachment for calculations) Trend Analysis using Linear Regression In Linear Regression method we first estimate the coefficients ‘a’ and ‘b’ in the linear model Xt = a + b*t using the principle of least squares.

  • Types of Trends

    This would be an example of an upward secular trend. A linear trend is a simple way of predicting future values of a variable. You use a regression analysis to fit a straight line to the data.

  • Regression analysis

    Compute the correlation coefficient for the linear trend line forecast and explain its meaning. Please see the attachments. Step by step method for regression analysis is discussed here.

  • Case Study: Linear Regression Model

    Excel file contains solution of Linear Regression Model.

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

  • 4 basic assumption of multiple regression analysis

    419073 4 basic assumption of multiple regression analysis The appropriate use of multiple regression depends on being able to make four basic assumptions about the data being used to develop the regression model: that variables are normally distributed

  • Statistics - Regression

    A fitted trend would not be very helpful because the data seems to be far from showing a linear trend.

  • Forecasting population growth with regression analysis.

    We can fit a linear trend line to the data and run a regression analysis. See attached file. As we can see the regression line fits the data quite well with an R^2 close to 1.0.

View More Related Solutions