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

Popular posts from this blog

What are some external and internal conflicts that Montag has in Fahrenheit 451?

 Montag, the protagonist of Fahrenheit 451, faces both external and internal conflicts throughout the novel. Some examples of these conflicts are: External Conflicts: Conflict with the society: Montag lives in a society that prohibits books and critical thinking. He faces opposition from the government and the people who enforce this law. Montag struggles to come to terms with the fact that his society is based on censorship and control. Conflict with his wife: Montag's wife, Mildred, is completely absorbed in the shallow and meaningless entertainment provided by the government. Montag's growing dissatisfaction with his marriage adds to his external conflict. Conflict with the fire captain: Montag's superior, Captain Beatty, is the personification of the oppressive regime that Montag is fighting against. Montag's struggle against Beatty represents his external conflict with the government. Internal Conflicts: Conflict with his own beliefs: Montag, at the beginning of th...

In A People's History of the United States, why does Howard Zinn feel that Wilson made a flimsy argument for entering World War I?

"War is the health of the state," the radical writer Randolph Bourne said, in the midst of the First World War. Indeed, as the nations of Europe went to war in 1914, the governments flourished, patriotism bloomed, class struggle was stilled, and young men died in frightful numbers on the battlefields-often for a hundred yards of land, a line of trenches. -- Chapter 14, Page 350, A People's History of the United States Howard Zinn outlines his arguments for why World War I was fought in the opening paragraph of Chapter 14 (referenced above). The nationalism that was created by the Great War benefited the elite political and financial leadership of the various countries involved. Socialism, which was gaining momentum in Europe, as was class struggle, took a backseat to mobilizing for war. Zinn believes that World War I was fought for the gain of the industrial capitalists of Europe in a competition for capital and resources. He states that humanity itself was punished by t...

Where did Atticus take the light and extension cord in To Kill a Mockingbird?

Atticus brings the light to the courthouse jail so that he can protect Tom Robinson.  Atticus learns that Tom Robinson, his client, is in danger.  A group of white men want to prevent the trial and lynch Robinson. He is warned by a small group of men that appear at his house.  He refuses to back down.  Atticus knows that the Cunninghams will target his client, so he plans to sit up all night with... Atticus brings the light to the courthouse jail so that he can protect Tom Robinson.  Atticus learns that Tom Robinson, his client, is in danger.  A group of white men want to prevent the trial and lynch Robinson. He is warned by a small group of men that appear at his house.  He refuses to back down.  Atticus knows that the Cunninghams will target his client, so he plans to sit up all night with Jim if that’s what it takes to protect him.  Atticus tells the men that he will make sure his client gets his fair shake at the law.  “Link, that boy might go to the chair, but he’s not going till ...