Regression analysis
Not what you're looking for?
This is a forecasting and regression analysis problem that requires the regression analysis to be done to find the slope and intercept. Also adjust the chart to show the Y variables in excel 2007. Please explain that also.
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 gathered data from county records on the monthly house construction permits and from store records on the monthly sales.
a. Develop a linear regression model for these data and forecast carpet sales if 30 constructive permits for new homes are filed.
b. Determine the strength of the causal relationship between monthly sales and new home construction by using correlation.
The data are given in the attachment.
Purchase this Solution
Solution Summary
The solution provides step by step method for the calculation of regression analysis. Formula for the calculation and Interpretations of the results are also included.
Purchase this Solution
Free BrainMass Quizzes
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts