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 footage, lot square footage, and age of the house. Note: As real estate values can differ dramatically from region to region, you may want to develop a model for each geographic location in the data set. Compare the performance of the decision tree model with predictive models that use other supervised learning techniques discussed in Chapter 9.

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