Skip to main content

Suppose that the demand curve for chocolate covered ants (CCA) is P=50-5QD, where P is the Price per pound (in dollars) of CCA and QD is the...

We're specifically asked to draw the diagram in Excel charts. To do that, we need to first make a spreadsheet in Excel, then use the charting function to actually make our charts.

Excel likes to draw charts as scatter plot graphs; so we need to find a way to draw our supply and demand curves as scatter plots.

A good way to do that is to first make a column of values for our independent variable (quantity), over a suitable range. Since the demand is P = 50 - 5 Q, it makes sense to go from Q = 0 to Q = 10, and steps of 1 make sense. (If it had been 500 - 5 Q for example, we might have wanted to do Q = 0 to Q = 100 in steps of 10 instead.) Let's make that column A.

Then make a column for supply and a column for demand, and enter the supply and demand curves as formulas, and copy those into each cell in the appropriate column.

For supply the equation "P = 5 Q" becomes the Excel formula "= 5*A2".

For demand the equation "P = 50 - 5 Q" becomes the Excel formula "= 50 - 5*A2".

As you copy-paste the formula from cell to cell, notice how it changes the "A2" to "A3", etc. as necessary to make it correspond to the column next to it. Excel will do this automatically; if you don't want it to do this, use dollar signs, e.g. "$A$2".

Now graph these, and the result should come out something like the first part of the image I posted (it may vary depending on your precise graph settings and colors). Make sure to choose a line graph and set the first column as the label.

Now we want to add the price ceiling. That should be drawn as a flat line at P = 10, so just make a whole column for the price ceiling that is 10 all the way down. The result should look like the second part of the image I posted.

To complete our diagrams, we should also add some labels, which we can do right within Excel using text boxes. I've put the word "equilibrium" at the point which is the equilibrium quantity and price. These versions form the third and fourth part of my image.

Customize these graphs by changing the color schemes or adding more labels.

In terms of the actual economics, notice how the price ceiling reduces the quantity sold from 5 to 2 while reducing the price from $25 to $10. It also creates a shortage, because the demand at $10 is 40 but only 5 are actually available for sale. This is in general what a binding price ceiling will do; it reduces the quantity sold and creates shortages.

Comments

Post a Comment

Popular posts from this blog

What is the meaning of "juggling fiends" in Macbeth?

Macbeth is beginning to realize that the three witches have been deceiving him since he first encountered them. Like jugglers, they have kept changing their forecasts in order create confusion. This is particularly apparent when the Second Apparition they raise in Act IV,   Scene 1 tells him that no man of woman born can overcome him in hand-to-hand battle--and then Macbeth finds himself confronted by the one man he has been avoiding out of a... Macbeth is beginning to realize that the three witches have been deceiving him since he first encountered them. Like jugglers, they have kept changing their forecasts in order create confusion. This is particularly apparent when the Second Apparition they raise in Act IV,   Scene 1 tells him that no man of woman born can overcome him in hand-to-hand battle--and then Macbeth finds himself confronted by the one man he has been avoiding out of a sense of guilt, and that man tells him: Despair thy charm. And let the angel whom thou still hast serve...
Post a Comment
Read more

Discuss movements that were inspired by the Civil Rights Movement and list one success for each group.

African-Americans contributed in a very big way during World War II. These contributions were demonstrated at home and on the battlefield. After the war, African-Americans properly felt it was time for them to achieve equality with white Americans. During the 1950's, the modern Civil Rights Movement was born and it had a number of successes (integration of the military and Brown vs. Board of Education as examples.) This success inspired other activists to demand change... African-Americans contributed in a very big way during World War II. These contributions were demonstrated at home and on the battlefield. After the war, African-Americans properly felt it was time for them to achieve equality with white Americans. During the 1950's, the modern Civil Rights Movement was born and it had a number of successes (integration of the military and Brown vs. Board of Education as examples.) This success inspired other activists to demand change for their agendas. Two examples of moveme...
Post a Comment
Read more

In Martel's Life of Pi, how does writing a diary help Pi Patel build on his leadership skills?

At the end of chapter 73, Pi first divulges the fact that he had started a diary after about a week alone at sea. Pi claims that he wrote about "practical stuff" (208) such as what he caught for food, foreseeable problems and solutions, Richard Parker, and reflections about specific events that occurred. In a sense, Pi is the captain of his ship; therefore, he must take responsibility for himself and his crew. He can... At the end of chapter 73, Pi first divulges the fact that he had started a diary after about a week alone at sea. Pi claims that he wrote about "practical stuff" (208) such as what he caught for food, foreseeable problems and solutions, Richard Parker, and reflections about specific events that occurred. In a sense, Pi is the captain of his ship; therefore, he must take responsibility for himself and his crew. He can do this by writing down events, problems and solutions, and reflections to look back on when confronted with repeated problems. It can ...
Post a Comment
Read more