managerial economics
posted by queen
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 shortrun 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
Similar Questions

Economics
You are planning to estimate a shortrun 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 … 
managerial economics
labor usage 3,7,9,11,17,17,20,24,26,28,30 output1,2,3,5,8,10,15,18,22,21,23 a. does a cubic equation appear to be a suitable specification, given these data? 
economics
You are planning to estimate a shortrun 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 … 
economics
You are planning to estimate a shortrun 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 … 
Economics
Help me on this one please? labor usage 3,7,9,11,17,17,20,24,26,28,30 output1,2,3,5,8,10,15,18,22,21,23 a. does a cubic equation appear to be a suitable specification, given these data? 
Economics
Please Help You are planning to estimate a shortrun 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 … 
Economics
Please help me on this one! You are planning to estimate a shortrun 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 … 
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? 
economics
You are planning to estimate a shortrun 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 … 
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 …