Use Excel to answer the following questions. Where written responses are necessary, provide your written response below each individual question using RED font.

A national homebuilder builds single-family homes and condominium-style townhouses. TheHouse Salesdata below provides information on the selling price, lot cost, type of home, and region of the country for closings during one month.

1. Develop a multiple regression model for sales price as a function of lot cost and type of home without any interaction term.

2. Determine if an interaction exists between lot cost and type of home and find the best model.

3. What is the estimated Selling 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	Townhouse	Interaction
Midwest	Townhouse	$85,145	$17,030	1	$17,030
Midwest	Townhouse	$112,740	$20,700	1	$20,700
Midwest	Townhouse	$115,350	$18,030	1	$18,030
Midwest	Townhouse	$116,415	$19,600	1	$19,600
Midwest	Townhouse	$133,070	$24,455	1	$24,455
Midwest	Single Family	$136,530	$25,500	0	$0
Midwest	Townhouse	$139,435	$29,155	1	$29,155
Midwest	Townhouse	$139,955	$30,400	1	$30,400
Midwest	Townhouse	$147,905	$24,650	1	$24,650
Midwest	Single Family	$153,845	$27,500	0	$0
Midwest	Townhouse	$155,270	$19,600	1	$19,600
Midwest	Townhouse	$155,870	$24,650	1	$24,650
South	Single Family	$160,000	$29,500	0	$0
Midwest	Single Family	$165,220	$25,500	0	$0
Midwest	Single Family	$165,350	$25,000	0	$0
Midwest	Single Family	$168,354	$27,316	0	$0
Midwest	Single Family	$168,500	$33,000	0	$0
Midwest	Single Family	$170,000	$25,200	0	$0
South	Townhouse	$172,749	$45,025	1	$45,025
Midwest	Single Family	$175,000	$28,000	0	$0
Midwest	Townhouse	$175,470	$28,600	1	$28,600
Midwest	Townhouse	$179,365	$32,200	1	$32,200
South	Townhouse	$181,916	$45,025	1	$45,025
South	Townhouse	$182,237	$45,025	1	$45,025
Midwest	Single Family	$183,370	$28,000	0	$0
Midwest	Single Family	$184,210	$28,000	0	$0
Midwest	Single Family	$184,460	$22,300	0	$0
Midwest	Townhouse	$184,873	$33,400	1	$33,400
Midwest	Single Family	$185,160	$29,000	0	$0
South	Single Family	$186,000	$35,851	0	$0
Midwest	Townhouse	$187,390	$27,000	1	$27,000
Midwest	Single Family	$188,603	$31,300	0	$0
Midwest	Single Family	$189,120	$35,000	0	$0
South	Single Family	$191,028	$45,000	0	$0
South	Townhouse	$196,898	$45,025	1	$45,025
South	Townhouse	$198,202	$45,025	1	$45,025
South	Single Family	$200,119	$45,000	0	$0
South	Townhouse	$200,423	$45,025	1	$45,025
Midwest	Single Family	$201,700	$40,940	0	$0
South	Single Family	$202,000	$31,160	0	$0
South	Townhouse	$203,076	$45,025	1	$45,025
Midwest	Single Family	$203,950	$33,000	0	$0
South	Single Family	$204,900	$34,000	0	$0
South	Single Family	$205,821	$39,299	0	$0
South	Single Family	$206,400	$35,851	0	$0
South	Single Family	$207,345	$35,600	0	$0
South	Single Family	$209,400	$43,579	0	$0
Midwest	Single Family	$210,380	$33,856	0	$0
Midwest	Single Family	$211,513	$31,300	0	$0
South	Single Family	$211,797	$34,000	0	$0
Midwest	Townhouse	$212,079	$33,400	1	$33,400
South	Single Family	$214,205	$36,500	0	$0
Midwest	Single Family	$214,900	$31,300	0	$0
South	Single Family	$216,049	$35,600	0	$0
South	Single Family	$219,990	$37,557	0	$0
Midwest	Single Family	$220,257	$31,300	0	$0
Midwest	Single Family	$223,890	$28,000	0	$0
South	Townhouse	$224,108	$45,025	1	$45,025
South	Single Family	$225,900	$28,618	0	$0
South	Single Family	$226,000	$35,600	0	$0
South	Townhouse	$230,000	$45,025	1	$45,025
Midwest	Single Family	$230,440	$33,000	0	$0
Midwest	Single Family	$230,555	$28,000	0	$0
Midwest	Single Family	$233,900	$44,200	0	$0
South	Single Family	$234,971	$29,202	0	$0
South	Single Family	$239,000	$39,169	0	$0
South	Single Family	$239,870	$41,354	0	$0
South	Single Family	$241,195	$41,340	0	$0
South	Single Family	$242,191	$33,434	0	$0
South	Single Family	$242,899	$48,252	0	$0
South	Single Family	$246,648	$41,600	0	$0
Midwest	Single Family	$248,500	$20,000	0	$0
South	Single Family	$249,900	$38,200	0	$0
Midwest	Single Family	$250,005	$33,000	0	$0
South	Townhouse	$250,800	$73,400	1	$73,400
South	Single Family	$252,135	$41,341	0	$0
South	Single Family	$253,055	$41,340	0	$0
South	Single Family	$254,048	$39,680	0	$0
South	Single Family	$255,000	$43,198	0	$0
South	Single Family	$256,235	$48,500	0	$0
South	Single Family	$257,040	$37,631	0	$0
South	Townhouse	$260,100	$73,400	1	$73,400
Midwest	Single Family	$262,740	$44,900	0	$0
South	Single Family	$262,890	$48,500	0	$0
South	Single Family	$265,058	$41,404	0	$0
Midwest	Townhouse	$265,500	$35,800	1	$35,800
South	Townhouse	$267,060	$73,400	1	$73,400
South	Single Family	$267,250	$45,676	0	$0
South	Townhouse	$267,640	$73,400	1	$73,400
South	Single Family	$268,000	$43,344	0	$0
Midwest	Single Family	$268,210	$29,700	0	$0
South	Single Family	$268,500	$41,099	0	$0
South	Townhouse	$269,410	$73,400	1	$73,400
South	Single Family	$270,518	$46,499	0	$0
Midwest	Single Family	$271,105	$45,000	0	$0
Midwest	Single Family	$274,455	$41,000	0	$0
South	Single Family	$274,903	$45,345	0	$0
Midwest	Single Family	$277,720	$44,650	0	$0
South	Single Family	$280,622	$45,130	0	$0
South	Single Family	$280,804	$40,667	0	$0
Midwest	Single Family	$281,487	$57,285	0	$0
South	Single Family	$281,824	$50,448	0	$0
Midwest	Single Family	$283,440	$50,900	0	$0
South	Single Family	$286,758	$57,000	0	$0
South	Single Family	$287,771	$46,300	0	$0
Midwest	Single Family	$289,000	$44,000	0	$0
South	Single Family	$290,000	$48,300	0	$0
South	Single Family	$290,190	$82,250	0	$0
South	Townhouse	$294,450	$73,400	1	$73,400
South	Single Family	$294,990	$57,000	0	$0
South	Single Family	$299,096	$43,784	0	$0
South	Single Family	$301,500	$59,000	0	$0
South	Single Family	$305,000	$49,067	0	$0
Midwest	Single Family	$307,373	$41,292	0	$0
South	Single Family	$307,387	$45,850	0	$0
South	Single Family	$307,663	$44,840	0	$0
South	Single Family	$309,075	$82,250	0	$0
South	Single Family	$310,100	$41,800	0	$0
South	Single Family	$310,372	$60,000	0	$0
South	Single Family	$312,898	$40,768	0	$0
South	Single Family	$318,274	$85,800	0	$0
South	Single Family	$318,523	$50,000	0	$0
South	Single Family	$319,602	$82,250	0	$0
South	Single Family	$322,920	$82,250	0	$0
Midwest	Single Family	$323,716	$34,500	0	$0
South	Single Family	$324,266	$47,891	0	$0
South	Single Family	$324,412	$62,523	0	$0
South	Single Family	$326,570	$51,000	0	$0
South	Single Family	$329,611	$48,611	0	$0
Midwest	Single Family	$330,486	$35,000	0	$0
South	Single Family	$330,710	$49,920	0	$0
South	Single Family	$333,158	$49,123	0	$0
South	Townhouse	$335,000	$68,375	1	$68,375
South	Single Family	$337,374	$70,399	0	$0
South	Single Family	$337,380	$49,150	0	$0
South	Single Family	$338,065	$54,850	0	$0
South	Single Family	$340,000	$40,000	0	$0
South	Single Family	$340,730	$50,850	0	$0
South	Single Family	$342,423	$48,309	0	$0
Midwest	Single Family	$348,744	$53,000	0	$0
South	Single Family	$350,702	$46,386	0	$0
South	Single Family	$352,781	$60,000	0	$0
South	Single Family	$354,065	$48,115	0	$0
South	Single Family	$354,117	$56,219	0	$0
South	Single Family	$355,688	$65,373	0	$0
South	Single Family	$358,162	$44,470	0	$0
South	Single Family	$359,949	$50,591	0	$0
South	Single Family	$366,990	$55,508	0	$0
South	Single Family	$367,600	$50,000	0	$0
South	Single Family	$369,101	$46,773	0	$0
South	Single Family	$371,152	$58,223	0	$0
South	Single Family	$379,000	$72,915	0	$0
South	Single Family	$379,424	$64,902	0	$0
South	Single Family	$379,575	$44,294	0	$0
South	Single Family	$385,000	$75,000	0	$0
South	Single Family	$385,942	$49,123	0	$0
South	Single Family	$387,527	$48,000	0	$0
South	Single Family	$398,651	$65,429	0	$0
South	Single Family	$400,330	$75,510	0	$0
South	Single Family	$404,510	$58,225	0	$0
South	Single Family	$407,076	$48,668	0	$0
Midwest	Single Family	$410,810	$66,500	0	$0
South	Single Family	$417,790	$63,099	0	$0
South	Single Family	$432,426	$57,422	0	$0
South	Single Family	$444,304	$53,938	0	$0
South	Single Family	$446,507	$75,510	0	$0
South	Single Family	$492,820	$84,122	0	$0
South	Single Family	$575,120	$79,790	0	$0