Please complete in Excel and include all necessary functions used to solve the problem.

In a competitive market, the market demand curve is 1 PD=14_q 2 and the market supply curve is 1 p5 8 +q Use a spreadsheet to answer the following questions. Use excel to create a picture of the demand and supply curve for q = 0, 1, 2, ..., 14. Determine the equilibrium quantity and price. Determine the consumer surplus. Determine the producer surplus