Problem: The setting: Imagine you are a real estate investor presented with a regression analysis of home sales in the neighborhood of one of your investment properties. Unfortunately, the report stops short of making the decision for you. Given the data as presented in those three worksheets,
you need to use the StatTools regression module to determine:

• Which is the better predictor of selling price: appraised value, square footage, or number of bedrooms?
• How much value is added per $1,000 of appraised value?
• How much value is added per 100 square feet?
• How much value is added per bedroom?
• At what price should you offer your investment home, based only on an appraised value of $135,200?

Second Stat Assignment is:

In the Data Analysis & Decision Making with Microsoft® Excel textbook, review the answer provided here for the following Chapter 13 problem:

• Problem 36 (A and B), page 752.

The problem was - How well does the moving average method track this series when the span is 4 day; whenthe span is 12 days? Using the more appropriate span, forecast the closing value of this index on the next trading day with the moving average method. (The second assignment template is the solutions to this problem.)

Then use the StatTools solution provided to answer the following two questions:

• Which is the better predictor – the Four Day Span or the Twelve Day Span?
• Justify your reason for selecting a Four Day or Twelve Day Span.

Instructions

1. It is important that you use the Excel template provided with this assignment to answer this problem.

Price: $8.12

Solution: The downloadable solution consists of 4 pages, 412 words and 2 charts.
Deliverable: Word Document