Purchase Solution

Statistics - Develop a Linear Regression Model

Not what you're looking for?

Ask Custom Question

Carpet City wants to develops a means to forecast it carpet sale. The store manager believes that the store's sale are directly related to the number of new housing starts in town. The manager has gathered data from county records on monthly house construction permits and from store records on monthly sales.

Monthly Carpet Sales 1,0000 yd Monthly Construction Permit
5 21
10 35
4 10
3 12
8 16
2 9
12 41
11 15
9 18
14 26

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

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

Purchase this Solution
Solution Summary

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

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

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.

View More Free Quizzes
Related BrainMass Solutions

  • Linear Regression using intrinsic job satisfaction

    46865 Linear Regression Linear Regression Help.. Using the attached excel spreadsheet (database) Develop a Linear Regression model using intrinsic job satisfaction and extrinsic job satisfaction.

  • Multiple regression model testing

    I need to provide output of the regression procedure but also the model equation. Also, I need to develop a linear regression model using intrinsic job satisfaction and extrinsic job satisfaction.

  • Statistics Problem: Multiple Regression Model

    35948 Statistics Problem: Multiple Regression Model a) Develop a Multiple Regression model with the dependent variable being the Overall Job Satisfaction. Use gender, age, department, position and tenure with company as the independent variables.

  • Regression model using MATLAB

    Develop a linear regression model to predict the prize winnings ($1000s) using the 11 other variables. Then, select a subset of these variables and develop a competing model. Use the correlation coefficients to explain why this representation works.

  • Simple and Multiple Regression

    Develop simple linear regression models for predicting sales as a function of the number of each type of ad. Compare these results to a multiple linear regression model using both independent variables.

  • Statistics Problem Set: Multiple Regression Model

    507462 Statistics Problem Set: Multiple Regression Model 14.2 Develop a multiple regression model of the form y = b0 + b^x1E. Using the following data to predict y from x.

  • Business Statistics and Multiple Regression

    40618 Business Statistics and Multiple Regression Using the database (attached file), complete the followings: a) Develop a Multiple Regression model with the dependent variable being the Overall Job Satisfaction.

  • Regression Analysis - Using PHStat or Excel

    613800 Regression Analysis - Using PHStat or Excel [1] A research analyst for an oil company wants to develop a model to predict miles per gallon based on highway speed.

  • Regression analysis on Unemployment Duration

    For present purposes, consider a linear regression model, that is, a linear regression of WEEKS on different socio-economic characteristics described above.

  • Regression Analysis and Predicting Heating Area Assessment

    If you were to use regression analysis to develop a model that can be used to determine the price a customer would be willing to pay for that good or service, what independent variables would you include in the model?

View More Related Solutions