Post a New Question

managerial economics

posted by .

my cubic equation is O=C+aL+bL^2+cL3 how can i get the excel to help me to do this equation.I need to do a regression analysis to estimate the firm's short-run production function.
see tarha question dated july 2,2007 for all of the information thank you

first, plug your output and labor vectors into EXCEL. Then create new columns (or rows, depending on how you entered your O and L vectors). The new columns contain values for L^2 and L^3.

EXCEL can do linear regressions using the LINEST function. Its a pain to use and rather "klugey" -- use the EXCEL help to get the right format, etc.


Lotsa luck.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Economics

    You are planning to estimate a short-run production function for your firm, and you have collected the following data on labor usage and output. Labor usage output 3 1 7 2 9 3 11 5 17 8 17 10 20 15 24 18 26 22 28 21 30 23 (a) Does …
  2. managerial economics

    labor usage -3,7,9,11,17,17,20,24,26,28,30 output-1,2,3,5,8,10,15,18,22,21,23 a. does a cubic equation appear to be a suitable specification, given these data?
  3. economics

    You are planning to estimate a short-run production function for your firm, and you have collected the following data on labor usage and output: Labor usage Output 3 1 7 2 9 3 11 5 17 8 17 10 20 15 24 18 26 22 28 21 30 23 Does a cubic …
  4. economics

    You are planning to estimate a short-run production function for your firm, and you have collected the following data on labor usage and output: Labor usage Output 3 1 7 2 9 3 11 5 17 8 17 10 20 15 24 18 26 22 28 21 30 23 Does a cubic …
  5. Economics

    Help me on this one please? labor usage -3,7,9,11,17,17,20,24,26,28,30 output-1,2,3,5,8,10,15,18,22,21,23 a. does a cubic equation appear to be a suitable specification, given these data?
  6. Economics

    Please Help You are planning to estimate a short-run production function for your firm, and you have collected the following data on labor usage and output: Labor Output 3 1 7 2 9 3 11 5 17 8 17 10 20 15 24 18 26 22 28 21 30 23 a.Does …
  7. Economics

    Please help me on this one! You are planning to estimate a short-run production function for your firm, and you have the following data on labor usage and output: Labor Output 3 1 7 2 9 3 11 5 17 8 17 10 20 15 24 18 26 22 28 21 30 …
  8. Managerial Economics

    Help me on this one please? labor usage 3,7,9,11,17,17,20,24,26,28,30 output 1,2,3,5,8,10,15,18,22,21,23 a. does a cubic equation appear to be a suitable specification, given these data?
  9. economics

    You are planning to estimate a short-run production function for your firm, and you have collected the following data on labor usage and output: Labor Usage: 3 7 9 11 17 17 20 24 26 28 30 Output: 1 2 3 5 8 10 15 18 22 21 23 1) does …
  10. Managerial ECON

    You are planning to estimate a short- run production function for your firm, and you have collected the following data on labor usage (L) and output (Q): Labor usage Output 3 1 7 2 9 3 11 5 17 8 17 10 20 15 24 18 26 22 28 21 30 23 …

More Similar Questions

Post a New Question