Choose two comparable college towns Develop a predictive, model for the sale price of a house for each college town Explore loglinear transformations, dummy variables, and interactions of the relevant predictor variables Use model selection criteria to select the best predictive model Interpret your results with reference to well formatted figures and tables 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

Question: Choose two comparable college towns. Develop a predictive, model for the sale price of a house for each college town. Explore loglinear transformations, dummy variables,

Choose two comparable college towns. Develop a predictive, model for the sale price of a house for each college town. Explore loglinear transformations, dummy variables, and interactions of the relevant predictor variables. Use model selection criteria to select the best predictive model. Interpret your results with reference to well-formatted figures and tables.

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

Step by Step Solution

★★★★★

3.45 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

First subset the HousePrice data by University of Kentucky You sh... 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!

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...

The National Association of Realtors maintains a database consisting of sales information on homes sold in the United States. The next table lists the sale prices for a sample of 28 recently sold,...

Choose a college of interest and use the sample of enrolled students to best predict a students college grade point average. Explore interactions of the relevant predictor variables and use model...

Investing in college town real estate can be a smart move First students offer a steady stream of rental demand as many cashstrapped public universities are unable to house their students beyond...

I need this to be on EXCEL sheet, I want it as the following instruction: 1- X Variable? Y Variable? 2- Regression Equation? 3- R-Square 4-X value statistically significant variable? By Using the...

During the 2020 Covid-19 pandemic, home prices increased significantly due to the increase in demand and the limited supply. According to a report by Zillow, in May 2021, the average home price...

Can you please help me answer two questions based on the readings below. 1 How would you contrast the mainstream economics view of consumer behavior in 9.3, with the demand curve in general, and also...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

(Questions from Lecture and Article) - Discussion Board Activity I need to read the following Lecture Note and the ?Wall Street Journal? articles that I uploaded, and writeanswers for theDiscussion...

Through the use of strategic alternatives, companies may compete in a marketplace, achieve its vision, or if no vision has been articulated, decide where it might go and what it might achieve....

We have used little vertically oriented rectangles to compute areas. There is no reason why little horizontal rectangles cannot be used. Here are the steps to find the area under the curve y = f(x)...

The pH of an aqueous solution of 3.0810 -2 M ammonium chloride , NH 4 Cl (aq), is . This solution is _________ acidic basic neutral acidic, basic, or neutral?

2.11 Armspans (Example 3) According to the ancient Roman architect Vitruvius, a persons armspan (the distance from fingertip to fingertip with the arms stretched wide) is approximately equal to his...

E. Do you consider this sales message respectful?

Suppose that a study finds that 33% of teenagers text while driving. The study was based on 100 teen drivers. a. Discuss the sampling distribution of the sample proportion. b. What is the probability...

The monthly closing stock price for a large technology firm for the first six months of the year are reported in the following table. Month Price...

A survey of 1,026 people were asked about what they would do with an unexpected cash gift. Forty-seven percent responded that they would pay off debts. a. With 95% confidence, what is the margin of...

Durable Plastics Company had the following total assets, liabilities, and equity as of December 31. Total Assets Total Liabilities Total Equity $430,000 131,000 299,000 What is the company's debt...

Exercise 4-9 (Static) Equivalent Units and Cost per Equivalent Unit-Weighted Average Method (L04-2, LO4-3] Pureform, Inc., uses the weighted-average method in its process costing system. It...

For the last completed calendar year, Thomas Corporation, an accrual basis calendar year taxpayer, had net income per books of $102,750 and a taxable income of $15,750. Thomas had the following...