How would you go about collecting the data for each variable (be specific)?

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)?

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your essay today and save 10% with the discount code tCPCOVID10