Period A
Date	selling price	address	number of bedroms	number of bathrooms	property size (m2)	distance to nearest train station or bus stop in KM
23/02/2023	$ 835,000.00	7b Winthrop Drive, Winthrop	4	2	435	0.029
24/07/2023	$ 850,000.00	5 Mackinlay Place, Winthrop	4	2	510	0.270
6/12/2022	$ 915,000.00	18 Lucraft Gardens, Winthrop	4	2	778	0.052
9/09/2022	$ 922,000.00	5 Blakey Rise, Winthrop	4	2	716	0.350
7/03/2023	$ 955,000.00	3 Eckersley Height, Winthrop	4	2	717	0.550
8/01/2023	$ 1,075,000.00	15 Blakers Ridge, Winthrop	4	2	751	0.550
24/01/2023	$ 1,100,000.00	45 Jackson Avenue, Winthrop	4	2	872	0.091
18/04/2023	$ 1,180,000.00	3 Stanley Grovr, Winthrop	4	2	804	0.300
31/03/2023	$ 1,200,000.00	4 Quirk Dale, Winthrop	5	2	744	0.260
28/10/2022	$ 1,210,000.00	13 Henn close, Winthrop	4	2	983	0.400
17/05/2023	$ 1,220,000.00	13 Quirk Dale, Winthrop	5	2	700	0.300
31/03/2023	$ 1,230,000.00	6 Allen-Williams Parade, Winthrop	5	2	700	0.240
25/11/2022	$ 1,240,000.00	48 Ten Seldam Circle, Winthrop	4	2	811	0.400
5/04/2023	$ 1,255,000.00	16 Kingsmill Garden, Winthrop	4	2	720	0.300
11/01/2023	$ 1,280,000.00	33 Lucraft Gardens, Winthrop	4	2	705	0.350
27/03/2023	$ 1,280,000.00	5 Balodis Place, Winthrop	4	2	768	0.600
28/04/2023	$ 1,288,000.00	3 Fardon Tor, Winthrop	4	2	755	0.500
15/06/2023	$ 1,300,000.00	64 Kingsmill Gardens, Winthrop	4	2	720	0.200
13/06/2023	$ 1,335,000.00	17 Raine Terrace, Winthrop	4	2	712	0.280
18/05/2023	$ 1,350,000.00	6 Houghton Way, Winthrop	5	2	973	0.550
31/01/2023	$ 1,400,000.00	16 Whitfels Terrace, Winthrop	4	2	830	0.029
16/05/2023	$ 1,400,000.00	29 Allen-Williams Parade, Winthrop	5	2	710	0.500
13/07/2023	$ 1,470,000.00	11 Grieve close, Winthrop	4	2	808	0.500
31/03/2023	$ 1,500,888.00	4 Levien Place, Winthrop	5	3	702	0.500
20/02/2023	$ 1,600,000.00	9 Craig Place, Winthrop	4	3	992	0.450
period B
Date	selling price	address	number of bedroms	number of bathrooms	property size	distance to nearest train station or bus stop in KM
19/02/2024	$ 910,000.00	17 Sandover Crescent, Winthrop	4	2	779	0.350
22/11/2023	$ 1,000,000.00	17 Northmore Crescent, Winthrop	4	2	718	0.280
9/10/2023	$ 1,100,000.00	1 Lourens Dale, Winthrop	4	2	712	0.550
20/02/2024	$ 1,140,000.00	18 Northmore Crescent, Winthrop	4	2	704	0.300
4/09/2023	$ 1,160,000.00	20 Jackson Avenue, Winthrop	4	2	756	0.170
3/09/2023	$ 1,175,000.00	39 Eckersley Height, Winthrop	4	2	729	0.450
27/02/2024	$ 1,180,000.00	36 Aitken Drive, Winthrop	4	2	715	0.450
22/12/2023	$ 1,190,000.00	2 Rossiter Way, Winthrop	4	2	726	0.240
5/12/2023	$ 1,260,000.00	36 Silbert Circle, Winthrop	4	2	718	0.700
2/10/2023	$ 1,280,000.00	5 Law Court, Winthrop	4	2	740	0.400
7/11/2023	$ 1,280,000.00	9 Watson Hill, Winthrop	4	2	816	0.650
5/11/2023	$ 1,285,000.00	62 Eckersley Heights, Winthrop	4	2	753	0.600
22/09/2023	$ 1,300,000.00	16 Wilkinson Gadens, Winthrop	4	2	700	0.240
29/08/2023	$ 1,310,000.00	3 Jones Close, Winthrop	4	2	742	0.190
2/08/2023	$ 1,311,000.00	9 Grieve Close, Winthrop	4	2	731	0.500
17/01/2024	$ 1,348,000.00	34 Jackson Avenue, Winthrop	4	2	758	0.053
6/02/2024	$ 1,370,000.00	14 Ten Seldam Circle, Winthrop	4	2	754	0.270
8/08/2023	$ 1,400,000.00	13 Gamblen Way, Winthrop	4	2	718	0.400
28/11/2023	$ 1,450,000.00	118 Aitken Drive, Winthrop	4	2	700	0.500
16/01/2024	$ 1,455,000.00	34 Lucraft Gardens, Winthrop	5	3	795	0.300
6/11/2023	$ 1,480,000.00	15 Ten Seldam Circle, Withrop	4	2	747	0.300
25/11/2023	$ 1,520,000.00	14 Parker Place, Withrop	4	2	816	0.650
15/02/2024	$ 1,530,000.00	6 Lucraft Gardens, Winthrop	5	2	817	0.200
13/10/2023	$ 1,600,000.00	29 Ten Seldam Circle, Winthrop	5	2	741	0.500
18/01/2024	$ 1,670,000.00	9 Juett Vale, Winthrop	4	2	882	0.260

1. summary statistics table and discuss the central tendency and variations for all variables.

2. Plot the dependent variable (house price), against each independent variable using the scatter plot/dot function in EXCEL. Comment on the strength and the nature of the relationship between the dependent and the independent variables.

3. Generate a multiple regression summary output. Using the information on regression output, state the Multiple Regression equation.

4. Interpret the meaning of slope coefficients of independent variables.

5. Interpret the 2 and adjusted 2 of your model.

6. Conduct a test for significance of your overall multiple regression model at the 5% level of significance. You must state your null and alternative hypotheses.

7.At the 5% level of significance, determine whether each independent variable makes a significant contribution to the Regression model. Based on these results, indicate the independent variables to include in this model.

8. Construct a 95% confidence interval estimate of the population slope of house prices with property size. Interpret your results.

9. Construct a 95% confidence interval estimate of the population slope of house prices with distance to nearest train station or bus stop. Interpret your results.

10. Predict the price of the house using the regression equation you generated in Task 3 and values of the independent variables as advertised. Compare the predicted price with the asking price.