Develop a decision tree model to predict the sale price of a house by using predictor variables, such as number of bedrooms, number of bathrooms, home square footage, lot square footage, and age of the house As real estate values can differ dramatically from region to region, you may want to develop a model for several campuses in the data file and compare the resulting decision trees Record Sale amount Sale date Beds Baths Sqft home Sqft lot Type Build year Town University 1 295000 5 31 2016 5 3 2020 38332 8 Single Family 1976 Ames, IA Iowa State University 2 240000 6 20 2016 4 2 1498 54014 4 Single Family 2002 Ames, IA Iowa State University 3 385000 5 31 2016 5 4 4000 85813 2 Single Family 2001 Ames, IA Iowa State University 4 268000 4 12 2016 3 2 5 2283 118918 8 Single Family 1972 Ames, IA Iowa State University 5 186000 4 5 2016 3 1 25 1527 15681 6 Single Family 1975 Ames, IA Iowa State University 6 302500 3 2 2016 4 3 3117 33105 6 Single Family 1976 Ames, IA Iowa State University 7 223000 6 2 2016 3 2 1218 25264 8 Single Family 1975 Ames, IA Iowa State University 8 225000 5 7 2016 3 3 3000 30056 4 Single Family 1969 Ames, IA Iowa State University 9 215000 4 14 2016 5 2 2963 14374 8 Single Family 1965 Ames, IA Iowa State University 10 285100 2 12 2016 3 4 1680 48351 6 Single Family 1987 Ames, IA Iowa State University 11 269000 6 1 2016 3 2 1682 43560 Single Family 1932 Ames, IA Iowa State University 12 650000 6 2 2016 4 3 5 2535 82764 Single Family 1998 Ames, IA Iowa State University 13 203500 4 18 2016 4 2 1277 10628 Single Family 1970 Ames, IA Iowa State University 14 265000 6 28 2016 4 2 5 1340 10290 Single Family 1998 Ames, IA Iowa State University 15 180000 2 24 2016 3 3 5 1709 13068 Single Family 1991 Ames, IA Iowa State University 16 192000 2 29 2016 3 3 1470 8139 Single Family 1995 Ames, IA Iowa State University 17 246500 3 23 2016 4 3 5 1776 8712 Single Family 1996 Ames, IA Iowa State University 18 258000 6 14 2016 4 2 5 1752 9174 Single Family 1996 Ames, IA Iowa State University 19 240500 3 17 2016 3 2 25 1502 6821 Single Family 1985 Ames, IA Iowa State University 20 218000 7 1 2016 2 3 25 1864 28749 6 Single Family 1978 Ames, IA Iowa State University 21 249000 5 20 2016 3 2 25 1381 13939 2 Single Family 1983 Ames, IA Iowa State University 22 246000 6 24 2016 3 2 75 1969 11761 2 Single Family 1977 Ames, IA Iowa State University 23 264000 4 29 2016 3 2 1660 13068 Single Family 1979 Ames, IA Iowa State University 24 180000 7 15 2016 3 3 1277 10140 Single Family 1975 Ames, IA Iowa State University 25 196000 4 4 2016 4 3 1768 10000 Single Family 1973 Ames, IA Iowa State University 26 262000 6 15 2016 3 1 75 1650 14374 8 Single Family 1900 Ames, IA Iowa State University 27 138000 5 10 2016 3 1 845 8712 Single Family 1970 Ames, IA Iowa State University 28 143500 5 10 2016 2 1 858 7340 Single Family 1971 Ames, IA Iowa State University 29 122000 5 10 2016 2 2 987 1680 Single Family 1972 Ames, IA Iowa State University 30 145000 2 10 2016 2 2 836 2280 Single Family 1977 Ames, IA Iowa State University

Question: Develop a decision tree model to predict the sale price of a house by using predictor variables, such as number of bedrooms, number of bathrooms,

Develop a decision tree model to predict the sale price of a house by using predictor variables, such as number of bedrooms, number of bathrooms, home square footage, lot square footage, and age of the house. As real estate values can differ dramatically from region to region, you may want to develop a model for several campuses in the data file and compare the resulting decision trees.

Record	Sale_amount	Sale_date	Beds	Baths	Sqft_home	Sqft_lot	Type	Build_year	Town	University
1	295000	5/31/2016	5	3	2020	38332.8	Single Family	1976	Ames, IA	Iowa State University
2	240000	6/20/2016	4	2	1498	54014.4	Single Family	2002	Ames, IA	Iowa State University
3	385000	5/31/2016	5	4	4000	85813.2	Single Family	2001	Ames, IA	Iowa State University
4	268000	4/12/2016	3	2.5	2283	118918.8	Single Family	1972	Ames, IA	Iowa State University
5	186000	4/5/2016	3	1.25	1527	15681.6	Single Family	1975	Ames, IA	Iowa State University
6	302500	3/2/2016	4	3	3117	33105.6	Single Family	1976	Ames, IA	Iowa State University
7	223000	6/2/2016	3	2	1218	25264.8	Single Family	1975	Ames, IA	Iowa State University
8	225000	5/7/2016	3	3	3000	30056.4	Single Family	1969	Ames, IA	Iowa State University
9	215000	4/14/2016	5	2	2963	14374.8	Single Family	1965	Ames, IA	Iowa State University
10	285100	2/12/2016	3	4	1680	48351.6	Single Family	1987	Ames, IA	Iowa State University
11	269000	6/1/2016	3	2	1682	43560	Single Family	1932	Ames, IA	Iowa State University
12	650000	6/2/2016	4	3.5	2535	82764	Single Family	1998	Ames, IA	Iowa State University
13	203500	4/18/2016	4	2	1277	10628	Single Family	1970	Ames, IA	Iowa State University
14	265000	6/28/2016	4	2.5	1340	10290	Single Family	1998	Ames, IA	Iowa State University
15	180000	2/24/2016	3	3.5	1709	13068	Single Family	1991	Ames, IA	Iowa State University
16	192000	2/29/2016	3	3	1470	8139	Single Family	1995	Ames, IA	Iowa State University
17	246500	3/23/2016	4	3.5	1776	8712	Single Family	1996	Ames, IA	Iowa State University
18	258000	6/14/2016	4	2.5	1752	9174	Single Family	1996	Ames, IA	Iowa State University
19	240500	3/17/2016	3	2.25	1502	6821	Single Family	1985	Ames, IA	Iowa State University
20	218000	7/1/2016	2	3.25	1864	28749.6	Single Family	1978	Ames, IA	Iowa State University
21	249000	5/20/2016	3	2.25	1381	13939.2	Single Family	1983	Ames, IA	Iowa State University
22	246000	6/24/2016	3	2.75	1969	11761.2	Single Family	1977	Ames, IA	Iowa State University
23	264000	4/29/2016	3	2	1660	13068	Single Family	1979	Ames, IA	Iowa State University
24	180000	7/15/2016	3	3	1277	10140	Single Family	1975	Ames, IA	Iowa State University
25	196000	4/4/2016	4	3	1768	10000	Single Family	1973	Ames, IA	Iowa State University
26	262000	6/15/2016	3	1.75	1650	14374.8	Single Family	1900	Ames, IA	Iowa State University
27	138000	5/10/2016	3	1	845	8712	Single Family	1970	Ames, IA	Iowa State University
28	143500	5/10/2016	2	1	858	7340	Single Family	1971	Ames, IA	Iowa State University
29	122000	5/10/2016	2	2	987	1680	Single Family	1972	Ames, IA	Iowa State University
30	145000	2/10/2016	2	2	836	2280	Single Family	1977	Ames, IA	Iowa State University

Step by Step Solution

★★★★★

3.50 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

StepbyStep Guide to Develop a Decision Tree Model for Predicting House Sale Prices In this guide we will use Python and its libraries to develop a dec... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Business Analytics Data Questions!

In Exercise 9.63 we look at predicting the price (in $1000s) of New York homes based on the size (in thousands of square feet), using the data in HomesForSaleNY. Two other variables in the dataset...

Develop a predictive model for the price of a house in the college town of Ames, Iowa. Before evaluating various models, you first have to filter out the House Price data to get the appropriate...

Subset the data to include only college-educated sales professionals in the software product group. Develop a decision tree model to predict whether or not the sales professional will receive a high...

How do I set this up in excel? Question: Develop a decision tree model to predict the sale price of a house by using predictor variables such as number of bedrooms, number of bathrooms, home square...

The dataset for this assignment contains house prices as well as 19 other features for each property. Those features are detailed below and include information about the house (number of bedrooms,...

Subset the data based on variables, such as number of bedrooms, number of bathrooms, home square footage, lot square footage, and age of the house. Which variables can be removed when predicting...

AutoSave . OFF Homework 5 - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Tell me Share Comments Times New... 12 A Aa v AaBbCcDdEe AaBbCcDdEe AaBbCcD AaBbCcDdE...

During the early 2000s, the united states experienced a boom in the housing industry. This boom was in large parts due to efforts by the government to boost consumer spending. The chairman of the...

(a) Construct a correlation matrix with price, acres, bedrooms, bathrooms, square feet, age, and rooms. Is there any reason to be concerned with multicollinearity based on the correlation matrix? (b)...

Which of the following is true regarding inheritance? a. When creating a subclass, all methods of the superclass must be overridden. b. When creating a subclass, no methods of a superclass can be...

1. Corn Crunchers has three product lines. Its only unprofitable line is Corn Nuts, the results of which appear below for 2010 Sales $700,000 Variable expenses 460,000 Fixed expenses 300 000 Net loss...

Why is mobile connectivity considered a disruptive technology?

A. Was the bad news delivered in a timely manner? Do you think it was delivered too directly? Too indirectly? Explain.

At a local bar in a small Midwestern town, beer and wine are the only two alcoholic options. The manager conducts a survey on the bars customers over the past weekend. Customers are asked to identify...

Metalworks, a supplier of fabricated industrial parts, wonders if there is any connection between when a component is constructed (Shift is equal to 1, 2, or 3) and whether or not it is defective...

A researcher at a marketing firm examines whether the age of a consumer matters when buying athletic clothing. Her initial feeling is that Brand A attracts a younger customer, whereas the more...

Vaughn Co. operates three separate departments (A, B, C). The data below is provided for the current year: Total Sales $120,000 ($40,000 from each department) Cost of Goods Sold $ 80,000 ( 50% from...

Lawrence is the owner of Lawrence Hardware and Electric, a family owned business located southern New Jersey, just outside of Philadelphia. His business consists of over-the-counter retail sales and...

Requirement 3: Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Do not round your intermediate calculations. Round your predetermined overhead rate to 2...