Regression Analysis: Scatterplot, Sales Price Drivers
Not what you're looking for?
Regression Project
Answer the following questions (each question should be a separate worksheet tab labeled as q1, q2, etc.) (point values for each component are noted):
1. (12) For each of the six potential sales price drivers (sq footage, baths, bedrooms, year built, car garage size, and fenced (yes=1, no = 0)) do each of the following:
a. Prepare a scatter plot. The y axes should be sales price, and the x axes will be one of the potential drivers.
i. Please title each axis so I know which sales price driver is being included in the chart.
ii. Include a trend line for each plot along with the equation and R2.
iii. Please make separate charts for each driver (no more than 2 per tab -charts1, charts2, etc.).
iv. Be sure to properly label the tabs so that I can find the charts in your Excel file.
2. (12) Using the regression feature within data analysis, find the:
i. slope,
ii. R2, and
iii. intercept for each sales price driver.
3. (10) Based solely on the scatterplot appearance, without reference to the numbers you developed with the regression analysis, comment on the appropriateness of each potential sales price driver.
4. (10) Based on the scatterplots, the regression information, and the information in the background materials, choose the best sales price driver. Explain your choice, including a discussion of why other sales price drivers were not chosen.
5. (10) What is the regression equation that you found for the best sales price driver?
6. (10) Explain what this "best" regression equation tells you (specifically).
7. (10) What is the "best" multiple regression equation for sales price? You might have to create several equations with a combination of variables to find this equation (or, there might not be any useful sales price drivers from this dataset).
8. (8) Assume that the following is the best multiple regression equation (it isn't!).
Estimated sales price = 41,005 +123.55(sq ft) +2,974(baths) + 957.65(fenced)
Using the following information, what is the expected sales price:
House features:
Square feet = 1950
Baths = 1.5
Bedrooms = 3
Garage = 2
Fenced = no
Year built = 1960
9. (8) Assume that a good estimator for sales price is garage size. The equation for this sales price driver is:
Estimated sales price = 241,926.70 + 28,016.98(garage)
Based on this equation, the residual for the first home ($388,000) is $146,073. Explain what this means?
10. (10) List three other variables that you might suggest for predicting sales price of a home. How would you go about collecting the data for each variable (be specific)?
Purchase this Solution
Solution Summary
I created graphs, tables, commentary and computations to assist you in completing your assignment. These are on the different tabs (see labels) to find each question.
Education
- BSc, University of Virginia
- MSc, University of Virginia
- PhD, Georgia State University
Recent Feedback
- "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
- "Thank, this is more clear to me now."
- "Awesome job! "
- "ty"
- "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)