posted by queen on .
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.