Hi Using Excel, Enter Data, highlight , chose insert scatter plot Add trendline and formula x y 25 118 45 105 30 112 50 100 35 111 40 108 65 95 75 88 70 91 60 96 Part (a): plot scatter diagram for the above data/ trend line. Part (d): Estimate the quantity sold when price is 80. Y = -.5668(80) + 130.45 = 86 quantity sold (estimate) Wish You the Best in your Studies.