Search this file on google and it will bring you to the given data needed to do those questions:

https://studentutsedu-my.sharepoint.com/:x:/g/personal/dinhhieu_nguyen_student_uts_edu_au/EfKZJZ0O59tIvxJJY5ALgBkBCYfaj6VvBkJffQCKy5nqww?e=B77kPF

Your team have been accepted as interns in Landcom. Landcom manage the strategic and complexresidential projects. Your first job is to conduct an analysis based on the recent sales price of the three suburbs( Chatswood, Chiswick, Cronulla) of New South wales for the year 2018, 2019 and 2020 from https://www.realestate.com.au/sold/ .

Q1. Collect and Compute the appropriate descriptive statistics of the "sold house price", "Sold house land size" and "sold house number of rooms" for the year 2018 ,2019 and 2020 of the suburban selected by your tutor. The descriptive statistics measures include central tendency (mean), variability (standard deviation), Mode, Quartiles, Range, Interquartile range and Show the infographics (e.g., pie chart, bar chart, etc.) of 2018, 2019 and 2020 data for the following variables: (a) Sold house price (b) Sold house land size (c) Sold house number of rooms *** The sample size should be at least 30 for each year (2018,2019,2020) for each suburb. So, for one suburb, the total at least the number of houses recorded should be 90 for three years period. ***

Q2. What is the average house price of each selected suburb for 2020 (Use the house price average from question 1 and construct a 95% confidence interval for the average house price for each selected suburb of New south wales for the year 2020)? Note: The population standard deviation of house prices in New South Wales is $20,000.

Q3. A recent study has claimed that the average house price in New South Wales is $872,934. Use your collected data to test this claim for each selected suburb for the year 2020 (Note: Use the sample statistics from question 1). Note: The population standard deviation of house prices in New South Wales is $20,000. Is there any evidence to suggest that the average house price has changed at a 5% level of significance? Report your findings with clear conclusions and all supporting calculations.