Summit Farms hires unskilled daily workers to pick strawberries in their fields. Output depends on the number of workers and on random factors such as weather. Summit Farms wishes to estimate its short run production function and has collected the following data over 15 days on the number of workers,Land output,q, measured in pounds of strawberries.

Question 7.3

a. Using Excel€™s Regression tool to estimate a production function of the form q = aL² + bL³ for Summit Farms. This production function implies that output is zero when L = 0. Therefore, you should set the constant term in the regression to zero, which is an option in the Regression tool.

b. Use the estimated function and Excel€™s charting tool to plot the estimated total product, average product of labor and marginal product of labor curves.

Transcribed Image Text:

Day 11 12 3 4 10 13 14 15 11 10 10 12 10 490 494 385 478 432 480 399 442 331 324 442 448 250 500 317