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