Regression package estimate a production function

Reference no: EM131071086

5. Daily Production Data
Day	L	q
1	5	250
2	7	385
3	8	442
4	6	331
5	6	324
6	8	442
7	10	500
8	11	478
9	12	432
10	9	490
11	10	480
12	10	494
13	8	317
14	7	399
15	8	448

1) Using Excel's Regression package estimate a production function for Summit Farms which is of the form: q =aL³ + bL². Provide the detailed regression output generated by Excel. Identify the estimates of the coefficients a and b. Write the equation for the estimated production function. Identify the value of R² .

If you are using a Mac you can use the linest function key for running the regression.

2) Using the estimated function and Excel's charting tool plot the Total Product of Labor (TPL), the Average Product of Labor (APL) and the Marginal Product of Labor Curves. Are these graphs and thus the estimated cubic production function consistent with standard TPL, APL and MPL curves?

Reference no: EM131071086

Questions Cloud

Identify a problem or concern in your community : Identify a problem or concern in your community, organization, etc. that has the capacity to be legislated. You will conduct research and state a proposal.

How much energy is stored in the inductor : The voltage v(t) shown in Figure 1a is given by the graph shown in figure 1b. If iL(0) = 0, determine the following by simulating the given circuit in MultiSim: How much energy is stored in the inductor at t=3 secs

Explain why the ph increases on addition of sodium acetate : Explain why the pH increases on addition of sodium acetate. What reagent (chemical agent) do you weigh out that ends up being the source of the [Fe(H2O)6]3+?

Medical and nursing staff affected the delivery of care : How has the evolution of medical technology, graduate medical education, and the professionalization of medical and nursing staff affected the delivery of care

Regression package estimate a production function : 1) Using Excel's Regression package estimate a production function for Summit Farms which is of the form: q =a L3 + bL2. Provide the detailed regression output generated by Excel.

Characteristics of good partner in strategic alliance : What are the characteristics of a good partner in a strategic alliance? Why do these partner traits help make a strategic alliance successful?

How do you calculate the cost of electricity : Utility company in one of the western states is considering the addition of 50 megawatts of generating capacity to meet expected demands for electrical energy by the year 2016. This assumes that brownouts will occur during high demand periods. Projec..

The canadian fast food market with burger king : Wendy's shares 2nd place in the Canadian fast food market with Burger King. The company has been floundering ever since the campaign that featured Dave Thomas (the founder of Wendy's) was terminated.

How the earthworm is structurally and reproductively : Explain how the earthworm is structurally and reproductively suited for survival on land, despite them being slow in locomotion and bone less.

User Account

All Pages