Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. (7pts) Use Excel to create and graph isoquant curves: Open up Excel and right click on the worksheet tab in the lower right corner

image text in transcribed
3. (7pts) Use Excel to create and graph isoquant curves: Open up Excel and right click on the worksheet tab in the lower right corner that says, "sheet1." From the drop down menu, choose "rename" and name it "production." Use column A to store possible values for L in 5-unit increments. Use the first row to label the column. Put a 5 in the second row. Put the formula "=a2+5" in the third row. Copy this formula in rows 4-25. Use column B to store the isoquant for 6 units of output. This is the amount of K that is needed to combine with each possible value of L to produce 6 units of output. Label this column "q=6." Use the equation from question 1, with q = 6. Note: use $a2 in your formula so that you can easily cut and paste. Use column C to store the isoquant for 12 units of output. This is the amount of K that is needed to combine with each possible value of L to produce 12 units of output. Label this column "q=12." Use the equation from questions 1, with q = 12. Use column D to store the isoquant for 18 units of output. This is the amount of K that is needed to combine with each possible value of L to produce 18 units of output. Label this column "q=18." Use the equation from question 1, with q = 18. (6pts) Use scatter-plot to graph the isoquants. To do this, highlight the area that includes columns A, B, C and D for rows 1-25. Choose scatter-plot with smooth lines. Format your graph so that it has a title and each of the axes are labeled. To do this, click on the graph and the "chart design" tool bar will appear. Look for 'Chart Layouts" and click on "Layout 1." Type in your axis labels and your graph title as "Isoquants". Adjust the vertical axis to have a maximum of 18,000 and fix the major unit to 1000. To do this, click on the values on the horizontal axis to isolate them, then right click and select "format axis". Then, for maximum select "fixed" and enter 18,000, and similarly select the major unit. Adjust the horizontal axis to have a maximum of 120 and fix the major unit to 10. Right click on the horizontal axis again and click "add major grid lines." Format the graph to have a title and label for each axis. Drag the bottom down a bit to make the graph easier to see. Cut and paste the graph here: (1pt) Use the graphed information to complete the following table: K 9000 12 9000 18 9000 PC-2

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_2

Step: 3

blur-text-image_3

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

Energy, Foresight And Strategy

Authors: Thomas J Sargent

1st Edition

1317329686, 9781317329688

More Books

Students also viewed these Economics questions