Q6. What is the average house price of each selected suburb (Chatswood, Chiswick, Cronulla) 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.

Q7. 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 (Chatswood, Chiswick, Cronulla) 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.

Q1. shorturl.at/AJRX8 (copy this excel link and put it on google to find the provided solution)