Purchase Solution

Casual Method of Linear Regression

Not what you're looking for?

Ask Custom Question

I used the formula Y =a+bX but

1.Regarding the causal method of linear regression:
a.What is the appropriate linear regression model (equation) to forecast sales?

Use Excel and the LINEST function to create it.

b.Use the equation to generate your forecasts for months 16-19. NOTE: There is NO missing information.

c.What can you say about the relationship between the variables?

Attachments
Purchase this Solution
Solution Summary

Casual Method-Linear Regression is given with the formula of Y=a+bX. The forecast sales are determined using this regression model.

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

  • Correlation and Regression

    Determine the strength of the casual relationship between monthly sales and new home construction by using correlation. Please see the attached file: Develops a linear regression for the data given and forecasts carpet sales.

  • What would the correlation coefficient, r, be

    44746 Linear regression model: The results of a casual linear regression model were Y = 0 + 1.95 X. What would the correlation coefficient, r, be? The results of a casual linear regression model were Y = 0 + 1.95 X.

  • Quantitative Forecasting Explained

    that use regression methods), Box-Jenkins method (the use of autocorrelation methods).

  • Quantitative Reasoning Example Problem

    http://www.cals.ncsu.edu/gn/ex/samphist.html Linear regression measures how two (or more if done several times) variables correlate. How close is the relationship of the variables in a linear line?

  • Statistics - Develop a Linear Regression Model

    Determine the strength of the casual relationship between monthly sales and new home construction by using correlation. The solution file is attached. I have used excel to get the regression parameters.

  • Why is the trend commonly thought to be the most important c

    How is the linear trend method related to linear regression? The linear trend method is related to linear regression because forecasting itself is linear regression with time as the predictor variable.

  • Forecasting on Sales

    Develop a linear regression model for these data and forecast carpet sales if 30 construction permits for new homes are filed. b.

  • Theory, analysis and interpretation of regression

    How do they impact your regression equation? Linear Algebra describes a very powerful method of solving linear equations by matrix method.

  • Simple Regressions and Multiple Regressions

    What is simple linear regression? The simple linear regression is a method to determine the relationship between one dependent variable and one independent variable. How is regression used to create equations and to make predictions?

View More Related Solutions