ECON 3020
Spring 2013
Dr. Tufte
Homework 9
Due: at the start of class on Monday, April 15.
Continue working with the spreadsheet you used for Homework 8.
1) In columns H through N, create the ratios of the 6 variables in columns B through G by dividing by labor.
2)
Use a formula in column O to copy the values over from column I. You
will now have
in two columns. Now,
in column P create
. You can check your
work: since
and
, columns O and P
should be equal.
3) In the range G7 to L8, enter your values for output-to-labor and capital-to-labor ratio.3704