Purchase Solution

Linear Regression and Forecast

Not what you're looking for?

Ask Custom Question

Carpet City wants to develop a means to forecast its carpet sales. The store manager believes that the store's sales are directly related to the number of new housing starts in town. The manager has gahtered data from county records on monthly housing construction permits and from store records on monthly sales. These data are as follows:

Monthly carpet Sales(1000yds) Monthly Construction permits

5 21
10 35
4 10
3 12
8 16
2 9
12 41
11 15
9 18
14 26

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

b. Determine the strength of the causal relationship between monthly sales and new home construction by using correlation.

Purchase this Solution
Solution Preview

See attached file.

a) The Regression Equation is given as:

y = 0.268x + 2.360

where x represents 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
Measures of Central Tendency

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

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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Reid Sanders Case Study: Linear Regression Analysis

    It provides a linear regression line, computes a correlation coefficient, determines the strength of the linear relationship, and develops a forecast of retail sales. The solution is provided in Excel.

  • Mean Absolute Deviation

    Main Analysis and results can be found on the sheet "Main Analysis". The result for linear regression can be found on the sheet "Linear Regression Model". All results are obtained by Excel.

  • Price Club

    The linear regression result can be found on sheet "Linear Regression Table". Hope it helps. Question: Find the forecast of the quarterly earnings per share for Price Club for each quarter by using the naà¯ve approach.

  • Forecasting techniques -regression moving average

    Short-term staffing needs might best be forecast with moving average or exponential smoothing models while long-term factory capacity needs might best be predicted with regression " Performs a linear regression, 8 month moving average & 3 month moving

  • ABC Furniture Company Linear Regression

    The Forecast Sales column is comprised of values computed using the linear regression equation and projected number of customers in Year 2.

  • Chasewood Apartments, Independent, Dependent Variables, Linear Regression, Relationship, Forecast.

    What is the linear regression relationship the manager should use and what is the forecast for the Number of Units Leased for Semester 9 if the forecast for the Average Lease Price is $460 for Semester 9?

  • Advantages of Linear Regression in Complex Situations

    330240 Advantages of Linear Regression in Complex Situations How does a linear regression allow us to better estimate trends, costs, and other factors in complex situations? Linear regression estimates the line of best fit for any given data.

  • Simple Exponential Smoothing

    ANALYSIS Recall that in Linear Regression, the data provided by the client was used to compute the slope and y-intercept of the Linear Regression equation. The linear regression equation was in turn used to forecast sales for Year 2.

  • Casual Method of Linear Regression

    185055 Casual Method-Linear Regression 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?

  • Small questions on Forecasting

    Prepare a linear regression and exponential smoothing forecast (with alpha = 0.2) for the data (assume that the initial forecast is equal to the average of all demand data).

View More Related Solutions