You are presented with the following sales data from 2015-2022 of The Kirby Auto Corporation on sales of its used automobiles from its auto sales center in Syracuse, NY. The average product's price, measured in 100's of US Dollars, is 58, 48, 38, 28, 18, and 8. The corresponding quantity demanded at the Syracuse site, measured in 1,000 automobiles, is 4, 8, 12, 16, 20, and 24. All the data was retrieved from the New York State Auto Review, March 2023, volume 38, issue 4, pages 34-38, "Used Car Sales in Central New York" by Connie Romano, and will be used in your presentation that you are making at the New York State Used Car Dealers 2024 Annual Meeting, Albany, NY.

a. Using Excel, your line graph should present clearly and accurately showing the demand curve for the Syracuse sales center. Label and provide the Title for Graph # 2 in your presentation.

b. Solely consider your graph and data in part A above. Follow the demand curve from $58 to 48, from 48 to 38, from 38 to 28, from 28 to 18, and from 18 to 8.Calculate the elasticity of demand (Ed) for your curve at those price intervals using the midpoint formula.That is 5 separate calculations. If you use any other formula, your work will be severely downgraded. Show all work.Then, address, by referencing your calculations only, what each answer you have calculated means in terms of the elasticity of demand (Ed). You need to explain what the number means in terms of elasticity, be certain to use the formula and reference your demand curve in part A above.

c. Consider your knowledge of the determinants of the elasticity of demand and consider the demand curve you have in part A. Take three concrete causes and address what would make your demand curve more inelastic overall based on those determinants. Be certain to explain why. Simply re-stating what is stated in the question already does not answer the question.