A national homebuilder builds single-family homes and condominium-style townhouses. The Excel file House Sales provides information on the selling price, lot cost, type of home, and region of the country (where M = Midwest, S = South) for closings during one month.

1. Using the final model, find out the predicted price for either a single family home or a townhouse with a lot cost of $30,000

House Sales
Region	Type	Selling Price	Lot Cost
Midwest	Townhouse	$85,145	$17,030
Midwest	Townhouse	$1,12,740	$20,700
Midwest	Townhouse	$1,15,350	$18,030
Midwest	Townhouse	$1,16,415	$19,600
Midwest	Townhouse	$1,33,070	$24,455
Midwest	Single Family	$1,36,530	$25,500
Midwest	Townhouse	$1,39,435	$29,155
Midwest	Townhouse	$1,39,955	$30,400
Midwest	Townhouse	$1,47,905	$24,650
Midwest	Single Family	$1,53,845	$27,500
Midwest	Townhouse	$1,55,270	$19,600
Midwest	Townhouse	$1,55,870	$24,650
South	Single Family	$1,60,000	$29,500
Midwest	Single Family	$1,65,220	$25,500
Midwest	Single Family	$1,65,350	$25,000
Midwest	Single Family	$1,68,354	$27,316
Midwest	Single Family	$1,68,500	$33,000
Midwest	Single Family	$1,70,000	$25,200
South	Townhouse	$1,72,749	$45,025
Midwest	Single Family	$1,75,000	$28,000
Midwest	Townhouse	$1,75,470	$28,600
Midwest	Townhouse	$1,79,365	$32,200
South	Townhouse	$1,81,916	$45,025
South	Townhouse	$1,82,237	$45,025
Midwest	Single Family	$1,83,370	$28,000
Midwest	Single Family	$1,84,210	$28,000
Midwest	Single Family	$1,84,460	$22,300
Midwest	Townhouse	$1,84,873	$33,400
Midwest	Single Family	$1,85,160	$29,000
South	Single Family	$1,86,000	$35,851
Midwest	Townhouse	$1,87,390	$27,000
Midwest	Single Family	$1,88,603	$31,300
Midwest	Single Family	$1,89,120	$35,000
South	Single Family	$1,91,028	$45,000
South	Townhouse	$1,96,898	$45,025
South	Townhouse	$1,98,202	$45,025
South	Single Family	$2,00,119	$45,000
South	Townhouse	$2,00,423	$45,025
Midwest	Single Family	$2,01,700	$40,940
South	Single Family	$2,02,000	$31,160
South	Townhouse	$2,03,076	$45,025
Midwest	Single Family	$2,03,950	$33,000
South	Single Family	$2,04,900	$34,000
South	Single Family	$2,05,821	$39,299
South	Single Family	$2,06,400	$35,851
South	Single Family	$2,07,345	$35,600
South	Single Family	$2,09,400	$43,579
Midwest	Single Family	$2,10,380	$33,856
Midwest	Single Family	$2,11,513	$31,300
South	Single Family	$2,11,797	$34,000
Midwest	Townhouse	$2,12,079	$33,400
South	Single Family	$2,14,205	$36,500
Midwest	Single Family	$2,14,900	$31,300
South	Single Family	$2,16,049	$35,600
South	Single Family	$2,19,990	$37,557
Midwest	Single Family	$2,20,257	$31,300
Midwest	Single Family	$2,23,890	$28,000
South	Townhouse	$2,24,108	$45,025
South	Single Family	$2,25,900	$28,618
South	Single Family	$2,26,000	$35,600
South	Townhouse	$2,30,000	$45,025
Midwest	Single Family	$2,30,440	$33,000
Midwest	Single Family	$2,30,555	$28,000
Midwest	Single Family	$2,33,900	$44,200
South	Single Family	$2,34,971	$29,202
South	Single Family	$2,39,000	$39,169
South	Single Family	$2,39,870	$41,354
South	Single Family	$2,41,195	$41,340
South	Single Family	$2,42,191	$33,434
South	Single Family	$2,42,899	$48,252
South	Single Family	$2,46,648	$41,600
Midwest	Single Family	$2,48,500	$20,000
South	Single Family	$2,49,900	$38,200
Midwest	Single Family	$2,50,005	$33,000
South	Townhouse	$2,50,800	$73,400
South	Single Family	$2,52,135	$41,341
South	Single Family	$2,53,055	$41,340
South	Single Family	$2,54,048	$39,680
South	Single Family	$2,55,000	$43,198
South	Single Family	$2,56,235	$48,500
South	Single Family	$2,57,040	$37,631
South	Townhouse	$2,60,100	$73,400
Midwest	Single Family	$2,62,740	$44,900
South	Single Family	$2,62,890	$48,500
South	Single Family	$2,65,058	$41,404
Midwest	Townhouse	$2,65,500	$35,800
South	Townhouse	$2,67,060	$73,400
South	Single Family	$2,67,250	$45,676
South	Townhouse	$2,67,640	$73,400
South	Single Family	$2,68,000	$43,344
Midwest	Single Family	$2,68,210	$29,700
South	Single Family	$2,68,500	$41,099
South	Townhouse	$2,69,410	$73,400
South	Single Family	$2,70,518	$46,499
Midwest	Single Family	$2,71,105	$45,000
Midwest	Single Family	$2,74,455	$41,000
South	Single Family	$2,74,903	$45,345
Midwest	Single Family	$2,77,720	$44,650
South	Single Family	$2,80,622	$45,130
South	Single Family	$2,80,804	$40,667
Midwest	Single Family	$2,81,487	$57,285
South	Single Family	$2,81,824	$50,448
Midwest	Single Family	$2,83,440	$50,900
South	Single Family	$2,86,758	$57,000
South	Single Family	$2,87,771	$46,300
Midwest	Single Family	$2,89,000	$44,000
South	Single Family	$2,90,000	$48,300
South	Single Family	$2,90,190	$82,250
South	Townhouse	$2,94,450	$73,400
South	Single Family	$2,94,990	$57,000
South	Single Family	$2,99,096	$43,784
South	Single Family	$3,01,500	$59,000
South	Single Family	$3,05,000	$49,067
Midwest	Single Family	$3,07,373	$41,292
South	Single Family	$3,07,387	$45,850
South	Single Family	$3,07,663	$44,840
South	Single Family	$3,09,075	$82,250
South	Single Family	$3,10,100	$41,800
South	Single Family	$3,10,372	$60,000
South	Single Family	$3,12,898	$40,768
South	Single Family	$3,18,274	$85,800
South	Single Family	$3,18,523	$50,000
South	Single Family	$3,19,602	$82,250
South	Single Family	$3,22,920	$82,250
Midwest	Single Family	$3,23,716	$34,500
South	Single Family	$3,24,266	$47,891
South	Single Family	$3,24,412	$62,523
South	Single Family	$3,26,570	$51,000
South	Single Family	$3,29,611	$48,611
Midwest	Single Family	$3,30,486	$35,000
South	Single Family	$3,30,710	$49,920
South	Single Family	$3,33,158	$49,123
South	Townhouse	$3,35,000	$68,375
South	Single Family	$3,37,374	$70,399
South	Single Family	$3,37,380	$49,150
South	Single Family	$3,38,065	$54,850
South	Single Family	$3,40,000	$40,000
South	Single Family	$3,40,730	$50,850
South	Single Family	$3,42,423	$48,309
Midwest	Single Family	$3,48,744	$53,000
South	Single Family	$3,50,702	$46,386
South	Single Family	$3,52,781	$60,000
South	Single Family	$3,54,065	$48,115
South	Single Family	$3,54,117	$56,219
South	Single Family	$3,55,688	$65,373
South	Single Family	$3,58,162	$44,470
South	Single Family	$3,59,949	$50,591
South	Single Family	$3,66,990	$55,508
South	Single Family	$3,67,600	$50,000
South	Single Family	$3,69,101	$46,773
South	Single Family	$3,71,152	$58,223
South	Single Family	$3,79,000	$72,915
South	Single Family	$3,79,424	$64,902
South	Single Family	$3,79,575	$44,294
South	Single Family	$3,85,000	$75,000
South	Single Family	$3,85,942	$49,123
South	Single Family	$3,87,527	$48,000
South	Single Family	$3,98,651	$65,429
South	Single Family	$4,00,330	$75,510
South	Single Family	$4,04,510	$58,225
South	Single Family	$4,07,076	$48,668
Midwest	Single Family	$4,10,810	$66,500
South	Single Family	$4,17,790	$63,099
South	Single Family	$4,32,426	$57,422
South	Single Family	$4,44,304	$53,938
South	Single Family	$4,46,507	$75,510
South	Single Family	$4,92,820	$84,122
South	Single Family	$5,75,120	$79,790

Please prepare an excel sheet.