The data below (also available for download here Property.xlsx) contains the list price of 28 houses in the town of Pleasantville along with the size of the living space, the number of bathrooms, and the age of the house. Using the list price as the dependent variable complete the following:

House	List Price ($1,000)	Size (square feet)	# of Bathrooms	Age (in years)
1	295	1,300	2.5	5
2	295	1,700	2	2
3	290	1,250	2.5	3
4	290	2,100	2	4
5	200	1,250	2	6
6	200	1,100	2	5
7	200	1,250	2.5	4
8	170	1,400	2	7
9	164	1,450	1.5	12
10	164	1,700	2.5	10
11	163	1,350	2.5	15
12	162	1,300	2.5	12
13	150	700	1	20
14	150	1,150	1.5	9
15	138	850	1.5	9
16	138	1,350	2	12
17	137	1,150	1.5	10
18	472	3,300	3	2
19	440	3,500	4	1
20	439	3,900	4	3
21	430	3,200	3	4
22	295	1,680	3	4
23	200	1,000	2.5	10
24	200	1,200	2	12
25	200	1,100	2	9
26	164	1,100	2.5	7
27	138	1,600	3	17
28	138	1,400	2	20

a) Do a set of initial INDIVIDUAL significance tests at a 5% significance level. Which variable should be removed from the model? (answer MUST include numerical value which justified your decision)(2 marks)

COMPLETE A NEW REGRESSION ANALYSIS AFTER REMOVING THER APPROPRIATE VARIABLE FROM PART A

b) Predict the price of a house with the following...2,500 square feet; 2.5 bathrooms; 15 years old. OMIT THE INFORMATION FOR THE VARIABLE THAT WAS REMOVED IN PART A. Final answer rounded to the nearest dollar. (2 marks)