7. Below is a table of the house price. It seems that there may have some errors

Question

7. Below is a table of the house price. It seems that there may have some errors in the table of data. List all the errors you can find Price of of floorshome $1000 Zip codeLatitude Size NumberNumberAge of (feet2) Bedrooms 14227 12314 14270 1234 14r43 14228 10862 1121 33.14 32.64 3341 41.10 50 2000 1431 1029 1h90 011 122 2187 1231 470 320 120 270 432 653 138 546 0 80 50 100 65.14 40.00 15 54 43 Create new flag variable(s) for the above table of the house price to describe the price of the house as Low, Median, High. Show the variable(s) you created and the criteria. 8.

Explanation / Answer

7. Errors

In 3rd row the age of house is -1 which is not possible

in 4th row area is 1h90 which is not a valid value for area and zip code is of 4 digit(it should be of 5 digits)

in 5th row zip code in valid

in 8th row zip is not valid as well as no of bedrooms

8.

priceDistnew flag variable

it give low if price is less than 200

it give Medianm if price is between 200 to 500

it gives high if it is above 500

row number    PriceDist

1                  Median

2                  Median

3                  Low

4                  Median

5                 Median

6                 High

7                 Low

8                 High

Related Questions

Navigate

• Browse (All)
• Browse 7
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.