Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Graph on excel , need help with plotting graphs and a-d Graphing Assign X ownloads/Graphing%20Assignment%204%20Fall%202019%20(1).pdf Graphing Assignment # 4 The city of Crawfordville, Florida has

Graph on excel , need help with plotting graphs and a-d

image text in transcribed
Graphing Assign X ownloads/Graphing%20Assignment%204%20Fall%202019%20(1).pdf Graphing Assignment # 4 The city of Crawfordville, Florida has a very bad problem with the mosquito population from late April through late September almost every year. The City generally sprays the mosquito population to deal with the problem. The data below, collected and maintained by the City of Crawfordville's Finance Department, shows the City's market data for spraying for mosquitoes. The price is measured in thousands of US dollars per spraying and both quantities are measured in dozens of spraying events events per year, from 2003-2016. 85 75 55 59 45 35 25 14 12 10 8 4 2 Qd 8 10 12 14 The Rafferty Analytic Group, LTD., Port St Lucie, Florida, is a firm that specializes in chemical spraying I data collection. The firm at the request of the City Council has studied the Crawfordville population and discovered the City generates an externality of $15 for each and every spraying for mosquitoes. This is due to the mist that is created by the spraying which is a general irritant to the nose, eyes and lungs of the residents, the fact that people need to wash their cars after the spraying (unless they keep them in a garage), and are not allowed outdoors for 6 hours in the area once sprayed. a. In one clearly and accurately labeled graph, created using Excel, graph the market data as collected by the City Council as well as the market failure that the Rafferty Group has discovered. This will be graph # 7. (45 pts) b. Referencing only your graph, what equilibrium price and quantity did the market generate? (3 pts) c. Referencing only your graph, what is the extent of market failure in this situation? What price and quantity are consistent with an efficient level of spraying? (6 pts) d. Given that there is market failure, provide one solution for how the efficient level of mosquito spraying can be achieved. (6 pts) Graphs for this assignment must be properly constructed and created using Excel. Prepare your assignment as a Word document with embedded Excel charts. Number each step of the assignment. The g

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Macroeconomics

Authors: Paul Krugman, Robin Wells

4th Edition

1464110379, 9781464110375

More Books

Students also viewed these Economics questions

Question

give a definition of quantitative job demands;

Answered: 1 week ago