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 Excel given). 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.

Sold Hose price Sold housse land size Sold house number of rooms tendency (mean) $2,766,233 631.62 6.4 variability (standard deviation) $1,213,243 210.03 1.99 Mode #N/A 607 6 Quartiles 1 $2,028,000 516.65 Quartiles 3 $3,039,500 599 Range $5,425,000 356 Interquartile $1,011,500 182.35 2 Suburb Chatswood ( 2020 ) Sold Hose price Sold housse land size Sold house number of rooms Sold Date Sold Hose price Sold housse land size Sold house number of rooms 1/2/2020 $2,019,000 276 Mear 2766233.33 Mean 631.623333 Mean 6.4 7/2/2020 $2,000,000 556.4 Standard Error 221506.766 Standard Error 38.3462866 Standard Error 0.36388706 14/2/2020 $2,130,000 923 Median 2342500 Median 607 Median 22/2/2020 $3,350,000 592 Mode #N/A Mode 607 Mode 7/3/2020 $2,535,000 530 Standard Deviation 1213242.53 Standard Deviation 210.031262 Standard Deviation 1.99309152 2020 11/3/2020 $2,302,000 371 Sample Variance 1.47E+12 Sample Variance 44113.1308 Sample Variance 3.97241379 11/3/2020 $3,725,000 696 Kurtosis 5.69377422 Kurtosis 0.47090187 Kurtosis 0.86292875 14/3/2020 $3,290,000 651 Skewness 2.27638786 Skewness 0.7609757 Skewness 0.85787402 17/3/2020 $6,000,000 657 Range 5425000 Range 856 Range 20/3/2020 $2,055,000 1132 Minimum 1625000 Minimum 276 Minimum 25/3/2020 $3,008,000 700 Maximum 7050000 Maximum 1132 Maximum 12 26/3/2020 $2,420,000 385 Sun 82987000 Sum 18948.7 Sum 192 7/5/2020 $1,960,000 822 Count 30 Count 30 Count 30 16/5/2020 $2,835,000 563 30/5/2020 $1,700,000 613 1/6/2020 $2,350,000 626 3/6/2020 $2,235,000 595 3/6/2020 $2,900,000 1106 4/6/2020 $3,105,000 512.2 5/6/2020 $2,335,000 405 12/6/2020 $1,764,000 607 16/6/2020 $4,389,000 821 19/6/2020 $1,880,000 758 19/6/2020 $2,180,000 404.7 10/7/2020 $3,050,000 556 17/7/2020 $1,625,000 366 17/7/2020 $1,870,000 645 17/7/2020 $2,725,000 607 21/7/2020 $7,050,000 986.4 25/7/2020 $2,200,000 486Sold Hose price Sold housse land size Sold house number of rooms tendency (mean) $2,879,758 512.71 5.1 variability (standard deviation) $1,266,326 221.33 1.84 Mode $5,950,000 342 Quartiles 1 $2,128,000 342 41 Quartiles 3 $3,431,417 651.75 6 Range $4,675,493 775.5 Interquartile $1,303,417 309.75 2 Suburb Chiswick ( 2020 ) Sold Hose price Sold house land size Sold house number of rooms Sold Date Sold Hose price Sold house land size Sold house number of rooms 7/5/2020 $1,700,000 398 Mean 2879757.633 Mean 512.7066667 Mean 5.1 20/5/2020 $1,800,000 100 Standard Error 231198.3869 Standard Error 10.40888514 Standard Error 0.336820836 DO On Un 22/5/2020 $2,850,000 708 Median 2532500 Median 455 Median 9/6/2020 $3,900,000 878 Mode 5950000Mode 342 Mode 16/6/2020 $1,460,000 342 Standard Deviation 1266325.718 Standard Deviation 221.3285792 Standard Deviation 1.8448437 Sample Variance 18986.33995 Sample Variance 3.403448276 2020 27/6/2020 $2,934,000 544 1.60E+12 Sample Variance 7/7/2020 $3,255,000 656.7 Kurtosis 1.709568567 Kurtosis 0.208641971 Kurtosis 0.698762594 17/7/2020 $2,583,000 412.5 Skewness 1.45378986 Skewness 0.774765311 Skewness 0.86709385 7/8/2020 $3,490,222 756 Range 4675493 Range 775.5 Range 8 15/8/2020 $2,185,000 234 Minimum 1415507 Minimum 234 Minimum 2 15/8/2020 $3,498,000 654 Maximum 091000 Maximum 1009.5 Maximum 10 28/8/2020 $4,120,000 156 Sum 86392729 Sum 15381.2 Sum 153 8/9/2020 $6,091,000 1009.5 Count 30 Count 30 Count 30 22/9/2020 $2,109,000 324 28/9/2020 $2,612,000 342 13/10/2020 $5,950,000 980 17/10/2020 $3,550,000 534.5 23/10/2020 $2,300,000 342 24/10/2020 $2,500,000 454 28/10/2020 $2,300,000 235 1/11/2020 $1,415,507 254 3/11/2020 $5,950,000 866 10/11/2020 $1,915,000 344 11/11/2020 $2,200,000 534 15/12/2020 $1,565,000 234 17/11/2020 $2,875,000 423 27/11/2020 $1,895,000 324 2/12/2020 $2,515,000 543 5/12/2020 $2,550,000 554 6/12/2020 $2,325,000 645Sold Hose price Sold housse land size Sold house number of rooms tendency (mean $2,442,233 604.79 6.53 variability (standard deviation) $669,630 132.09 1.43 Mode $3,000,000 607 6 Quartiles 1 $1,985,000 531.5 6 Quartiles 3 $2,955,000 38.75 Range $2,525,000 615 Interquartile $970,000 107.25 Suburb Cronulla ( 2020 ) Sold Hose price Sold house land size Sold house number of rooms Sold Date Sold Hose price Sold house land size Sold house number of rooms 9/1/2020 $2,820,000 601.8 10 Mean $2,442,233.33 Mean 604.79 Mean 6.533333333 15/1/2020 $1,330,000 531.1 Standard Error $122,257.08 Standard Error 24.11576551 Standard Error 0.261443092 24/1/2020 $3,855,000 756.8 Median $2,362,000 Median 604.5 Median 7/2/2020 $1,875,000 465 Mode $3,000,000 Mode 607 Mode 19/2/2020 $1,900,000 575 Standard Deviation $669,629.63 Standard Deviation 132.0874876 Standard Deviation 1.431982791 22/2/2020 $2,374,000 446 Sample Variance $448,403,840,229.89 Sample Variance 17447.10438 Sample Variance 2.050574713 2020 29/2/2020 $3,390,000 910 Kurtosis 0.702024121 Kurtosis 1.041337145 Kurtosis D.829494072 9/3/2020 $2,300,000 541 Skewness 0.391762156 Skewness 0.448941638 Skewness ).607741567 13/3/2020 $3,300,000 695 Range $2,525,000.00 Range 615 Range 21/3/2020 $3,555,000 733 Minimum $1,330,000.00 Minimum 295 Minimum 23/3/2020 $2,505,000 607 Maximum $3,855,000.00 Maximum 910 Maximum 10 28/3/2020 $2,350,000 556.4 Sum $73,267,000.00 Sum 18143.7 Sum 196 31/3/2020 $2,585,000 602 Count 30 Count 30 Count 30 21/4/2020 $2,530,000 898 21/5/2020 $2,050,000 631 9/6/2020 $2,110,000 641 16/6/2020 $2,250,000 506 27/6/2020 $2,070,000 632 7/7/2020 $3,000,000 626 17/7/2020 $2,511,000 632 7/8/2020 $2,000,000 532.7 15/8/2020 $1,580,000 578 15/8/2020 $2,507,000 841 28/8/2020 $1,980,000 645 8/9/2020 $1,625,000 450 22/9/2020 $3,000,000 528 28/9/2020 $1,600,000 607 13/10/2020 $1,575,000 295 17/10/2020 $3,360,000 467.9 23/10/2020 $3,380,000 613