Hello I$\text{'}$m struggling with part d$.$ ive attached an image of the question. can you please show me how to solve for question d using goal seek step by step and exactly which coloums i need to select in order to acieve the correct answer.

$1.$ For a set of data, the price of the product $($$$),$ the corresponding demand quantity, and supply quantity are as follows:

$\backslash$table$[[$Price$,\backslash$table$[[$Demand$],[$Quantity$]],\backslash$table$[[$Supply$],[$Quantity$]]],[1\mathrm{.}75,410,85],[1\mathrm{.}9,370,95],[2\mathrm{.}1,320,110],[2\mathrm{.}25,285,125],[2\mathrm{.}5,240,140],[2\mathrm{.}75,210,155],[3,190,175],[3\mathrm{.}1,180,180],[3\mathrm{.}5,150,210],[3\mathrm{.}75,130,235],[4,110,260],[5,80,300],[7,20,400]]$

a$)$ Plot the scatter diagrams both price versus demand and price versus supply.

b$)$ From the scatter plots estimate:

i$.$ Price equilibrium $3\mathrm{.}1-3\mathrm{.}3$

ii$.$ Quantity equilibrium $180-190$

c$)$ Fit the two parabolas of the form $y=a{x}^2+bx+c$ to the given data for both the demand and supply.

$833$

d$)$ From the above two equations find the price equilibrium using goal seeker.

$\backslash$table$[[a,18\mathrm{.}573,-4\mathrm{.}1367,22\mathrm{.}7097],[b,-227\mathrm{.}94,96\mathrm{.}735,-324\mathrm{.}675],[c,718\mathrm{.}68,-74\mathrm{.}526,793\mathrm{.}206]]$

goal seeker

price

Demand$-$supply