Using these data and Microsoft Excel, please answer the following questions: ) Completed and submitted an individual supply schedule before its due date. (5 pts) ) Completed and submitted an individual demand schedule before its due date. (5 pts) c Generate market demand and supply schedules. Use these schedules to form scatter plots for both series. Place them on the same graph. What does the data suggest the equilibrium price and quantity are? How can you tell? Explain. (S pts) A Use Excel to fit linear trend lines to each series. Call these your "supply and demand curves\". Get their equations and use them to solve for equilibrium price and quantity. How well does this model seem to fit the data? Discuss. (5 pts) Use your supply and demand equations from \"c.\" to compute the ES, CS, and PS in equilibrium. Show all work. (5 pts) Suppose | was to impose a price ceiling of $30 per point on this trade. Compute the amount of CS, PS, ES, and any DWL with the price ceiling imposed. Show all work. Compare your results to your answer from part \"e.\". Who wins and who loses from this policy? Explain. (5 pts) y=0.0376x + 14.703 . - U1 o 3 : e : s $ : $ 3 : @ t wn o e _ =@ @ *n o .'.."' 2000 6000 8000 Demand Linear [Demand)