Graphing Assignment #1 – due at the end of week # 1
THIS IS COPYRIGHTED MATERIAL
You are the Economic Minister of Econoland. You will be making a formal presentation
about your Economic ideas concerning the Production Possibilities Frontier (PPF) of
Econoland during the years 1989-2019 to the Prime Minister. Econoland produces two
goods – shoes (measured in millions of pairs) and flat screen computer monitors
(measured in thousands of units). Econoland uses the British Pound as its currency.
THIS IS COPYRIGHTED MATERIAL
The PPF you will be using is the fourth graph in your presentation; shoes will be located
on the Y axis in your graph. The title of your formal presentation in “Measuring
Econoland’s Production.” All your data was derived from Glenn Rennert’s article
“Reconciling Production Metrics,” published in the August 2022 edition of the Journal of
Economics, volume 19, pages 21-28. THIS IS COPYRIGHTED MATERIAL
THIS IS COPYRIGHTED MATERIAL
The PPF data is below:
Shoes: 0 15 30 45 60 75
Screens: 125 115 100 80 50 10
A-Clearly and accurately construct a line graph using Excel based on all the information
above. (40 pts) THIS IS COPYRIGHTED MATERIAL
B- Calculate and interpret the slope of the line you have graphed. Pick any two points.
Assume the line between your two points is straight for part b of this assignment. Show
all work. (10 pts) THIS IS COPYRIGHTED MATERIAL
C-. Referring only to this graph, how does this PPF exhibit opportunity cost and
increasing opportunity? Be specific. 10 pts THIS IS COPYRIGHTED MATERIAL
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 assignment may be submitted to Turnitin as a Word
or .pdf document. Be sure to include your name at the top of the assignment before
submitting. This graphing assignment is worth 60 points
