Use an appropriate Excel function and the data to find a predicted(average) selling price for a single- family house measuring 1880 square feet.Does the house that measured 1840 square feet in the sample have a selling price that is below or above average, and why?

H K U A B C D E F G L M N O P Q R S T V 1 Square Footage Selling Price 19) Selling Price N 3000 419000 1280 40000 1200000 1188 146200 y = 196.45x - 135277 1728 151000 1332 135000 1000000 1100 30000 2200 211000 800000 1000 138000 10 1500 202900 Selling Price 500000 11 1256 192000 12 1558 27500 400000 13 1463 165000 14 1402 98500 20) r= 0.772698 15 2586 203000 200000 16 1221 159000 17 1956 139500 18 1041 164697 21) Slope 196.4512 500 1000 1500 2000 2500 3000 3500 4000 4500 19 805 80000 Y Int -135277 Square Footage 20 1880 97500 Y=196.45-135277 21 988 19000 O 22 1500 169800 23 1428 500 22 24 1680 495000 25 2935 293000 # 1 | # 2-#15 #16,#17 |#18 #19-#22 #23 | #24 |#25 |#26,27 + 100 Ready