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

https://docs.google.com/spreadsheets/d/1WPX1psVGCwghIZTYjclge4AoaIIxesqF9kiz8NtkkHk/edit?usp=gmail

How do you answer this question using the information provided in the spread sheet above?