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.

Popular posts from this blog

In chapter one of The Great Gatsby, what advice does Nick's father give him? How does this make him a good person to tell this story?

Nick says that his father advised him that, before "criticizing anyone," he "remember that all the people in this world haven't had the same advantages" as Nick.  As a result, Nick claims that he is "inclined to reserve all judgments," presenting himself to the reader as a fair and dispassionate arbiter of character, and thus, a reliable narrator.   The problem is that Nick immediately reveals himself as anything but reliable, as he then launches... Nick says that his father advised him that, before "criticizing anyone," he "remember that all the people in this world haven't had the same advantages" as Nick.  As a result, Nick claims that he is "inclined to reserve all judgments," presenting himself to the reader as a fair and dispassionate arbiter of character, and thus, a reliable narrator.   The problem is that Nick immediately reveals himself as anything but reliable, as he then launches into a discussion of how pe...

How did the United States become an imperial power?

"Imperial power" is a bit of a vague label. It tends to mean several things at once, so let's unpack it. In the sense of "this country was built on conquest by force," the "imperial power" part of America actually predates the United States proper. The territories that would become the United States were imperial colonies, established by the great European empires of the 17th and 18th centuries. Much of the US Constitution and American governance generally goes back to England, history's largest and most successful imperial power, but vital aspects of American culture come from other imperial powers, such as France and Spain. Much of American culture comes from sources other than the old empires, but they were key influences on what the United States became. In the sense of "this country treats conquest by force as a fundamental component of its culture, economy and politics," the United States has always been an imperial power. Even earl...

How and why does James Gatz become Jay Gatsby? Describe the young Gatsby/Gatz.

James Gatz, a poor Midwestern boy of probable Jewish lineage, becomes Jay Gatsby, a presumed WASP and wealthy socialite, when he moves to New York City and acquires his fortune. It is wealth that has allowed Gatz to transform himself into Gatsby. However, those who know his background (e.g., Daisy and Tom Buchanan) never allow him to forget that he is nouveau riche -- that is, an upstart who has just recently made his fortune,... James Gatz, a poor Midwestern boy of probable Jewish lineage, becomes Jay Gatsby, a presumed WASP and wealthy socialite, when he moves to New York City and acquires his fortune. It is wealth that has allowed Gatz to transform himself into Gatsby. However, those who know his background (e.g., Daisy and Tom Buchanan) never allow him to forget that he is nouveau riche -- that is, an upstart who has just recently made his fortune, whereas they arose from well-to-do families. Gatz became Gatsby through determination and discipline. At the end of the novel, the narr...